Emailing

  • Thread starter Thread starter Michelle
  • Start date Start date
M

Michelle

I know how to email using the hyperlink
address=mailto:blah*blah.com

But I want to select multiple users to send an email to
i.e. to tell that the database has been updated.

Thanks for the help,
Michelle
 
Hello Michelle,

When I wish to notify multiple users I use the following :

DoCmd.SendObject , , , "(e-mail address removed)", , "(e-mail address removed)
m", Record Update", "Details contained in the following
record have been updated : "

Build up the list accordingly

Hope this helps you
Mark
 
Michelle

I do a simialer thing to mark but I create a variable
(e.g. strEmailAddress) and populate it with multiple
addresses and use that in the SendObject function. (this
does sometimes crash if there are to many recipients)

Ant
 
Hi Michelle,

You need a couple of things - first a way to select who to send to - a
multiselect listbox works well for this. Then to do the actual sending there
are several different ways - one is to automate Outlook. Here are some KB
articles to help you:

Q161088 Using Automation to Send a Microsoft Outlook Message
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q161088

HOW TO: Use Automation to Send a Microsoft Outlook Message using Access 2000
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q209948

Another good reference (or list of references) is at
http://www.granite.ab.ca/access/email.htm.

Finally, for the easiest approach, check out Total Access Emailer by FMS -
it is very simple to set up and use:

http://www.fmsinc.com/products/Emailer/index.asp
 
Back
Top