G
Guest
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
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