If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
mail merge for each individual excel doc in a folder
Doug, macropod. Thanks for your willingness to assist. Unfortunately I ran out of time on this project. I have decided to email the Excel workbook and the Word doc to the reps, they will merge the two, for the final list of forms to be completed by their clients. I created the mail merge Word doc and added this code, Sub AutoOpen() With ActiveDocument .MailMerge.Destination = wdSendtoNewDocument .MailMerge.Execute End With End Sub This was probably written by one of you two. LOL (Doug, you are quite the Word celebrity, authority, guru, maestro…). I feel privileged that you responded to my question. I created an instructional video that I will embed in a PDF doc, showing how to save the attachments, run the mail merge and save the final Word document. I will pursue my original question and I will find a solution. When I do, I will post it back in this thread. My thanks once more. Sal. -- salventuro |
#12
|
|||
|
|||
mail merge for each individual excel doc in a folder
How do I modify my mail merge file? I would like to add another field to the
mail merge file. Can anyone help me? -- MonMonRie "salventuro" wrote: 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 |
#13
|
|||
|
|||
mail merge for each individual excel doc in a folder
What version of Word, what type of Data Source?
However, one certain way of doing it is to use the existing data source with a Directory type mailmerge main document in which you insert the mergefields into the cells of a one row table that has one extra column, that is required, but have nothing else in the document. When you execute that merge to a new document, that document will contain a table with a row of data for each record in the data source. Insert a row at the top of that table and into the cells of that row insert the names of your mergefields (just the names as in your data source, not the actual mergefields) and then populate the additional empty column with the data that you require for each record. You can then save and use that file as a data source. -- 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 "MonMonRie" wrote in message ... How do I modify my mail merge file? I would like to add another field to the mail merge file. Can anyone help me? -- MonMonRie "salventuro" wrote: 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 | |
|
|