Using Outlook to send message to multile Access Recipients

[Guest]

I currently have a large distribution list in Access (1 table called
Employees). If I need to create a message regarding certain events occuring
in the company, how can I get the message to be sent to all the employees
email addresses from that particular table?

Thanks,

 

[Ron2005]

There are at least three choices:

A) if there is already (or a distribution list can be created on your
mail server) then you can use that as the name for the TO:

B) In the VBA code for sending the message, set up everything for the
message and then loop through the email table and concatonate the names
into the TO: and then send it. (If you use this method you may exceed
the limit of 256 for txt fields ( or some other limit in outlook.)

C) Same as B but send an individual email each time as you loop through
the table.

Implications:
For A)
1) The distribution list is maintained external to your application
which may or may not be good for your situation.
2) Since Outlook requires a manual OK to send the message this occurs
only once. Unless you can find some 3rd party software that will get
around that problem

For B)
1) Since Outlook requires a manual OK to send the message this occurs
only once. Unless you can find some 3rd party software that will get
around that problem. Also the problem of size limit may cause a problem
here as noted.
NOTE you could group them into sets of 10 or so but you still have the
OK problem to overcome.

For C) 1) Since Outlook requires a manual OK to send the message this
will occur as many times as you have emails in your list. Unless you
can find some 3rd party software that will get around that problem.

 

[Tony Toews]

I currently have a large distribution list in Access (1 table called
Employees). If I need to create a message regarding certain events occuring
in the company, how can I get the message to be sent to all the employees
email addresses from that particular table?

See the Sample Code illustrating looping through a DAO recordset page
at the Access Email FAQ at
http://www.granite.ab.ca/access/email/recordsetloop.htm

See the Outlook specific links at the Access Email FAQ at my website.
http://www.granite.ab.ca/access/email/outlook.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

 

[MichiganMSAccessExperts]

If you want someone to do this for you, contact Gene at
www.customaccessllc.com

 

[Douglas J. Steele]

Please note that these newsgroups are intended for peer-to-peer help, not
for advertising.