Go Back   Access World Forums > Search Forums

 
Showing results 1 to 4 of 4
Search took 0.00 seconds.
Search: Posts Made By: s_solt
Forum: Reports 09-14-2012, 04:54 PM
Replies: 21
Views: 89,851
Posted By s_solt
Re: Access 2010 PDF and Email a Report Using VBA Code

Finally, finally

You can use DoCmd.OutputTo instead of DoCmd.SendObject

Why not offer a combo with a list of possible formats:

Create a combobox with default value "Preview" and RowSource: ...
Forum: Reports 09-14-2012, 04:34 PM
Replies: 21
Views: 89,851
Posted By s_solt
Re: Access 2010 PDF and Email a Report Using VBA Code

Just to finally round this out...

If you want to send the report straight to email:

On Error Resume Next
DoCmd.SendObject acSendReport, strReport, acFormatPDF, , , , , "Report Attached"
On...
Forum: Reports 09-04-2012, 01:41 AM
Replies: 21
Views: 89,851
Posted By s_solt
Re: Access 2010 PDF and Email a Report Using VBA Code

Hi Sting

You specified a folder but without an explicit drive or root, so Access assumed the path was relative to the default path, in this case My Documents.

Just specify any valid full path:...
Forum: Reports 08-31-2012, 04:22 AM
Replies: 21
Views: 89,851
Posted By s_solt
Re: Access 2010 PDF and Email a Report Using VBA Code

Why not just use the Docmd.SendObject command:



DoCmd.SendObject acSendReport, [name of report], acFormatPDF, "recipient@company.com",[cc email(s)],[bcc email(s)], [Message Subject],...
Showing results 1 to 4 of 4

 
Forum Jump



All times are GMT -8. The time now is 03:26 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World