RE Bulk Email with Access..?

Subject: RE Bulk Email with Access..?
From: "John Fleming" <johnf -at- ecn -dot- ab -dot- ca>
To: "TECHWR-L" <techwr-l -at- lists -dot- raycomm -dot- com>
Date: Thu, 24 May 2001 09:41:06 -0600

> Subject: Bulk Email with Access..?
> From: "Diana Barnum" <dbarnum -at- columbus -dot- rr -dot- com>
> Date: Wed, 23 May 2001 09:34:20 -0400
> X-Message-Number: 16


> Can you send bulk emails, though, or am I missing that section in
the book?
> (I'm not a cover to cover reader - only do "chunk reading"). I
heard that
> ACT software, I believe, has this capability. Does Access or any of
> other Office 2000 family?


The way to do what you have in mind is to use your Access 2000
database as a data source in a Word 2000 mail merge.

Here's what you do.

When you set up your "form letter," tell Word to use your Access
database as your data source.

Then create the "form letter" in Word. This will have all the
information you want to send to your clients.

Finally, do the mail merge, and use e-mail as your output.

You can find the exact steps in a reasonably good Word reference, like
Que's "Special Edition Using Word 2000."

In your case, Word will export over 100 e-mails to your e-mail
software, one for each client. (I'm assuming your e-mail software is
something that Office likes, like Outlook or Outlook Express.)

BTW, I did a similar e-mail mail merge earlier this year when I was
looking for help with a Toastmasters Speechcraft program using an
Excel spreadsheet as my data source and Outlook Express as my e-mail
client. The personalized touch created a much better response.

> I need to send 1 e-mail to over 100 clients frequently, but want
> addresses to remain confidential. Any tips? Put addresses in Blind
Copy or
> something?


John Fleming
Technical Writer
Edmonton, Alberta
email: johnf -at- ecn -dot- ab -dot- ca


*** Deva(tm) Tools for Dreamweaver and Deva(tm) Search ***
Build Contents, Indexes, and Search for Web Sites and Help Systems
Available now at or info -at- devahelp -dot- com

Sponsored by Information Mapping, Inc., a professional services firm
specializing in Knowledge Management and e-content solutions. See or 800-463-6627 for more about our solutions.

You are currently subscribed to techwr-l as: archive -at- raycomm -dot- com
To unsubscribe send a blank email to leave-techwr-l-obscured -at- lists -dot- raycomm -dot- com
Send administrative questions to ejray -at- raycomm -dot- com -dot- Visit for more resources and info.

Previous by Author: RE Is a bad index better than no index?
Next by Author: RE: Need help please respond + Toastmasters
Previous by Thread: Re: Visual Communications
Next by Thread: Need Help With Word Numbering

What this post helpful? Share it with friends and colleagues:

Sponsored Ads