Re: Emailing with Access

On Apr 29, 11:42 am, timmg <tmillsgronin...@xxxxxxxxx> wrote:
On Apr 29, 1:30 pm, marjb...@xxxxxxxxx wrote:

I have a Access database of email addresses that I would like to mass
email to customers. Can Access be used through Outlook? or can it just
be done with Access? I know it is possible to use MailMerge for
snailMail.

You may want to consider using MS Word.  Create the document as you
would any mail merge using a query of your Access data as the data
source.  Select "Merge to Email" as your output option.

I like this approach because it allows personalization of the outgoing
message ("Dear Tim, you've been a member of XYZ for 12 years") and
it's easy to assign the task to any staff person (all they really need
to know if Word).

Note that your ISP may not like the volume of messages going out
through Outlook/Exchange and it can take a while to cycle through
several thousand records.  Then you'll have to sort through the
undeliverable/returned mail, but that can be quite an education about
your customers.

For a large volume solution you may want to look at a commercial email
service such as Constant Contact or similar.

Good luck,

Tim Mills-Groninger

Thank you for your suggestion. Yes, I believe that would work whether
it was in Word or Excel. But as you say it would be a lot of training
for my customer.
.

Relevant Pages

  • Re: Emailing with Access
    ... email to customers. ... Can Access be used through Outlook? ... would any mail merge using a query of your Access data as the data ... Tim Mills-Groninger ...
    (comp.databases.ms-access)
  • Re: Combing Multiple User Contact Folders into One Shared Folder.
    ... "This centralized Outlook folder would also be used on an ongoing basis, ... meaning as the users add new customers to their individual Outlook contacts, ... both allow for updating of "existing" info with filter capability to target ...
    (microsoft.public.outlook.contacts)
  • RE: [fw-wiz] Re: Anybody Recognize These Uploads?
    ... As functionality is added, because customers want it, so are ... because of customer wants, they're added as marketing feature draws, or ... happy with a copy of Outlook that simply wasn't capable of rendering HTML ... (the client, not funky filtering between the client and the server, and ...
    (Firewall-Wizards)
  • Re: Bulk emailing from Access Database
    ... You definitely can send emails to your customers using email addresses ... Use Outlook Automation. ... distribution lists. ...
    (microsoft.public.access.setupconfig)
  • Re: Outlook 2007 Deployment
    ... I have tried to run the MSI file for Outlook locally to test ... Well, first, I'm curious, you purchased licenses for your *customers* to ...
    (microsoft.public.outlook)