Split into separate files as PDF with a field name in mail merging

Hi Team,

I tried below the code, took from many sources and many statements in the code here. The problem with the below code is, it generating only first record as .PDF file with desired field as file name and generating many new documents as per the records and asking for to save each document.

Please help me in generating the number of .PDF files with the desired EMP_ID field as the file name as per the number of records in the merge file attached. Using Microsoft Word 2007.

Please Login or Register  to view this content.

The issue is solved. Tried many and at last achieved the required.

Thanks & Regards
Chaitanya

Cross-posted at: http://www.vbaexpress.com/forum/showthread.php?t=46493
For cross-posting etiquette, please read FORUM RULE 8: http://www.excelforum.com/forum-rule...rum-rules.html

Hi Macropod,

Thanks for the rules. Sure, will follow the same.

Chaitanya