Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Outlook and access how to

Status
Not open for further replies.

Scrambled

Technical User
Jan 10, 2001
1
US
Is it possible to mail an access report as the message body of a mail message and not as an attachment?? Or mail a table but not as an attachement but as the main body of the message??
 
One way, maybe not the best would be to
re-create your report in VBA code and pass it in the Message area of the Docmd. ...
It could be a tremendous amount of work if the report is complicated
Of course it would not have the Appearance of a real report it would look like generic text.

Example:
---------------------------------------------------

My Report

Name Address City State
---------------------------------------------------
Doug 123 Any Street Any Town FL
Sally 383 38th Ave My Town GA



Date Printed 1/1/01 8:00 am

------------------- End of Report -----------------

DougP, MCP
dposton@universal1.com

Ask me how Bar-codes can help you be more productive.
Or visit my WEB site
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top