Sending bulk email from Access Form

  • Thread starter Thread starter Thomas Kroljic
  • Start date Start date
T

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.
 
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?
 
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
 
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.
 
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?
 
Thomas Kroljic said:
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?
Click to expand...

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/
 
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
 
Tony,
I saw this (your response) the other day to another user. I'll probably
go this route. Thanks.
 
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.
 
Arvin,
Thanks for responding. I will probably use something similar to the vba
code you reference in the link below.
Thanks.
 
Back
Top