sending an email from access 2002 HELP PLEASE!

[Al Heyne]

Hi All,
I have a slight problem and I know I must be missing
something easy. I have built a standard database in access
2002 that I use for keeping track of my customer quotes. I
would like to be able to send the quote from a single
record to an email for my clients. I know that you can
use "send to" to email the record as an attachment (after
selecting it), but i'm really bummed out about the
formatting of the html. It lists everything in a single
row of a table. I'd like to make it look a little better,
but I'm confused about how to go about it. I have even
created a different form to include only the fields that I
want my customers to see. I noticed it will let you use a
template , but i'm baffled about how to format the
template. (have tried editing a template file to no avail)
Any help would be greatly appreciated. I'm stumped. Can I
send an email of a single record from a report? or should
is there a way to format the html output from the form
record using the send to?
Thanks again in advance.
AL

 

[Denny G.]

Al, here is what I would do:

1. Make a report for your quote data and base the report
on a parameter query that asks for the name of your
client.

2. Display the report in Access and then go to File/Send
To/Mail Recipient . . ./Snapshot Viewer (if you have that
option). Otherwise:

3. Display the report in Access and then go to File/Send
To/Mail Recipient . . ./Rich Text Format (RTF) RTF does
a pretty good job of formatting your report the same as
displayed on your computer but without the graphics.

4. What I do is to display the report in Access and then
make a PDF file out of it using PDFCreator (FREE) from
http://sourceforge.net/search/. I then attach the PDF
file to the e-mail and send a beautiful report that
includes all formatting just as you designed it.

Hope this helps.

Denny G.