Emailing

[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

 

[Mark Sippitt]

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

 

[Ant]

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

 

[Sandra Daigle]

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