mail merge label question

[Ben]

Hello,

I created a page by going into Mailing / Labels / Options and creating a
new label for landscape letter size paper and having 4 equally divided
regions for making postcards. I then clicked on the new document button
and formatted each postcard the way I wanted it, starting off with the
word "Dear" and followed by the rest of what I wanted to appear.

How can I add a mail merge field after the word "Dear" so that I get a
different name filled in for each of the 4 postcards on the page (each
of the 4 have different clip arts inserted. I would actually have a list
of about 20 names for this so it would work out to 5 sheets worth.

I have a similar question with regards to the reverse of the postcard.
I created a second document repeating what I described in my first
paragraph to have my name and address in one corner. I would also like
to mail merge in to the center the recipients address details - how
would that be done?

Thanks,
Ben

 

[Ben]

Hello,

I created a page by going into Mailing / Labels / Options and creating a
new label for landscape letter size paper and having 4 equally divided
regions for making postcards. I then clicked on the new document button
and formatted each postcard the way I wanted it, starting off with the
word "Dear" and followed by the rest of what I wanted to appear.

Just a quick update - I did insert a title and last name field after the
word "Dear", but the mail merge (containing a list of 20 people)
inserted the same name on each page - i.e. each page which has 4
postcards ended up with all 4 postcards going to the 1 person so I ended
up with 20 pages of postcards with 4 postcards per person rather than 5
pages of postcards with 1 per person. How would I fix this?

Thanks again,
ben

 

[Ben]

On 2/21/2010 12:40 AM, Ben wrote:
Just a quick update - I did insert a title and last name field after the
word "Dear", but the mail merge (containing a list of 20 people)
inserted the same name on each page - i.e. each page which has 4
postcards ended up with all 4 postcards going to the 1 person so I ended
up with 20 pages of postcards with 4 postcards per person rather than 5
pages of postcards with 1 per person. How would I fix this?

Well, sorry for bothering everyone - at 1am I was getting impatient for
results, but a few minutes of tinkering about and I worked it out. The
mailings tab has both an "Insert Merge Field" menu for entering fields
and a "Rules" menu for inserting a "Next Record" instruction which
solved my problem (I failed to mention that I am using Word 2007 BTW).

Thank you very much.

 

[Graham Mayor]

See http://www.gmayor.com/merge_labels_with_word_2007.htm

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Suzanne S. Barnhill]

You'll doubtless find Graham's article helpful, but note that you do not
have to create the postcards manually, as Word offers built-in label
descriptions for both Avery postcard layouts and a 1/4 Letter option
(portrait and landscape) in the list under Microsoft as vendor. When you
start with these, Word inserts the «Next Record» field automatically.
Moreover, you need enter your text only once, then use Propagate Labels to
have it copied to the rest of the "labels" on the page.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

 

[Ben]

You'll doubtless find Graham's article helpful, but note that you do not
have to create the postcards manually, as Word offers built-in label
descriptions for both Avery postcard layouts and a 1/4 Letter option
(portrait and landscape) in the list under Microsoft as vendor. When you
start with these, Word inserts the «Next Record» field automatically.
Moreover, you need enter your text only once, then use Propagate Labels
to have it copied to the rest of the "labels" on the page.

Thanks for this - though I could not find the "propagate labels" option
- could you show me where it is?

Thanks,
Ben

 

[Doug Robbins - Word MVP]

In Word 2007, go to the Mailings tab and then in the Write & Insert Fields
section of the ribbon, the Update Labels button invokes the Propogate Labels
command.


--
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, originally posted via msnews.microsoft.com

 

[Ben]

In Word 2007, go to the Mailings tab and then in the Write & Insert
Fields section of the ribbon, the Update Labels button invokes the
Propogate Labels command.

I get as far as the "WRite & Insert fields" section of the ribbon, but
the "Update Labels" button is grayed out.

 

[Suzanne S. Barnhill]

Have you added fields to the labels?

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

 

[Doug Robbins - Word MVP]

That will be the case if the Mail Merge main document is NOT a label type
main document. Go back to the first step and change the main document type
(back to) a label type document.

--
Hope this helps,

Doug Robbins - Word MVP

Please reply only to the newsgroups unless you wish to obtain my services on
a paid professional basis.

 

[Doug Robbins - Word MVP]

That is not necessary. However, the main document must be a label type main
document.

--
Hope this helps,

Doug Robbins - Word MVP

Please reply only to the newsgroups unless you wish to obtain my services on
a paid professional basis.