mail merge label question
in [Beginners]
|
Prev: marvendas@gmail.com Kit completo de Solenoides ( solenoid ) + chicotePara Cambio automatico 01M hidramatico Audi A3 Vw Golf gti turbo 18276
Next: How do I make my buttons larger on the ribbon?
From: Ben on 21 Feb 2010 00:40 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
From: Ben on 21 Feb 2010 00:55 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
From: Ben on 21 Feb 2010 01:05 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.
From: Graham Mayor on 21 Feb 2010 02:46 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" <abc(a)efg.com> wrote in message news:efpKnvrsKHA.5976(a)TK2MSFTNGP05.phx.gbl... > 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.
From: Suzanne S. Barnhill on 21 Feb 2010 08:39
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" <abc(a)efg.com> wrote in message news:efpKnvrsKHA.5976(a)TK2MSFTNGP05.phx.gbl... > 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. > |