Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
DianeDrexel DianeDrexel is offline
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default 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

Posting Rules

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

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
30 Label sheet setup? HoganD87 Microsoft Word Help 1 August 30th 07 05:08 PM
How do I set up rows and columns on used label sheet? tech-ill Mailmerge 2 April 14th 07 07:48 AM
how do I make columns of info in just a part of a sheet? column question Page Layout 1 August 13th 05 03:44 AM
How can I get all the labels on a 16 label sheet to fit exactly? AnnB Microsoft Word Help 3 June 26th 05 06:00 AM
Error in label sheet Hans Mailmerge 0 May 8th 05 10:17 PM


All times are GMT +1. The time now is 04:46 PM.

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

About Us

"It's about Microsoft Word"