Hello,

Your file is empty. However, check out this article linked to below and have a go at it.

https://www.myonlinetraininghub.com/vba-to-create-pdf-from-excel-worksheet-then-email-it-with-outlook

Br,
Anders

Hello Anders Sehlstedt,

Please find attachment and help in this regards. Here Branch Name is in Bulk Numbers till n number.

Thanks

Deepak Kumar

Hello Deepak,

I am sorry, I am no coder. Wasn't the article I linked to of any help?

Br,
Anders

Okay Thanks.....

Is any one help me out in this regards,

I want here to generate

 files from an 

 file. After this coding runs, the results is that I will have multiple 

 files with suffix 

 - (e.g., 

) I can change the suffix to anything.

And I will extract another set of PDF files from a zip file that have the identical file name as 

.

At the end, in one folder, there will be multiple pairs of files as below.

875458.pdf
875458-index.pdf
875460.pdf
875460-index.pdf
954784.pdf
954784-index.pdf

My goal is to find a w

ay to merge each pair of files into one file.

The end result would be as below.

(Indexl file being the first pages)

875458.pdf 
875460.pdf
954784.pdf

Thanks
Deepak Kumar