Macro - Save Word as PDF with Unique Name and Email PDF to specified email address.

Hi All,

I have a Word Document, which I need macro to save as PDF.
I have the following code to save as PDF.

I need to tweak the code to save the PDF with a Unique File Name.

This is the format of the File name : <UserName>_<Serial>_<Date>.pdf

The issue is this, the fields that i have mentioned are actually Linked to an Excel Sheet. So how am i suppose to reference it into my code? Im not sure on how to proceed with this.

Also I need help in emailing this PDF in Outlook to 2 email address. Anyone able to share some code on this. Thank you.

Sample of my Word Document Attached.

Please Login or Register  to view this content.

Originally Posted by macropod

The naming & saving is easily handled with:

Please Login or Register  to view this content.

For the sending of the emails, I suggest you do a web search on that aspect of VBA. There are plenty of links with demo code.

PS: Unless you have some particular reason for using the ExportAsFixedFormat method, I'd suggest you consider using the SaveAs method.

Thank You sir on the code.. I have test it out..

But my output PDFfilename is showing as this : Test_Department_User.Secretary_User.LineManager.pdf instead of <UserName>_<Serial>_<Date>.pdf

Originally Posted by macropod

It is not clear from your document with table row is required row 4 is the first with links in all cells. If you want to use another row, change the '4' in .Rows(4) to whatever else you think it should be. I'd have thought that would be very obvious to anyone who bothered to read to code instead of just copying & pasting it without giving any thought to it.

My apologies for mentioning, as Im still trying my best to learn coding. If you can see for the PC s/n - which is the serial im referring to be captured in the file name. I had actually split the cells, so will this affect the way i should reference cell? Please advise

Tweaked the code around and got it working

Please Login or Register  to view this content.