Use Access 2003 to send an email via Lotus Notes to everyone in db

[james]

Hi,
I currently have a database of customer details. One of the fields holds
email addresses. At present to send our daily newsletter I export the
addresses as a text file and copy the addresses to a Group i have set up in
Lotus Notes. I would like to be able to just either click a button and the
addresses in my group in lotus notes update or to have a form in access that
allows me to type my message and add an attachment and then sends a mail to
each email address in my query either through the BCC field or send each
person a message (for privacy). There are over 1000 email addresses in the
list at present. Please bare in mind my Access and programming knowledge is
not great. out of the two options above I would prefer it to just update the
group but not sure if this can be done?
Thanks

 

[Gina Whipp]

I found this by searching the news groups...

Take a look at http://www.fabalou.com/VBandVBA/lotusnotesmail.asp for some
sample automation code for Lotus Notes
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net

 

[Tony Toews [MVP]]

I currently have a database of customer details. One of the fields holds
email addresses.

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

Microsoft Access Email FAQ - Lotus Notes
http://www.granite.ab.ca/access/email/lotusnotes.htm

I would suggest you create another set of tables showing all the
emails you have sent to the customers. This way if there's any
question you can go back to the history and see what you sent.

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/