Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help with merging 1 address to many files
We use mailmerge to create contract files using one file, the contract, with
many addresses. Now we want to have many contract files but only use one address. So that the same name or address appears on many contracts. Can we use mailmerge and how do we do that or do we need to another solution and what would that be? Thank you -- FL Consultant |
#2
|
|||
|
|||
Not mailmerge, but something like the article "Find & ReplaceAll on a batch
of documents in the same folder" at: http://word.mvps.org/FAQs/MacrosVBA/BatchFR.htm should be able to do what you want. -- 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 "FL Consultant" wrote in message ... We use mailmerge to create contract files using one file, the contract, with many addresses. Now we want to have many contract files but only use one address. So that the same name or address appears on many contracts. Can we use mailmerge and how do we do that or do we need to another solution and what would that be? Thank you -- FL Consultant |
#3
|
|||
|
|||
Doug,
Thanks for the excellent suggestion. That will work for updating one thing but I should have stated that we might need to change or add more than one item suppose we need multiple fields changed. How would we do that? Thanks -- FL Consultant "Doug Robbins" wrote: Not mailmerge, but something like the article "Find & ReplaceAll on a batch of documents in the same folder" at: http://word.mvps.org/FAQs/MacrosVBA/BatchFR.htm should be able to do what you want. -- 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 "FL Consultant" wrote in message ... We use mailmerge to create contract files using one file, the contract, with many addresses. Now we want to have many contract files but only use one address. So that the same name or address appears on many contracts. Can we use mailmerge and how do we do that or do we need to another solution and what would that be? Thank you -- FL Consultant |
#4
|
|||
|
|||
Run it as many times as necessary or or modify it so that it handles
multiple replacements. -- 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 "Doug Robbins" wrote in message ... Not mailmerge, but something like the article "Find & ReplaceAll on a batch of documents in the same folder" at: http://word.mvps.org/FAQs/MacrosVBA/BatchFR.htm should be able to do what you want. -- 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 "FL Consultant" wrote in message ... We use mailmerge to create contract files using one file, the contract, with many addresses. Now we want to have many contract files but only use one address. So that the same name or address appears on many contracts. Can we use mailmerge and how do we do that or do we need to another solution and what would that be? Thank you -- FL Consultant |
#5
|
|||
|
|||
The last solution will not work. I see that maybe the initial question was
not worded in a way that best described the problem. Your solution was good for a change of one field but when we need to change a document(s) that has many fields that need data updated your solution though it will work is not efficient. Let me state the problem again. We have lets say 5 (though the number is much larger) different contracts that require the same piece of data placed on each of them. This data may consist of a name, address, date, number of stores and other information. The information will be the same for each contract. We would like to use mailmerge or some thing like mailmerge to perform this task. Some way that will allow us to automate the process and be able to run it once when we need to update a contracts. The documents (contracts) will be in a word format. Thanks -- FL Consultant "Doug Robbins" wrote: Run it as many times as necessary or or modify it so that it handles multiple replacements. -- 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 "Doug Robbins" wrote in message ... Not mailmerge, but something like the article "Find & ReplaceAll on a batch of documents in the same folder" at: http://word.mvps.org/FAQs/MacrosVBA/BatchFR.htm should be able to do what you want. -- 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 "FL Consultant" wrote in message ... We use mailmerge to create contract files using one file, the contract, with many addresses. Now we want to have many contract files but only use one address. So that the same name or address appears on many contracts. Can we use mailmerge and how do we do that or do we need to another solution and what would that be? Thank you -- FL Consultant |
#6
|
|||
|
|||
Mailmerge is really designed for inserting many instances of the same data
into a single document to create multiple instances of that document. What you want to do is in one instance of some data into many documents which is quite different. So mailmerge is not the thing to use. At least not the best thing. The code in the item to which I pointed you can however be modified to do what you want. As this would appear to be required for commerical purposes, if you do not have the knowledge to do that, then you may have to consider paying someone to do it for you. -- 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 "FL Consultant" wrote in message ... The last solution will not work. I see that maybe the initial question was not worded in a way that best described the problem. Your solution was good for a change of one field but when we need to change a document(s) that has many fields that need data updated your solution though it will work is not efficient. Let me state the problem again. We have lets say 5 (though the number is much larger) different contracts that require the same piece of data placed on each of them. This data may consist of a name, address, date, number of stores and other information. The information will be the same for each contract. We would like to use mailmerge or some thing like mailmerge to perform this task. Some way that will allow us to automate the process and be able to run it once when we need to update a contracts. The documents (contracts) will be in a word format. Thanks -- FL Consultant "Doug Robbins" wrote: Run it as many times as necessary or or modify it so that it handles multiple replacements. -- 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 "Doug Robbins" wrote in message ... Not mailmerge, but something like the article "Find & ReplaceAll on a batch of documents in the same folder" at: http://word.mvps.org/FAQs/MacrosVBA/BatchFR.htm should be able to do what you want. -- 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 "FL Consultant" wrote in message ... We use mailmerge to create contract files using one file, the contract, with many addresses. Now we want to have many contract files but only use one address. So that the same name or address appears on many contracts. Can we use mailmerge and how do we do that or do we need to another solution and what would that be? Thank you -- FL Consultant |
#7
|
|||
|
|||
You might want to try this:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=381 That code only pushes to one file, but I'm sure you could make it push to several. ******************* ~Anne Troy www.OfficeArticles.com "FL Consultant" wrote in message ... We use mailmerge to create contract files using one file, the contract, with many addresses. Now we want to have many contract files but only use one address. So that the same name or address appears on many contracts. Can we use mailmerge and how do we do that or do we need to another solution and what would that be? Thank you -- FL Consultant |
#8
|
|||
|
|||
Thank you for the suggestion. Though the documents are in tied to a
MailMerge format because they are used to also merge many contacts to one form. But I appreciate the suggestion. I have been able to locate the MailMergeField and desplay the field. There must be a method that allows you to add text to a document. If there is I could print or save as the changed document which would give me the results I am looking for and also keep my original documents to be used for another mail merge. Thanks for responding. -- FL Consultant "Anne Troy" wrote: You might want to try this: http://www.vbaexpress.com/kb/getarticle.php?kb_id=381 That code only pushes to one file, but I'm sure you could make it push to several. ******************* ~Anne Troy www.OfficeArticles.com "FL Consultant" wrote in message ... We use mailmerge to create contract files using one file, the contract, with many addresses. Now we want to have many contract files but only use one address. So that the same name or address appears on many contracts. Can we use mailmerge and how do we do that or do we need to another solution and what would that be? Thank you -- FL Consultant |
#9
|
|||
|
|||
Though I agree with Doug in broad terms, if you already have mailmerge
documents set up it's more a question of a. creating the data source you need b. connecting the merge documents to the single data record you need and performing the merge b. automating the complete set of merges - you might for example either process each document in a a particular folder or tree of folders, or maintain a separate list and process that somehow. c. paying some attention to saving your output documents, if you need to save precisely what you produced (you need to do this whatever approach you use if you are relying on machine-readable versions of documents for any sort of legal purpose) The problem with (a) is that if you already have merge main documents set up to get their data from particular data sources, unless you make copies of these documents and permanently each copy to the data source you need, each time you use the mail merge main documents you will have to ensure that they are connected to the correct data source for the purpose. Peter Jamieson "FL Consultant" wrote in message ... The last solution will not work. I see that maybe the initial question was not worded in a way that best described the problem. Your solution was good for a change of one field but when we need to change a document(s) that has many fields that need data updated your solution though it will work is not efficient. Let me state the problem again. We have lets say 5 (though the number is much larger) different contracts that require the same piece of data placed on each of them. This data may consist of a name, address, date, number of stores and other information. The information will be the same for each contract. We would like to use mailmerge or some thing like mailmerge to perform this task. Some way that will allow us to automate the process and be able to run it once when we need to update a contracts. The documents (contracts) will be in a word format. Thanks -- FL Consultant "Doug Robbins" wrote: Run it as many times as necessary or or modify it so that it handles multiple replacements. -- 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 "Doug Robbins" wrote in message ... Not mailmerge, but something like the article "Find & ReplaceAll on a batch of documents in the same folder" at: http://word.mvps.org/FAQs/MacrosVBA/BatchFR.htm should be able to do what you want. -- 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 "FL Consultant" wrote in message ... We use mailmerge to create contract files using one file, the contract, with many addresses. Now we want to have many contract files but only use one address. So that the same name or address appears on many contracts. Can we use mailmerge and how do we do that or do we need to another solution and what would that be? Thank you -- FL Consultant |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merging to multiple files? | Microsoft Word Help | |||
ADDRESS NUMBERS SHOW AS 0 WHEN MAIL MERGING FROM EXCEL | Mailmerge | |||
When merging address, unit number is blank, Word merges, leaves 1. | Mailmerge | |||
help on managing or merging similiar files on multiple floppies u. | New Users | |||
Duplicate Files | New Users |