Reply
 
Thread Tools Display Modes
  #1   Report Post  
Lise
 
Posts: n/a
Default 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   Report Post  
Graham Mayor
 
Posts: n/a
Default

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   Report Post  
Lise
 
Posts: n/a
Default

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   Report Post  
Peter
 
Posts: n/a
Default

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   Report Post  
Graham Mayor
 
Posts: n/a
Default

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   Report Post  
Posted to microsoft.public.word.docmanagement
Amanda Amanda is offline
external usenet poster
 
Posts: 46
Default 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   Report Post  
Posted to microsoft.public.word.docmanagement
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default 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...



  #8   Report Post  
Posted to microsoft.public.word.docmanagement
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Merging to multiple files?

His comment:

I think that you might get that error when the filename field includes the
path and the user browses for the path so that the concatenation of the two
pieces of information results in path for the files that does not exist.




--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Graham Mayor wrote:
I have passed your comment to Doug who wrote the add-in.


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...



  #9   Report Post  
Posted to microsoft.public.word.docmanagement
Amanda Amanda is offline
external usenet poster
 
Posts: 46
Default Merging to multiple files?

Hi Graham
Doug's idea was good, but that doesn't seem to be the problem. I didn't have
the file path in the fieldname field. But based on Doug's idea, I tried
putting the path in the fieldname path and removing the path from
browse-to-folder area, but that didn't help. I also removed the 2 landscape
pages from my 14 page document, thinking it was choking on landscape vs.
portrait. That didn't help either.

Any other thoughts?
Thanks for all of your help.
Amanda

"Graham Mayor" wrote:

His comment:

I think that you might get that error when the filename field includes the
path and the user browses for the path so that the concatenation of the two
pieces of information results in path for the files that does not exist.




--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Graham Mayor wrote:
I have passed your comment to Doug who wrote the add-in.


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...




  #10   Report Post  
Posted to microsoft.public.word.docmanagement
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Merging to multiple files?

Amanda,

Can you send me the document and a copy of the data source and I will try
and find out what is going wrong.

--
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

"Amanda" wrote in message
news
Hi Graham
Doug's idea was good, but that doesn't seem to be the problem. I didn't
have
the file path in the fieldname field. But based on Doug's idea, I tried
putting the path in the fieldname path and removing the path from
browse-to-folder area, but that didn't help. I also removed the 2
landscape
pages from my 14 page document, thinking it was choking on landscape vs.
portrait. That didn't help either.

Any other thoughts?
Thanks for all of your help.
Amanda

"Graham Mayor" wrote:

His comment:

I think that you might get that error when the filename field includes
the
path and the user browses for the path so that the concatenation of the
two
pieces of information results in path for the files that does not exist.




--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Graham Mayor wrote:
I have passed your comment to Doug who wrote the add-in.


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...








  #11   Report Post  
Posted to microsoft.public.word.docmanagement
Amanda Amanda is offline
external usenet poster
 
Posts: 46
Default Merging to multiple files?

Hi Doug
Thank you for your continued support. I got the macro to work by starting
with a brand new, unformatted document. My old document must have had some
icky relics in it that the new template didn't like.

In any event, your macro is a lifesaver. Thanks again!
Amanda


"Doug Robbins - Word MVP" wrote:

Amanda,

Can you send me the document and a copy of the data source and I will try
and find out what is going wrong.

--
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

"Amanda" wrote in message
news
Hi Graham
Doug's idea was good, but that doesn't seem to be the problem. I didn't
have
the file path in the fieldname field. But based on Doug's idea, I tried
putting the path in the fieldname path and removing the path from
browse-to-folder area, but that didn't help. I also removed the 2
landscape
pages from my 14 page document, thinking it was choking on landscape vs.
portrait. That didn't help either.

Any other thoughts?
Thanks for all of your help.
Amanda

"Graham Mayor" wrote:

His comment:

I think that you might get that error when the filename field includes
the
path and the user browses for the path so that the concatenation of the
two
pieces of information results in path for the files that does not exist.




--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Graham Mayor wrote:
I have passed your comment to Doug who wrote the add-in.


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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I open multiple Word 2003 files to display on dual monitors mally Microsoft Word Help 6 July 4th 05 11:00 AM
Working on multiple word files from a single file???? Rich New Users 5 May 30th 05 03:10 PM
help on managing or merging similiar files on multiple floppies u. rcraigpowers New Users 0 February 15th 05 08:53 PM
Table of Contents - Multiple Files megamble2 Microsoft Word Help 4 January 21st 05 08:01 PM
How can I insert multiple files at once into a document? Confused Word User Microsoft Word Help 1 December 10th 04 05:12 PM


All times are GMT +1. The time now is 04:42 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"