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 / September 2005

Tip: Looking for answers? Try searching our database.

Help me impress my boss!

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
johnshaft2000 - 21 Sep 2005 18:01 GMT
I hope someone can help with this query. What I have is I have a mail
merge set up which prints information of about three records to a page
and then repeats the pages until it runs out of records. What I need
though is a field of text which appears only once at the start of the
document and is not repeated when the next set of three records merges
meaning I end up with the same text at the top of each page.

I need to be able to say I want this text to only appear once at the
top of the page and then have the rest of the mail merge running as
before. Any ideas?
dj - 21 Sep 2005 19:56 GMT
If I am understanding your question correctly, ou should be able to insert
the field of text into a "First Page Header" by choosing View, Header and
Footer.  If the First Page Header doesn't come up automatically, you can
select it by choosing File, Page Setup, and then selecting the "Different
First Page" box under Headers and Footers.

If I've misunderstood you, sorry.  Give me a little more detail and I'll try
again!

JK Hunter
MinutiaMinders

> I hope someone can help with this query. What I have is I have a mail
> merge set up which prints information of about three records to a page
[quoted text clipped - 6 lines]
> top of the page and then have the rest of the mail merge running as
> before. Any ideas?
johnshaft2000 - 22 Sep 2005 09:17 GMT
Thanks for getting back to me but when I try what you suggested I get
the first front page, then I get the normal page with the three merged
records, then another first front page then another three merged
records and so on. Is there any way I can tell it not to repeat this
first page header?

To give you a bit more clarification this is how it is set up:

1) There is a header at the top of each page
2) below that is a table which has a number of merge fields about a
record
3) Then there is a gap with a <<next record>> code
4) then there is another table which is identical to the table in step
2 but for the next record
5) Then there is a gap with a <<next record>> code
6) then there is another table which is identical to the table in step
2 but for the next record

That is where the mail merge set up ends. Then it repeats itself until
all the records to merge have run out. I then tried doing the
"different first page" suggestion you gave me but it meant that after
the three tables had been mereged that the first page repeated again.
Any more ideas?
macropod - 22 Sep 2005 11:37 GMT
Hi John,

If you want to do this without using a header, you could use a formula
field, coded as:
{IF{=MOD({MERGESEQ},3)}= 1 "MyText"}
ahead of your existing set of mergefields

Cheers
PS: The field braces (i.e. '{  }') can't be typed/pasted - they are created
in pairs via Ctrl-F9.

> I hope someone can help with this query. What I have is I have a mail
> merge set up which prints information of about three records to a page
[quoted text clipped - 6 lines]
> top of the page and then have the rest of the mail merge running as
> before. Any ideas?

Rate this thread:






 
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.