Sending bulk email from Access Form

[Thomas Kroljic]

I'm curious to find out what other folks are doing with regard to sending
bulk email out from an Access table/query.
Are they coding (vba) this themselves and sending out one email at a time
or are they extracting the data from Access and then using a 3rd party
solution to send out the emails?

Just curious,
Thank you,
Thomas Kroljic

ps - if this is posted in the wrong area, I apologize. Please let me know
which forum would be correct.

 

[Danny Seager]

Generally I just loop the recordset and send 1 out at a time... This works
fine... but I suppose it depends on what you mena by "bulk".. are you talking
millions?

 

[UpRider]

I create a query to extract the email address, name, etc., then export the
data directly into an Outlook Contact folder. Then I switch to Outlook's
Mail Merge to Email to send the email.

UpRider

 

[Thomas Kroljic]

Danny,
"Bulk" = anything from one to two hundred unique email addresses at a
time.

The other piece to this puzzle is that the all our email goes there the
company MS Exchange database. I'm hoping that this doesn't cause a problem.

 

[Thomas Kroljic]

UpRider,
Do you find this to be an advantage doing it this way compare to just
sending it out directly from Access using vba code?

 

[Arvin Meyer [MVP]]

If it's the same message, see:

http://www.datastrat.com/Code/MultipleEmail.txt

 

[Tony Toews [MVP]]

I'm curious to find out what other folks are doing with regard to sending
bulk email out from an Access table/query.
Are they coding (vba) this themselves and sending out one email at a time
or are they extracting the data from Access and then using a 3rd party
solution to send out the emails?

I send out my emails one at a time as they are always customized with
the users name and such in the subject so as to avoid being seen as
spam. As well as customized in the body.

Also see the Microsoft Access Email FAQ
http://www.granite.ab.ca/access/email.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[UpRider]

Thomas, this method allows me to use a WORD mail merge (via OUTLOOK). The
emails are personalized using a main Word document. I also have a record of
recipients, (the contents of the Outlook Contacts folder).
It's just kinda the way it evolved for me when I developed the app.

UpRider

 

[Thomas Kroljic]

Tony,
I saw this (your response) the other day to another user. I'll probably
go this route. Thanks.

 

[Thomas Kroljic]

I believe if you use vba logic within (behind) your Access form, you can
still personalize your emails and still get a record of it in the Sent
folder of our Outlook.

But since you have a process that is already working for you, why change.

Thanks for your response. Appreciate it.

 

[Thomas Kroljic]

Arvin,
Thanks for responding. I will probably use something similar to the vba
code you reference in the link below.
Thanks.