Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.newusers
|
|||
|
|||
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
Posted to microsoft.public.word.newusers
|
|||
|
|||
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
Posted to microsoft.public.word.newusers
|
|||
|
|||
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
Posted to microsoft.public.word.newusers
|
|||
|
|||
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
Posted to microsoft.public.word.newusers
|
|||
|
|||
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
Posted to microsoft.public.word.newusers
|
|||
|
|||
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
Posted to microsoft.public.word.newusers
|
|||
|
|||
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
Posted to microsoft.public.word.newusers
|
|||
|
|||
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
Posted to microsoft.public.word.newusers
|
|||
|
|||
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
Posted to microsoft.public.word.newusers
|
|||
|
|||
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
Posted to microsoft.public.word.newusers
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail merge label only puts one label per page? | Mailmerge | |||
label mail merge | Mailmerge | |||
How do you save a mail merge label document as JUST a label doc? | Mailmerge | |||
Mail Merge automatically resetting my mail label option selection | Mailmerge | |||
Label Merge question | Microsoft Word Help |