email reports ... need a bit of help guys!

[paulmcdonnell]

Hi GUYS, How's developing going?


I'm trying to email a report as an attachment I can send it as a HTML or TF file using :

DoCmd.SendObject acReport, strNewRepName, "HTML (*.html)", _
Me.email, , , , , True.

But I loose all my table format etc. How can I email a report to look like a table. or can I email a query... Not sure on this one..If anyone's done this before could you advise...


cheers
paul

 

[BukHix]

I think you may be able to use snapshot for that purpose. Here is a thread with a little more info:

Topic: ways to keep reports original format.....