Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Want different data in label sheet columns
Mailmerge w/labels question: I have labels that are two columns per sheet
(Avery5366). I want to have the first column to display "customer name/case number" and the second column to display "document title". I have an Excel spreadsheet set up with these three columns. The problem is that Mailmerge automatically populates each label with nextrecord, so I get two columns of the same datafields. I tried removing the nextrecord from the second coumn and replacing it with the field I want, but then I only get every other line from my spreadsheet. How do I set this up? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Want different data in label sheet columns
What you did should actually work, assuming
a. you want Record1 customer name/case number Record1 document title Record2 customer name/case number Record2 document title etc. b. you have deleted all the Next record fields in the second column, and not done propagate labels etc. again. It's probably worth using Alt-F9 to see what fields you really have in your document (e.g. maybe you thought you deleted something but it's now hidden inside another field, or some such). -- Peter Jamieson http://tips.pjmsn.me.uk "DianeDrexel" wrote in message ... Mailmerge w/labels question: I have labels that are two columns per sheet (Avery5366). I want to have the first column to display "customer name/case number" and the second column to display "document title". I have an Excel spreadsheet set up with these three columns. The problem is that Mailmerge automatically populates each label with nextrecord, so I get two columns of the same datafields. I tried removing the nextrecord from the second coumn and replacing it with the field I want, but then I only get every other line from my spreadsheet. How do I set this up? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
30 Label sheet setup? | Microsoft Word Help | |||
How do I set up rows and columns on used label sheet? | Mailmerge | |||
how do I make columns of info in just a part of a sheet? | Page Layout | |||
How can I get all the labels on a 16 label sheet to fit exactly? | Microsoft Word Help | |||
Error in label sheet | Mailmerge |