E-mailing using E-mail recipients in Access Table

I have a database which will check for certain conditions and e-mail recipients if certain criteria is met. This works fine, however I need to create a mailing list to be stored as a table within Access.

I currently use the 'Sendobject' in a macro to send e-mails to addresses listed in my Outlook address book. I now need to store and create a distribution list of recipients in a table within Access rather than using my Outlook addressbook.

Please can anyone advise how to set the 'To' option in Sendobject to use the list of recipients stored in the address table rather than trying to use the outlook addessbook.

If there is a better way of e-mailing than using the 'Sendobject' command and can be done without installing third party software, this is also an option I could look into.

Many thanks in advance.
Dave

"Dave Davies" Dave wrote:

I have a database which will check for certain conditions and e-mail recipients if certain criteria is met. This works fine, however I need to create a mailing list to be stored as a table within Access.

I currently use the 'Sendobject' in a macro to send e-mails to addresses listed in my Outlook address book. I now need to store and create a distribution list of recipients in a table within Access rather than using my Outlook addressbook.

Please can anyone advise how to set the 'To' option in Sendobject to use the list of recipients stored in the address table rather than trying to use the outlook addessbook.

You will need to use VBA code to run through a recordset either:
1) concatenating the email addresses to a string along with a comma,
sem-colon or other appropriate separator and then send one email with
all the bcc addresses;
2) individually send the emails.

Your method of sending emails may have some restrictions as to the
number of email addresses in the bcc field or the length of data in
that field.

For sample recordset logic see
http://www.granite.ab.ca/access/email/recordsetloop.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

"Dave Davies" Dave wrote:

I have a database which will check for certain conditions and e-mail recipients if certain criteria is met. This works fine, however I need to create a mailing list to be stored as a table within Access.

I currently use the 'Sendobject' in a macro to send e-mails to addresses listed in my Outlook address book. I now need to store and create a distribution list of recipients in a table within Access rather than using my Outlook addressbook.

Please can anyone advise how to set the 'To' option in Sendobject to use the list of recipients stored in the address table rather than trying to use the outlook addessbook.

You will need to use VBA code to run through a recordset either:
1) concatenating the email addresses to a string along with a comma,
sem-colon or other appropriate separator and then send one email with
all the bcc addresses;
2) individually send the emails.

Your method of sending emails may have some restrictions as to the
number of email addresses in the bcc field or the length of data in
that field.

For sample recordset logic see
http://www.granite.ab.ca/access/email/recordsetloop.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