mj****@umich.edu wrote:
>I'm currently running queries in Access, saving the results to a CSV
file and loading this into a separate vendor SMTP mass email program
(Max Bulk Mail).
I'd like to simplify this process to a single button click in Access.
I'm looking for a plug-in / vendor app that seamlessly integrates with
Access. The only product I've seen is the "Total Access Emailer"
http://www.fmsinc.com/Products/Emailer/index.asp
I need to set different FROM and REPLY TO addresses so I can't use the
"mail through Outlook with the DoCmd" method.
You couldn't use the docmd.sendobject method, correct. However you can use Outlook
VBA code. I think you can change the SendOnBehalfOf setting or something like that
in Outlook in VBA code. Intellisense using a reference and early binding should get
you going on that. Although note that you will need to grant that email account
permissions to use the other Outlook account. Note that I'm very vague on the
details as I havent' done this myself.
>Does anyone have experience with Total Access Emailer?
I've read a few postings indicating folks are happy with it. Also FMS is well known
in the Access world for quite a number of years and put out high quality software.
>Any other recommendations?
Microsoft Access Email FAQ
http://www.granite.ab.ca/access/email.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/