MS Access 2010 SendObject using .pdf Format for Report
Posted on 2012-03-15
I am using MS Access 2010. I converted a database from 2003 to 2010. There is a print preview report that appears and a button added to the Add-Ins tab of the ribbon for the SendObject macro to email the report but it doesn't work. It was set to mail a snapshot so I changed it to .pdf instead. When I click the button the window appears stating one page of the report has been created but it hangs up here. It never opens Outlook 2010 to attach the report.
Thinking that everything I needed may not have been installed I tried to save and publish this same report as a .pdf and that worked fine so I'm thinking I have everything I need to do this. I found a lot of information, some for add-ins in 2007 that are needed and other information stating that .pdf is built in and nothing is needed. Can someone please shed some light on why this won't work?
Also, I know you can do this with VBA but I am not a programmer so I prefer to go the route of the macro first. Thanks in advance for your help.