Send e-mails using Access

[Dotty]

Hi. In Access 2007, I want to send e-mails, the data for which comes from two separate tables. I need to be able to select the correct data from the first table and then the corresponding date and further information from another. Once collected, I want to send out e-mails to several people in one hit using a pre-set template. I'm told going into word and importing it from Access is a good way, but I also believe you can do it directly through Access. Firstly, can information collected in a query be exported for this purpose and secondly does anyone know how I can e-mail it out? I'd be really grateful for any help you can offer. Thanks.

[RuralGuy]

My favorite email link: http://www.granite.ab.ca/access/email.htm

[ajetrumpet]

My favorite email link: http://www.granite.ab.ca/access/email.htm

I love it when you post this stuff, Alan. This link is incredibly outdated. and most of the links for the examples are broken at this point in time. Unless the url's have a problem with chrome.

[alansidman]

Adam-
Using IE9 and all the links work for me. Guess Chrome is a little rusty.

Alan

[ssanfu]

Adam-
Using IE9 and all the links work for me. Guess Chrome is a little rusty.

Alan

No problems with Firefox 6.0.1, either