Email Format using Access 2007

  • Thread starter Thread starter AndyK
  • Start date Start date
A

AndyK

Can an email be created from a form that contains more than one row of Order
Detail information, in addition to the Order table information? I have sent
& received emails updating a table, but only from a single row of information.
My objective is to create a form with both tables and email them in an Excel
or Table format, for easy updating, and have the reply update my tables.
A purchase order with multiply order items, without pricing, is an example
of the form.
 
Can an email be created from a form that contains more than one row of Order
Detail information, in addition to the Order table information?  I havesent
& received emails updating a table, but only from a single row of information.
My objective is to create a form with both tables and email them in an Excel
or Table format, for easy updating, and have the reply update my tables.
A purchase order with multiply order items, without pricing, is an example
of the form.
Click to expand...

there's an example of this in Access Developers Handbook: Desktop
Edition. They're merging to Word, not Excel, but the idea is the
same. You could use CopyFromRecordset to pass the data from Access to
Excel and fill in a template.
 
AndyK said:
Can an email be created from a form that contains more than one row of Order
Detail information, in addition to the Order table information? I have sent
& received emails updating a table, but only from a single row of information.
My objective is to create a form with both tables and email them in an Excel
or Table format, for easy updating, and have the reply update my tables.
A purchase order with multiply order items, without pricing, is an example
of the form.
Click to expand...

Yes. There are two different methods. One would be to create an
external file, typically PDF although it could be Excel, Word .doc or
..rtf file.

Or you can embed that data in the body of the email. This however
would require using extensive string manipulation and looping through
a recordset.

To create a formatted document to send as an email you will need to
use VBA code to create a largish string. This string will then be
passed to the SendObject command or other method as the body of the
email. For more details including sample air code see my Tips page
on this topic at http://www.granite.ab.ca/access/email/formatted.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/
 
Back
Top