Hi All, apologies if you've seen this query many times before. I cannot seem to find a clear answer on why the pdf attachment cannot open after the following macro opens a word file, converts it to a pdf and sends it out via outlook within a loop. The code is as follows. Your help would be much appreciated.
Thank You
Please Login or Register to view this content.
Last edited by davesexcel; 09-25-2020 at 12:10 PM.
Possibly adding a open command on the export...?If not, try recording an Export to PDF on the File menu instead of using SaveAs to show you the correct syntax..Please Login or Register to view this content.
Hi dangelor, thanks for the response. Unfortunately adding the 'OpenAfter...' line didn't work here. With the other action you mentioned, did you mean try to record a macro with me opening the word and saving it as a pdf? I've tried that and for some reason it doesn't the code of that step. I'll keep playing around. many thanks for your time.
Possibly...Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks