Unwanted section break Mail Merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Adeel Ahmad - 23 Jun 2006 12:09 GMT

Hi,
I am using Word 2003, Mail merging from a VB program. I have predefined
template in which some data is to be merged (Letter). Each time only one
record is to be merged from a data file.
I have a footer at the end of the page.
Now my requirement is to print the footer only on first page. I have set the
option in Page Setup.
But when i am done with MailMerge and new document is saved, it inserts a
new section break at the end. This section break (continuous) takes extra
space and a blank page is added with only the footer.
Can anyone help me how to avoid this. I dont want the section break at the
end. There is only one record so no new doucments are to be created for each
record.

Thanks,
Adeel

Reply to this Message

Graham Mayor - 23 Jun 2006 13:36 GMT

Word's form letter mail merge does not insert a section break if you merge
only one record from a data file, so either your section break is in your
template or your vba routine is inserting it.

Signature

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

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

> Hi,
> I am using Word 2003, Mail merging from a VB program. I have
[quoted text clipped - 13 lines]
> Thanks,
> Adeel

Reply to this Message

Adeel Ahmad - 26 Jun 2006 14:41 GMT

Thanks for your post.
I have checked my code and template as well. And i cannot identify any
section break being inserted.
Whats happening is that my merged template does not have this problem. But
when i Save AS the output as a new document. It contained a blank page with
only the footer.
I have tried manually deleting the Section breaks by searching for ^b. But
in doing so, my footer elements do not get merged with data elements.
Still wondering on where to look for similar threads.

Adeel

> Word's form letter mail merge does not insert a section break if you merge
> only one record from a data file, so either your section break is in your
[quoted text clipped - 17 lines]
> > Thanks,
> > Adeel

Reply to this Message

Doug Robbins - Word MVP - 26 Jun 2006 18:44 GMT

Graham is not often wrong, but in this case I regret to say that he is, as a
Letter type mail merge does include a Continuous Section Break when only one
record is merged. If multiple records are merged, a Next Page Section Break
is inserted between each letter and a Continuous Section Break is inserted
after the last letter.

IF you are ONLY ever merging one record, change the mail merge main document
type to a Directory type. Then, no Section Break will be added when the
merge is performed.

Signature

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

> Thanks for your post.
> I have checked my code and template as well. And i cannot identify any
[quoted text clipped - 31 lines]
>> > Thanks,
>> > Adeel

Reply to this Message

Graham Mayor - 27 Jun 2006 09:48 GMT

Hmmmm! I'm not always right, but this time I checked before posting and have
just rechecked and still got it wrong :(. The reason why I did not spot the
section break was I that I was using print layout view and the last line of
the test letter ended at the right margin. This break can only be seen in
normal view - so apologies for that :(

However the merge letter I used had a different first page header/footer
with content in the subsequent page footer if required and merging to a new
page while including a continuous section break, did not cause a new blank
page to be thrown. So while I missed the continuous section break, I still
don't see why this was causing the blank page. There must be something extra
on the page to make it spill over.

Signature

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

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

> Graham is not often wrong, but in this case I regret to say that he
> is, as a Letter type mail merge does include a Continuous Section
[quoted text clipped - 49 lines]
>>>> Thanks,
>>>> Adeel

Reply to this Message