Hi All,
I've managed to create a macro whereby it saves individual worksheets as a separate PDF but I need some help with the next step.
Once the worksheet has been saved as a PDF, I would like Outlook to open up, create a new email with the individual attachment.
This is what I have so far:
Please Login or Register to view this content.
Any suggestions would be most grateful.
Thanks
Karima
Last edited by karima_e; 06-19-2017 at 06:33 AM.
Thank you for the edit.
You could simply store the derived filename in a variable and use that to attach to the email...
Please Login or Register to view this content.
Last edited by cytop; 06-19-2017 at 06:40 AM.
Thank you for coming back to me.
I have amended the code but for some reason now it doesn't register the Outlook part of the coding. It just simply saves each worksheet as a PDF and then finishes.
Please Login or Register to view this content.
You don't do anything with the email after generating it so it just gets dumped. You need to eitherPlease Login or Register to view this content.
Please Login or Register to view this content.
Last edited by bakerman2; 06-19-2017 at 08:27 AM.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Amazing! It is now working! Thank you for your help
You're welcome and thanks for rep+.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks