Graham Mayor -- individual merge letters

I'm so excited!!!!! I got the mail merge into individual documents to work
AND it retained my different first page and second page header and footer.
The only problem I have now is that it also created two extra blank pages (by
a section break (next page) and a page break) at the end of every individual
document.

I took the page break separating the first and second page out of the
original letter and the template I used, so I don't think that's the problem.
I did noticed that in the single merged document (from which I run the macro
to separate into individual documents) that there's a section break (next
page) in-between each letter and then a section break (continuous) and a
return after the very last letter. I thought that might be part of the
problem but when I delete this last break, it screws up the pagination on the
last letter.

If I could fix this one last glitch, I should be good to go. Whew, you have
no idea how long I've been struggling with this.

Insert the following line of code before ActiveDocument.SaveAs
FileName:=Docname, FileFormat:=wdFormatDocument

AcitveDocument.Sections(ActiveDocuemnt.Sections.Co unt).PageSetup.SectionStart
= wdSectionContinuous


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

"zoolaw444" wrote in message
...
I'm so excited!!!!! I got the mail merge into individual documents to work
AND it retained my different first page and second page header and footer.
The only problem I have now is that it also created two extra blank pages
(by
a section break (next page) and a page break) at the end of every
individual
document.

I took the page break separating the first and second page out of the
original letter and the template I used, so I don't think that's the
problem.
I did noticed that in the single merged document (from which I run the
macro
to separate into individual documents) that there's a section break (next
page) in-between each letter and then a section break (continuous) and a
return after the very last letter. I thought that might be part of the
problem but when I delete this last break, it screws up the pagination on
the
last letter.

If I could fix this one last glitch, I should be good to go. Whew, you
have
no idea how long I've been struggling with this.

Doug's suggestion didn't work. Any ideas?

Not really. It is almost certainly related to the template you are now using
with the macro. It really only needs to contain the margins and the styles
used in the letter document.

--

Graham Mayor - Word MVP

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


zoolaw444 wrote:
Doug's suggestion didn't work. Any ideas?

I've modified the template as many different ways as I can think of but it
doesn't make any difference. I will just manually delete the extra page break
and section break at the end of each document.

Thank you very much for your assistance.

I assume that you corrected the spelling mistakes in the command that I
suggested.

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

"zoolaw444" wrote in message
...
Doug's suggestion didn't work. Any ideas?

Yes, I corrected your typing errors. When I run the macro with the additional
code, there's no change.

It looks like what it's doing is creating a new document for each individual
letter that contains the section breaks and page breaks for two complete
letters within each individual document. When I open each document, there's
the letter itself with the large header on the first page to accommodate our
letterhead logo and a smaller header on the second page, then a section
break. In the new section after the section break, it repeats itself - again
the large header on the first page, then a page break, and a second page with
the smaller header only both these extra pages ges are blank.

"Doug Robbins - Word MVP" wrote:

I assume that you corrected the spelling mistakes in the command that I
suggested.

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

"zoolaw444" wrote in message
...
Doug's suggestion didn't work. Any ideas?

The problem is your section break in the original letter template. Section
breaks are rarely (if ever) needed in a letter template - see
http://sbarnhill.mvps.org/WordFAQs/Letterhead.htm. It might be worth
correcting the template and the original merge letter to avoid the section
breaks and then the problem shouldn't arise in the first place.

--

Graham Mayor - Word MVP

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



zoolaw444 wrote:
Yes, I corrected your typing errors. When I run the macro with the
additional code, there's no change.

It looks like what it's doing is creating a new document for each
individual letter that contains the section breaks and page breaks
for two complete letters within each individual document. When I open
each document, there's the letter itself with the large header on the
first page to accommodate our letterhead logo and a smaller header on
the second page, then a section break. In the new section after the
section break, it repeats itself - again the large header on the
first page, then a page break, and a second page with the smaller
header only both these extra pages ges are blank.

"Doug Robbins - Word MVP" wrote:

I assume that you corrected the spelling mistakes in the command
that I suggested.

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

"zoolaw444" wrote in message
...
Doug's suggestion didn't work. Any ideas?

What do you mean by "original letter template"? The template I created (mail
merge.dot) which I then used in the SplitMerge macro does not have any page
breaks or sections breaks, nor does the letter I start with. This is what I'm
doing:

Open the letter I'm using in Word
Tools - Letters and Mailings - Mail Merge
Use the current document
Select your contacts
In the "write your letter" part I added the address fields
Complete the merge
Edit individual letters (Here, Word creates the single document that
contains all of my letters, each letter separated by a section break. This is
the first time section breaks appear and they are automatically generated by
the process Word goes through in doing the mail merge. It's in this document
that I run the macro.)

Does this make sense?

Something that you should check - with your mail merge main document open,
if you go into File|Page Setup, is the document set up for double-sided
paper, mirror margins, or anything else "unusual" ? In particular is
Pages|Multiple pages on the "Margins" tab set to anything other than
"Normal" ?

Peter Jamieson
"zoolaw444" wrote in message
...
Yes, I corrected your typing errors. When I run the macro with the
additional
code, there's no change.

It looks like what it's doing is creating a new document for each
individual
letter that contains the section breaks and page breaks for two complete
letters within each individual document. When I open each document,
there's
the letter itself with the large header on the first page to accommodate
our
letterhead logo and a smaller header on the second page, then a section
break. In the new section after the section break, it repeats itself -
again
the large header on the first page, then a page break, and a second page
with
the smaller header only both these extra pages ges are blank.

"Doug Robbins - Word MVP" wrote:

I assume that you corrected the spelling mistakes in the command that I
suggested.

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

"zoolaw444" wrote in message
...
Doug's suggestion didn't work. Any ideas?