AUTOSAVE INDIVIDUAL LETTERS TO SPECIFIED LOCATION

[stevembe]

Firstly, thank you for taking the time to read. I have some code that has created folders from Excel in File Explorer for all of our employees. However I regularly send employees letters created in word that need to be saved in these folders as pdf files. The pdf conversion is easy enough obviously but my issue is I have to save each and every file one by one. I have some further code that saves the word merge document to one specified folder with a specified filename that ends up looking something like this:

S-TR-YU-KON 00002345 SMITH

The one common thing between the folders I have created is the number in the middle as the folders are named as such:

SMITH 00002345

Can anybody suggest a method of once the pdf files are in one folder saving them individually in bulk where the numbers of the filename and folder match?

[gmayor]

If you take a step back for a moment, as this appears to relate to a mail merge, you could use http://www.gmayor.com/individual_merge_letters.htm to create the individual PDF files from the Excel workbook used as a data source, provided you enter the path and filename (derived from the data) in a column of the worksheet. I suppose that much depends on how you are 'sending' the files to your employees.

[stevembe]

Cracking tool, thanks for pointing me in it's direction.