<div>
Have you considered attaching the report as a snapshot?
</div>


Have you considered attaching the report as a snapshot?

<div>
I am sending these reports to 700 customers, so it is not practical. &nbsp;I wan' them to be able to open file without getting extra software and without any hassle. &nbsp;PDF is the best in this case, everybody can open it and it will retain all formatting.
</div>


I am sending these reports to 700 customers, so it is not practical.  I wan' them to be able to open file without getting extra software and without any hassle.  PDF is the best in this case, everybody can open it and it will retain all formatting.

Access-BasicConvertReportToPDFAn.mdb

<div>
Hello<br />
I used lebans code, worked perfectly on the A97<br />
<br />
Thanks
</div>


Hello
I used lebans code, worked perfectly on the A97

Thanks

<div>
Great!<br />
<br />
Congratulations!<br />
;-)<br />
<br />
Jeff
</div>


<div>
<div class="content wysiwyg-content">
Hello<br />
<br />
I want to have a email button on a form, this will automatically email Access report as a PDF using Outlook.<br />
<br />
Only way I can think this can be done is to use PDF Printer (I have chosen to use PDFCreator) and save PDF file into the folder. &nbsp;Next step is to email this PDF file using Outlook.<br />
<br />
Can you please provide VBA code to do this.<br />
<br />
ps. I used &nbsp;SendObject to HTML, this worked fine, but I loose too much of the formatting, also it prints multipages reports into multiple HTML files and what I really need is PDF files I can send to customers.<br />
<br />
Access Version 97<br />

</div>
</div>


Hello

I want to have a email button on a form, this will automatically email Access report as a PDF using Outlook.

Only way I can think this can be done is to use PDF Printer (I have chosen to use PDFCreator) and save PDF file into the folder.  Next step is to email this PDF file using Outlook.

Can you please provide VBA code to do this.

ps. I used  SendObject to HTML, this worked fine, but I loose too much of the formatting, also it prints multipages reports into multiple HTML files and what I really need is PDF files I can send to customers.

Access Version 97


Email Access Report using PDFCreator and Outlook

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.