Hi,
Please can someone tell me when the following code will not attach a pdf of my workbook to an email:
It appears to do everything correct apart from attach the file.
Please Login or Register to view this content.
Also - is it possible to have the pdf output to a temporary file location on the users computer and then clear down when the email has been sent? At the minute this is generating to the location the workbook is saved.
thanks in advance.
Looks like you are adding .pdf twice.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
hi - even with this removed it still doesn't work.
Hi Dan
You need to fully qualify the FileNameThen you can use this line of Code to do thisPlease Login or Register to view this content.is it possible to have the pdf output to a temporary file location on the users computer and then clear down when the email has been sentHere's the Complete Code (from rondebruin) that I usePlease Login or Register to view this content.Please Login or Register to view this content.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks