Access And Email

[Robert McClain]

I have a database (2002 format) with contact information
including an email address. Is there a way to be able to
send an email to the contact by clicking on a button.

I tried setting up the field as a hyperlink and the
adding the "mailto:" to the beginning of the email
address, and that worked fine EXCEPT when I try to do a
mass mailing using my database as the source (it includes
the hyperlink "#" symbols in the email address when
merging).

Thanks for any help in advance!

 

[Arvin Meyer]

I have a database (2002 format) with contact information
including an email address. Is there a way to be able to
send an email to the contact by clicking on a button.

I tried setting up the field as a hyperlink and the
adding the "mailto:" to the beginning of the email
address, and that worked fine EXCEPT when I try to do a
mass mailing using my database as the source (it includes
the hyperlink "#" symbols in the email address when
merging).

Have a look at the Email Senate sample database on my website which does
exactly what you want:

http://www.datastrat.com/Download/EmailSenate2K.zip

BTW, this was recoded from an old database so many of the Senate email
addresses are no longer valid.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Bill Murphy]

Robert,

Also, see the PDF and Email Class Library at:

http://ourworld.compuserve.com/homepages/attac-cg/

Price is reasonable, and works extemely well in an app I've had running for
the last couple of years. Also gives you a lot of PDF conversion features.

Bill

 

[Con Giacomini]

A really excellent Access E-Mailer program is available from FMS. I think
costs about $500.00.

http://www.fmsinc.com/