Sending custom email via Access 2002

  • Thread starter Thread starter Terry G
  • Start date Start date
T

Terry G

I want to send a custom email based upon a customers data.
This is a personalized letter stating that we have
received their order. It then retrieves data from several
access tables and inserts it into the email invoice.

We then want to display the email from within Access so we
can review and do any modifications before sending to
receipient.

We do not want to use the SendObject method because it
does not allow us to move within the Access program it
needed.

Our main goal is to Press a button to run the VBA code,
Create the custom invoice, display the email within
Access, and be allowed to press send.

We would appreciate any help that you may have. Thanks.
 
Terry G said:
I want to send a custom email based upon a customers data.
This is a personalized letter stating that we have
received their order. It then retrieves data from several
access tables and inserts it into the email invoice.

We then want to display the email from within Access so we
can review and do any modifications before sending to
receipient.

We do not want to use the SendObject method because it
does not allow us to move within the Access program it
needed.
Click to expand...

You'll probably want to use a third party control then. See the
Access Email FAQ at my website for a list of such.

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
 
Back
Top