A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How do I mail merge to have different names on the main document?



 
 
Thread Tools Display Modes
  #1  
Old November 18th, 2004, 08:19 PM
Dorothy
external usenet poster
 
Posts: n/a
Default How do I mail merge to have different names on the main document?

I'm sending out invitations and I have four to a page. With mail merge it
changes the name on every page and I want to change the name on each
invitation, I'm ending up with four invitations to the same person. I have
used the letter format as I have graphics in the invitation.
  #2  
Old November 19th, 2004, 02:50 AM
Doug Robbins
external usenet poster
 
Posts: n/a
Default

You need to insert a Next Record field before the first mergefield in
the 2nd, 3rd and 4th invitations.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
"Dorothy" wrote in message
...
I'm sending out invitations and I have four to a page. With mail merge it
changes the name on every page and I want to change the name on each
invitation, I'm ending up with four invitations to the same person. I have
used the letter format as I have graphics in the invitation.



  #3  
Old November 19th, 2004, 02:03 PM
Dorothy
external usenet poster
 
Posts: n/a
Default

Thank you Doug, you are a life-saver and it works so easily!!

"Doug Robbins" wrote:

You need to insert a Next Record field before the first mergefield in
the 2nd, 3rd and 4th invitations.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
"Dorothy" wrote in message
...
I'm sending out invitations and I have four to a page. With mail merge it
changes the name on every page and I want to change the name on each
invitation, I'm ending up with four invitations to the same person. I have
used the letter format as I have graphics in the invitation.




  #4  
Old January 25th, 2005, 04:55 PM
TonyM
external usenet poster
 
Posts: n/a
Default

I am having a similar problem. I am trying to merge addresses onto a
postcard template. The template has a text box for the address separate from
the text box for the message. Every time I insert the 'next record' into the
template (in the beginning of the second, third and fourth address boxes) and
try to merge, I get the error msg "You cannot include DATA, NEXT, NEXTIF or
SKIPIF fields in headers, footers, footnotes or endnotes." I have tried
changing the document type from form letters, to catalog, to labels, to
envelopes. None of them work

"Dorothy" wrote:

Thank you Doug, you are a life-saver and it works so easily!!

"Doug Robbins" wrote:

You need to insert a Next Record field before the first mergefield in
the 2nd, 3rd and 4th invitations.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
"Dorothy" wrote in message
...
I'm sending out invitations and I have four to a page. With mail merge it
changes the name on every page and I want to change the name on each
invitation, I'm ending up with four invitations to the same person. I have
used the letter format as I have graphics in the invitation.




  #5  
Old January 25th, 2005, 11:06 PM
Doug Robbins
external usenet poster
 
Posts: n/a
Default

Don't use text boxes. Use cells of a table to organise things in the
required layout.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
"TonyM" wrote in message
...
I am having a similar problem. I am trying to merge addresses onto a
postcard template. The template has a text box for the address separate
from
the text box for the message. Every time I insert the 'next record' into
the
template (in the beginning of the second, third and fourth address boxes)
and
try to merge, I get the error msg "You cannot include DATA, NEXT, NEXTIF
or
SKIPIF fields in headers, footers, footnotes or endnotes." I have tried
changing the document type from form letters, to catalog, to labels, to
envelopes. None of them work

"Dorothy" wrote:

Thank you Doug, you are a life-saver and it works so easily!!

"Doug Robbins" wrote:

You need to insert a Next Record field before the first mergefield
in
the 2nd, 3rd and 4th invitations.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a
paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
"Dorothy" wrote in message
...
I'm sending out invitations and I have four to a page. With mail
merge it
changes the name on every page and I want to change the name on each
invitation, I'm ending up with four invitations to the same person. I
have
used the letter format as I have graphics in the invitation.





 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I mail merge when only merge document is shown in tools? DaveAS General Discussion 2 December 1st, 2004 03:45 PM
using mail merge and inserting several names on one page Vseward Mailmerge 2 May 26th, 2004 04:00 PM
Mial merge data base problems Rachael Mailmerge 16 May 21st, 2004 06:22 PM
Using a Excel macro or VB to call up a WORD mail merge document Bob Reynolds Worksheet Functions 0 January 7th, 2004 06:25 PM
Mail merge Excel database to Excel "document" Rick Setting up and Configuration 0 October 29th, 2003 06:29 PM


All times are GMT +1. The time now is 05:33 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.