I have a code that temporarily saves a worksheet then attaches it to an email but I need it to be in pdf format.
Would anyone know how to do this?
It will not allow me to post the code as HTML is blocked
Thanks
I have a code that temporarily saves a worksheet then attaches it to an email but I need it to be in pdf format.
Would anyone know how to do this?
It will not allow me to post the code as HTML is blocked
Thanks
Saves active sheet as PDF and emails
Please Login or Register to view this content.
nigelog,
Thanks for the quick reply.
It gives me a run time error 1004 and highlights the line .ExportAsFixedFormat Type:=xlTypePDF, Filename:=PdfFile, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=False
Is there something else I need to do?
my guess is you have no folder called Temp on C: drive - change this to suit
Please Login or Register to view this content.
That's what it was thanks nigelog..
Can I change the name of the pdf on the attachment and can I get my email signature on the email?
Hi
change the filename here by changing title and PdfFile lines
and look at this from Ron de Bruin for attaching a signaturePlease Login or Register to view this content.
https://www.rondebruin.nl/win/s1/outlook/signature.htm
Edit: Forgot to add the link
Last edited by nigelog; 10-02-2019 at 06:29 AM.
Thanks nigelog
Glad to help and thanks for the feedback and rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks