If you have Microsoft Access 2010 or a later version, you can easily convert your Access reports to PDF without using Adobe Acrobat Pro. Use the File tab or the External Data tab on the Ribbon or you can customize the Quick Access Toolbar. I'm trying to send an existing Access Report as an attachment via MS Outlook. The SendObject method is not an option. Since, the report i'm trying to send is an access object it is not stored at a particular path on the PC/network.
I'm looking for a very simple solution here. I simply want a vba script that I can run over and over again to save the same Access report (that changes as the weeks go by) into the same file over and over again. I need it to be the same name each time and don't want to be prompted that the filename is already there. In my research, it feels like the following should work but it does not. Can anyone provide a simple script that performs this task?
HansUp1 Answer
Add a line continuation character (underscore: _) to indicate the line following DoCmd.OutputTo should be considered part of the same logical instruction:
The line continuation character must be preceded by at least one space, and there can be no characters after the line continuation.
HansUpHansUpSending Ms Access Reports To Pdf Via Vba Codes
