Adding file name to a mail merge using PDF 4uWendy 10/8/2008 5:54:08 PM I have captured the macro for automatically PDF-ing the mail merge. It names the file automatically. I would like to add an additional name into the file name. ie: let's say the file name is "10222.pdf" and I would like to add Allergen.10222.pdf. How would I add the word 'Allergen'? I would like for it to automatically put the word "Allergen" as its PDF-ing. I don't want to rename each file after the PDF mail merge. I hope I make sense. Thank you Wendy Dye

Re: Adding file name to a mail merge using PDF "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 10/8/2008 7:54:35 PM Are you using the "Add-in to Merge Letters to Separate Files" that I have written that can be downloaded from fellow MVP Graham Mayor's website at: http://www.gmayor.com/individual_merge_letters.htm If so, the simplest thing to do would be to add Allergen to the field that contains the filenames in the datasource. Alternatively, you could modify the code so that the worl Allergen is hard coded into it, or so that it requests you to provide a word to be inserted into the filename. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "4uWendy" <4uWendy [ at ]discussions.microsoft.com> wrote in message news:564912FE-E9B8-401F-9963-38A4CCA47EFF[ at ]microsoft.com... [Quoted Text] >I have captured the macro for automatically PDF-ing the mail merge. It >names > the file automatically. I would like to add an additional name into the > file > name. ie: let's say the file name is "10222.pdf" and I would like to add > Allergen.10222.pdf. How would I add the word 'Allergen'? I would like > for > it to automatically put the word "Allergen" as its PDF-ing. I don't want > to > rename each file after the PDF mail merge. I hope I make sense. Thank > you > > Wendy Dye