Sending custom email via Access 2002

[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.

 

[Arvin Meyer]

I suggest using a Word template and opening it from Access, feeding the data
from Access to Word bookmarks. Code to do that is one my website:

http://www.datastrat.com/Code/WordMerge.txt

You can make alterations and change formatting in Word, then use Send To
from word to email your letter.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Tony Toews]

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.

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