macro to email report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I make a macro email a report made in Access that is in the body of
the email and not as an attachment? Thanks.
 
It has to be done in vba code.

Do a search in the Access and Access.forms groups. Many examples have
been given in the last couple of months.
 
Ron,

There are some ways, relatively painful I would say, of getting the
*data* from a simple report into the body of the email. Displaying the
report itself, with formatting, grouping, alignment, etc, is another
matter. If you find a way to do that, I would be very interested.
 
Please recipricate. If you find one I would be interested too.

It might be interesting to follow the following link:

http://groups.google.com/group/comp.databases.ms-access/browse_thread...


In it Wayne worked out how to format a simple report using email HTML
format and putting the data in as parts of a HTML table.
And I have also done html formated email bodies in order to add more
font and positional control. A simple relatively short report is doable
with a little work. Beyond that it gets tougher.

Someone added a comment later to that stream that I have not followed
that referenced a product that may do it for you.
 
Back
Top