Sending Email from Access via Lotus Notes

[SarahEGray]

I have a database and I want to be able to send out an email to everyone
within the employees table (tblemployees) that has an email address, I have a
field called EmailAddress and this has been pre-set as a hyperlilnk using
"mailto:".

I basically just want to have a command button that will email all employees
who have email addresses witin the list every 6 months, I do not want to
attach anything but do want some text to show in the body of the email.

I am using Access 97 and Lotus Notes 5.0.8.

Any help would be very much appeciated.

 

[Daniel Pineault]

Here are a few Lotus Notes emailing functions that you can inspire yourself
from

http://www.fabalou.com/VBandVBA/lotusnotesmail.asp
http://groups.google.ca/group/micro...read/thread/86f7781372ee2e48/6c569c6a640b2e99

 

[Tony Toews [MVP]]

I have a database and I want to be able to send out an email to everyone
within the employees table (tblemployees) that has an email address, I have a
field called EmailAddress and this has been pre-set as a hyperlilnk using
"mailto:".

I basically just want to have a command button that will email all employees
who have email addresses witin the list every 6 months, I do not want to
attach anything but do want some text to show in the body of the email.

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 character, such as comma or
semi-colon, 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

Microsoft Access Email FAQ - Lotus Notes
http://www.granite.ab.ca/access/email/lotusnotes.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/