Reply
 
Thread Tools Display Modes
  #1   Report Post  
Matty_b
 
Posts: n/a
Default Merge to seperate documents

Hi, Is it possible in MSword to merge to seperate documents, because when i
click merge to new document it blocks them all in one document and then i
have to seperate them out manually which is very time consuming with over 100
records,
Thanks
  #2   Report Post  
Graham Mayor
 
Posts: n/a
Default

You cannot output to individual files, but you can split the merge with a
macro which achieves the same ends:
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




Matty_b wrote:
Hi, Is it possible in MSword to merge to seperate documents, because
when i click merge to new document it blocks them all in one document
and then i have to seperate them out manually which is very time
consuming with over 100 records,
Thanks



  #3   Report Post  
Matty_b
 
Posts: n/a
Default

I found your website when searching through google looking for the answer and
tryed you macro but couldnt get it to work, can you give me a walk through of
how to make this work, and also more information on what the outcome should
be?

Thanks for you help
  #4   Report Post  
Doug Robbins
 
Posts: n/a
Default

Try this one:

Sub splitter()

' splitter Macro

' Macro created by Doug Robbins to save each letter created by a mailmerge
as a separate file.

Dim i As Long, Source as Document, Target as Document, Letter as Range
Set Source = ActiveDocument
For i = 1 to Source.Sections.Count
Set Letter = Source.Sections(i).Range
Letter.End=Letter.End-1
Set Target = Documents.Add
Target.Range=Letter
Target.SaveAs FileName:="Letter" & i
Target.Close
Next i

End Sub


--
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
"Matty_b" wrote in message
...
I found your website when searching through google looking for the answer
and
tryed you macro but couldnt get it to work, can you give me a walk through
of
how to make this work, and also more information on what the outcome
should
be?

Thanks for you help



  #5   Report Post  
Graham Mayor
 
Posts: n/a
Default

I am curious to discover what problems you had - and given that the posted
code is based on one of Doug's macros, the alternative he has posted may be
similarly problematical. For installing macros from listings, see my other
page http://www.gmayor.com/installing_macro.htm

--

Graham Mayor - Word MVP

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




Matty_b wrote:
I found your website when searching through google looking for the
answer and tryed you macro but couldnt get it to work, can you give
me a walk through of how to make this work, and also more information
on what the outcome should be?

Thanks for you help





  #6   Report Post  
Matty_b
 
Posts: n/a
Default

I've got Dougs macro to work but it doesnt keep all my table formating as
all the information in the mail merge is put into different areas of the
table, the output of the macro is just a list of information unformated, I
dont know if either you or Doug can help me,

Thanks for your assistance

"Graham Mayor" wrote:

I am curious to discover what problems you had - and given that the posted
code is based on one of Doug's macros, the alternative he has posted may be
similarly problematical. For installing macros from listings, see my other
page http://www.gmayor.com/installing_macro.htm

--

Graham Mayor - Word MVP

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




Matty_b wrote:
I found your website when searching through google looking for the
answer and tryed you macro but couldnt get it to work, can you give
me a walk through of how to make this work, and also more information
on what the outcome should be?

Thanks for you help




  #7   Report Post  
Graham Mayor
 
Posts: n/a
Default

This is beginning to sound like a non-standard form letter merge document. A
form letter merge (which the macro is intended to split) separates the
individual merge 'documents' by section breaks and the macro splits the file
along those section breaks. You seem to be doing something quite different.

--

Graham Mayor - Word MVP

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




Matty_b wrote:
I've got Dougs macro to work but it doesnt keep all my table
formating as all the information in the mail merge is put into
different areas of the table, the output of the macro is just a list
of information unformated, I dont know if either you or Doug can help
me,

Thanks for your assistance

"Graham Mayor" wrote:

I am curious to discover what problems you had - and given that the
posted code is based on one of Doug's macros, the alternative he has
posted may be similarly problematical. For installing macros from
listings, see my other page
http://www.gmayor.com/installing_macro.htm

--

Graham Mayor - Word MVP

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




Matty_b wrote:
I found your website when searching through google looking for the
answer and tryed you macro but couldnt get it to work, can you give
me a walk through of how to make this work, and also more
information on what the outcome should be?

Thanks for you help



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
Why does Word try to merge documents when I open them? Steve Zinger Mailmerge 1 April 12th 05 09:12 AM
Merge to printer as individual documents. nobag Mailmerge 2 March 28th 05 12:25 PM
How do I merge 2 folders worth of documents? Perplexed Microsoft Word Help 1 March 25th 05 03:22 PM
Merge data - save as different documents Jan Mailmerge 1 March 22nd 05 09:31 PM
Merge multiple documents? George M. Lutz New Users 1 November 27th 04 01:06 PM


All times are GMT +1. The time now is 10:33 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"