Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Merging to multiple files?
Is it possible to merge a document to multiple files (i.e. one per record),
so that, for example, we can save an electronic copy of individualized memos in each employee e-files with a minimum of manipulation. If the above is feasible, can each filename be automatically be generated based on specified fields (for example Lastname_Firstname_DocumentID.doc). Looking forward to any suggestions that might facilitate this process for us! Thanks all in advance... -- Lise |
#2
|
|||
|
|||
No - but you can merge to a new document then split that document into
individual files http://www.gmayor.com/individual_merge_letters.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Lise wrote: Is it possible to merge a document to multiple files (i.e. one per record), so that, for example, we can save an electronic copy of individualized memos in each employee e-files with a minimum of manipulation. If the above is feasible, can each filename be automatically be generated based on specified fields (for example Lastname_Firstname_DocumentID.doc). Looking forward to any suggestions that might facilitate this process for us! Thanks all in advance... |
#3
|
|||
|
|||
Thanks so much... this is great!!! Our whole HR department will save a lot
of time and frustration with this macro. -- Lise "Graham Mayor" wrote: No - but you can merge to a new document then split that document into individual files http://www.gmayor.com/individual_merge_letters.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Lise wrote: Is it possible to merge a document to multiple files (i.e. one per record), so that, for example, we can save an electronic copy of individualized memos in each employee e-files with a minimum of manipulation. If the above is feasible, can each filename be automatically be generated based on specified fields (for example Lastname_Firstname_DocumentID.doc). Looking forward to any suggestions that might facilitate this process for us! Thanks all in advance... |
#4
|
|||
|
|||
I don't understand why this issue hasn't been addressed YEARS ago by
Microsoft. Although the macro is well written, it is a clumsy workaround to a a problem that should be very simple. I have had a need for this feature ever since I started doing mail merges over 10 years ago. I have trouble believing that no one at MIcrosoft ever thought "Wait, maybe they don't want to print every document! Maybe they might want keep them in an electronic format!" Especially since this is one of the more common questions that has been asked. The one part of the problem that the macro doesn't address is the need to have each document name be generated by one of the fields, rather than just a sequential number. When you have hundreds of documents generated by this macro, it is a real problem to have to rename each one individually. Thanks for posting the macro though. (The above rant is pointed at Microsft, not you!) "Graham Mayor" wrote: No - but you can merge to a new document then split that document into individual files http://www.gmayor.com/individual_merge_letters.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Lise wrote: Is it possible to merge a document to multiple files (i.e. one per record), so that, for example, we can save an electronic copy of individualized memos in each employee e-files with a minimum of manipulation. If the above is feasible, can each filename be automatically be generated based on specified fields (for example Lastname_Firstname_DocumentID.doc). Looking forward to any suggestions that might facilitate this process for us! Thanks all in advance... |
#5
|
|||
|
|||
Once you have merged the document the field information no longer exists to
split by field name. One way to do it would be to insert the field(s) you want included at the start of the document then modify the macro to select the result of those fields for use as file name, then delete them from the finished document. If you do a newsgroup archive search at Google fellow MVP Doug Robbins on whose code the macro was based, posted an alternative solution a while back, but unfortunately I did not record the link. Alternatively, he haunts the mailmerge fields newsgroup. You could ask the question there. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Peter wrote: I don't understand why this issue hasn't been addressed YEARS ago by Microsoft. Although the macro is well written, it is a clumsy workaround to a a problem that should be very simple. I have had a need for this feature ever since I started doing mail merges over 10 years ago. I have trouble believing that no one at Microsoft ever thought "Wait, maybe they don't want to print every document! Maybe they might want keep them in an electronic format!" Especially since this is one of the more common questions that has been asked. The one part of the problem that the macro doesn't address is the need to have each document name be generated by one of the fields, rather than just a sequential number. When you have hundreds of documents generated by this macro, it is a real problem to have to rename each one individually. Thanks for posting the macro though. (The above rant is pointed at Microsoft, not you!) "Graham Mayor" wrote: No - but you can merge to a new document then split that document into individual files http://www.gmayor.com/individual_merge_letters.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Lise wrote: Is it possible to merge a document to multiple files (i.e. one per record), so that, for example, we can save an electronic copy of individualized memos in each employee e-files with a minimum of manipulation. If the above is feasible, can each filename be automatically be generated based on specified fields (for example Lastname_Firstname_DocumentID.doc). Looking forward to any suggestions that might facilitate this process for us! Thanks all in advance... |
#6
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Merging to multiple files?
Hi Graham
I'm very pleased to have found your macro. I'm sure it's exactly what I've been looking for. After installing it for Word 2003, I navigated up to the point where it asks me what field has my file name and where I want to deposit the documents. After that, I get Run-Time error '4608' value out of range. Any thoughts? Thanks bunches. Amanda "Graham Mayor" wrote: Once you have merged the document the field information no longer exists to split by field name. One way to do it would be to insert the field(s) you want included at the start of the document then modify the macro to select the result of those fields for use as file name, then delete them from the finished document. If you do a newsgroup archive search at Google fellow MVP Doug Robbins on whose code the macro was based, posted an alternative solution a while back, but unfortunately I did not record the link. Alternatively, he haunts the mailmerge fields newsgroup. You could ask the question there. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Peter wrote: I don't understand why this issue hasn't been addressed YEARS ago by Microsoft. Although the macro is well written, it is a clumsy workaround to a a problem that should be very simple. I have had a need for this feature ever since I started doing mail merges over 10 years ago. I have trouble believing that no one at Microsoft ever thought "Wait, maybe they don't want to print every document! Maybe they might want keep them in an electronic format!" Especially since this is one of the more common questions that has been asked. The one part of the problem that the macro doesn't address is the need to have each document name be generated by one of the fields, rather than just a sequential number. When you have hundreds of documents generated by this macro, it is a real problem to have to rename each one individually. Thanks for posting the macro though. (The above rant is pointed at Microsoft, not you!) "Graham Mayor" wrote: No - but you can merge to a new document then split that document into individual files http://www.gmayor.com/individual_merge_letters.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Lise wrote: Is it possible to merge a document to multiple files (i.e. one per record), so that, for example, we can save an electronic copy of individualized memos in each employee e-files with a minimum of manipulation. If the above is feasible, can each filename be automatically be generated based on specified fields (for example Lastname_Firstname_DocumentID.doc). Looking forward to any suggestions that might facilitate this process for us! Thanks all in advance... |
#7
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Merging to multiple files?
I have passed your comment to Doug who wrote the add-in.
-- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Amanda wrote: Hi Graham I'm very pleased to have found your macro. I'm sure it's exactly what I've been looking for. After installing it for Word 2003, I navigated up to the point where it asks me what field has my file name and where I want to deposit the documents. After that, I get Run-Time error '4608' value out of range. Any thoughts? Thanks bunches. Amanda "Graham Mayor" wrote: Once you have merged the document the field information no longer exists to split by field name. One way to do it would be to insert the field(s) you want included at the start of the document then modify the macro to select the result of those fields for use as file name, then delete them from the finished document. If you do a newsgroup archive search at Google fellow MVP Doug Robbins on whose code the macro was based, posted an alternative solution a while back, but unfortunately I did not record the link. Alternatively, he haunts the mailmerge fields newsgroup. You could ask the question there. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Peter wrote: I don't understand why this issue hasn't been addressed YEARS ago by Microsoft. Although the macro is well written, it is a clumsy workaround to a a problem that should be very simple. I have had a need for this feature ever since I started doing mail merges over 10 years ago. I have trouble believing that no one at Microsoft ever thought "Wait, maybe they don't want to print every document! Maybe they might want keep them in an electronic format!" Especially since this is one of the more common questions that has been asked. The one part of the problem that the macro doesn't address is the need to have each document name be generated by one of the fields, rather than just a sequential number. When you have hundreds of documents generated by this macro, it is a real problem to have to rename each one individually. Thanks for posting the macro though. (The above rant is pointed at Microsoft, not you!) "Graham Mayor" wrote: No - but you can merge to a new document then split that document into individual files http://www.gmayor.com/individual_merge_letters.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Lise wrote: Is it possible to merge a document to multiple files (i.e. one per record), so that, for example, we can save an electronic copy of individualized memos in each employee e-files with a minimum of manipulation. If the above is feasible, can each filename be automatically be generated based on specified fields (for example Lastname_Firstname_DocumentID.doc). Looking forward to any suggestions that might facilitate this process for us! Thanks all in advance... |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I open multiple Word 2003 files to display on dual monitors | Microsoft Word Help | |||
Working on multiple word files from a single file???? | New Users | |||
help on managing or merging similiar files on multiple floppies u. | New Users | |||
Table of Contents - Multiple Files | Microsoft Word Help | |||
How can I insert multiple files at once into a document? | Microsoft Word Help |