Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.newusers
ben ben is offline
external usenet poster
 
Posts: 23
Default mail merge label question

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
  #2   Report Post  
Posted to microsoft.public.word.newusers
ben ben is offline
external usenet poster
 
Posts: 23
Default mail merge label question

On 2/21/2010 12:40 AM, Ben wrote:
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
  #3   Report Post  
Posted to microsoft.public.word.newusers
ben ben is offline
external usenet poster
 
Posts: 23
Default mail merge label question

On 2/21/2010 12:55 AM, Ben wrote:
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.
  #4   Report Post  
Posted to microsoft.public.word.newusers
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default mail merge label question

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

--

Graham Mayor - Word MVP

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



"Ben" wrote in message
...
On 2/21/2010 12:55 AM, Ben wrote:
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.



  #5   Report Post  
Posted to microsoft.public.word.newusers
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default mail merge label question

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" wrote in message
...
On 2/21/2010 12:55 AM, Ben wrote:
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.




  #6   Report Post  
Posted to microsoft.public.word.newusers
ben ben is offline
external usenet poster
 
Posts: 23
Default mail merge label question

On 2/21/2010 8:39 AM, Suzanne S. Barnhill wrote:
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
  #7   Report Post  
Posted to microsoft.public.word.newusers
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default mail merge label question

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" wrote in message
...
On 2/21/2010 8:39 AM, Suzanne S. Barnhill wrote:
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


  #8   Report Post  
Posted to microsoft.public.word.newusers
ben ben is offline
external usenet poster
 
Posts: 23
Default mail merge label question

On 2/21/2010 2:38 PM, Doug Robbins - Word MVP wrote:
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.


  #9   Report Post  
Posted to microsoft.public.word.newusers
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default mail merge label question

Have you added fields to the labels?

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

"Ben" wrote in message
...
On 2/21/2010 2:38 PM, Doug Robbins - Word MVP wrote:
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.



  #10   Report Post  
Posted to microsoft.public.word.newusers
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default mail merge label question

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.

"Ben" wrote in message
...
On 2/21/2010 2:38 PM, Doug Robbins - Word MVP wrote:
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.





  #11   Report Post  
Posted to microsoft.public.word.newusers
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default mail merge label question

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.

"Suzanne S. Barnhill" wrote in message
...
Have you added fields to the labels?

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

"Ben" wrote in message
...
On 2/21/2010 2:38 PM, Doug Robbins - Word MVP wrote:
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.




Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail merge label only puts one label per page? Ebb Berry Mailmerge 4 April 21st 23 12:06 PM
label mail merge maeve Mailmerge 1 November 28th 07 02:46 AM
How do you save a mail merge label document as JUST a label doc? GailD Mailmerge 3 March 29th 06 06:52 PM
Mail Merge automatically resetting my mail label option selection Tony Mailmerge 2 January 2nd 06 12:12 AM
Label Merge question moncho Microsoft Word Help 1 September 2nd 05 03:30 PM


All times are GMT +1. The time now is 12:32 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"