Better report export format than snapshot? 1

[dreew]

Here's one that frustrates me to no end! <br>
<br>
I know about MS Snapshot export format as useful in creating email-attachable report copies for convenient distribution...well, almost convenient. They have to have the software, too.<br>
<br>
Export to MS Word messes up my report formats, is there a better method? Does MS Access 2000 remedy this problem?

 

[DougP]

You can send a report to an e-mail as a Text or HTML attachment by using the following<br>
VBA example<br>
DoCmd.SendObject acSendReport, &quot;name of your report&quot;, acFormatText, &quot;To e-mail&quot;, &quot;CC-email&quot;, &quot;BCC&quot;, &quot;Subject&quot;, &quot;Additional text&quot;, False<br>
for HTML change the acFormatText to acFormatHTML <br>
find SendObject in Help for details<br>
-or-<br>
in the reports TAB click an highlight your report then Click 'File', Send and do it manually. and you have 4 options.<br>