Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / May 2008

Tip: Looking for answers? Try searching our database.

mailmerge to individual documents

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
markb - 15 Dec 2007 18:20 GMT
Hi
I have downloaded Doug Robbins MMtoDocs (latest version 25) to split up
a mailmerge doc to multiple docs. I am using Word2003.

The macro works well and I am using the feature to auto create .pdf
documents. However the .pdf docs all end up with a blank page as the
last page which is not what I want.

When the multiple Word docs are created by the macro, they retain a
'new page' section break at the end. I think this is why the PDF
equivalent files all end up with a blank page.

So can the macro be changed so when it does the splitting, it deletes
the 'new page' section breaks?

Or is there another solution?

thanks

Signature

markb

Graham Mayor - 16 Dec 2007 07:26 GMT
Unwanted pages at the end of the split pages are a function of your merge
document and not the macro. It might help with text flow if you set the
Adobe driver as the active printer driver while you format the document and
note that any differences in layout between your document template and
normal.dot which is used in the macro to create the separate documents will
be reflected in changes to the output documents.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

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

> Hi
> I have downloaded Doug Robbins MMtoDocs (latest version 25) to split
[quoted text clipped - 14 lines]
>
> thanks
markb - 16 Dec 2007 20:36 GMT
Hi Graham
Thanks for reply. The problem is not to do with the format of my mai
merge document or differences between my document template o
normal.dot.
I realise that it isn't the MMtoDocs split macro that creates unwante
page breaks at the end of split pages - the standard mail merge proces
outputs a file with section breaks inserted.
But when the MMtoDocs split macro runs and looks for section breaks i
the mail merge output file (in order to know where to split and creat
individual files) could it not delete the section break before it
saves each individual .doc file? Then when each indicidual .doc file i
printed to the Adobe driver to create equivalent .pdf it won't result i
having a blank page in each .pdf
Many thanks

Graham Mayor;307540 Wrote:
> Unwanted pages at the end of the split pages are a function of you
> merge
[quoted text clipped - 7 lines]
> will
> be reflected in changes to the output documents.

--
markb
Graham Mayor - 17 Dec 2007 06:26 GMT
The macro should remove the section breaks that are causing your problem.
The usual reason they don't is a conflict with the template that created the
document you are merging. Try again with a simple merge based on a letter
created in normal.dot and you should see what I mean.

If you want to send me a copy of your merge letter and a small sample of
your data I may be able to spot what is wrong with your document that
conflicts with the add-in.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

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

> Hi Graham
> Thanks for reply. The problem is not to do with the format of my mail
[quoted text clipped - 52 lines]
>>
>> thanks -
charles astbury - 26 May 2008 09:10 GMT
I found Graham's AddIn and gave it a try; nice work. I too experienced a
section break continuous at the end of each of the split out documents. Did
it both when using a defined template AND normal.dot. I can only think the
macro needs to delete the last section break.
I am new to this forum so am not entirely sure if this has already been
resolved.

url:http://www.ureader.com/msg/10104583.aspx
Graham Mayor - 26 May 2008 09:47 GMT
It is actually Doug's add-on. however if you get an unwanted section break
it is invariably caused by a conflict between the template the document was
created from and the template the merge was created from. To overcome this,
either base your merge documents on the normal template or use the latest
version of the add-in which contains utility to create a working template
from the merge document.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

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

charles astbury wrote:

> Message-ID: <0bd371a1623c4d239006f4f6ae788a70@newspe.com>
> X-Mailer: http://www.umailcampaign.com, ip log:65.91.2.71
[quoted text clipped - 14 lines]
>
> url:http://www.ureader.com/msg/10104583.aspx
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.