Home |
Search |
Today's Posts |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mail merge for each individual excel doc in a folder
It sounds like you are actually creating only one document from each Excel
spreadsheet, which is not really the purpose of mailmerge, though it can be used for that purpose. Regardless, to create each of the documents that you want to create from each of the Excel spreadsheets, you are going to need to use a macro (VBA) for the purpose. You will find some information on batch processing all of the files in a folder in the article "Find & ReplaceAll on a batch of documents in the same folder" at: http://www.word.mvps.org/FAQs/MacrosVBA/BatchFR.htm which while it deals with processing Word documents, the principle is the same (use of the Dir function) Of course, each of the spreadsheets are going to need to be identical in layout to be able to successfully process them and more information would be needed on the way in which the data that you want to use is contained the spreadsheets to give you any more specific assistance. To answer your question about the naming of the resulting Word files, yes that is certainly possible. -- 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, originally posted via msnews.microsoft.com "salventuro" wrote in message ... Hi everyone, Hope everyone is having a good day. This is my first post here, I'm a noob, so be gentle. LOL I am running Office 2003 Pro on XP Pro SP2. I have been searching the web for a solution to a project I'm working on, to no avail. I don't know if it's even possible. I have inserted the image of a form in a Word doc, I have mapped the fields to be merged from the data in excel spreadsheets I can perform the mail merge manually. The issue is, I have over one thousand excel doc's to perform the merge on. Can a macro be used to loop through a folder, merge and propogate to a new Wrd doc for each excel doc? This will create over one thousand word doc's, which will then be emailed to the corresponding employees. Also, can the name of the new Word doc created, be saved as the corresponding name as the Excel doc? Example, if the Excel doc is named 123abc.xls. can the new propogated Word doc be saved as 123ab.doc? Any assistance or links anyone knows of, would be greatly appreciated. Thanks and have a great day! -- salventuro |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
make file folder labels from Excel to Word using Mail Merge | Mailmerge | |||
Attach individual Excel spreadsheets to mail merge document | Mailmerge | |||
How do I merge individual folders into one main folder? | Microsoft Word Help | |||
Merge Excel Data to Word documents then email individual letters | Mailmerge | |||
import individual record frm excel in individual word pages | Mailmerge |