PDF Attachment working for some, not all

[BezAcess]

Helllo,

I'm having a problem with a new database when it comes to attaching pdfs. Below is a screen shot of the macro i'm using;



When I run this on my computer it works fine, the dialog box pops up asking what I want to save the object as and after selecting pdf the e-mail is created with the correct address, subject and the pdf attached.

The problem i'm having is that other users are not getting the dialog box to save the file, they are instead just getting the e-mail. The e-mail still has the correct subject and e-mail address automatically entered, there's just no file attached.

I'm not sure if the problem lies in the database or user settings so any and all suggestions are welcome.

Kind Regards,

David

[June7]

Might be issue with user network permissions on folder where pdf is saved, but then should get error message. Did you verify that the pdf is not even created? Sorry, don't really know why the pdf does not attach.

I don't use macros, only VBA, easier to debug. Review https://www.accessforums.net/showthr...light=outputto

[BezAcess]

Hi June7,

Thanks for the response, my VBA is really basic which is why i stick to macros. The PDF isn't created when other users run the database on their machines. But there is no error message either, it just goes straight to the e-mail with no option to attach the object, which in this case is a form.

I'm not looking to save the pdf to a location on the network, just e-mail the completed form back as a summary sheet.

David

[June7]

The most I could do is test your code on my machine if you want to provide project. Follow instructions at bottom of my post.