Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Arbo-Gregg Arbo-Gregg is offline
external usenet poster
 
Posts: 2
Default How to tell Word how many of each label to merge?

I'm trying to merge pricing labels via word merge from data stored in an
excel worksheet. Along with the basic info such as product name, description
and price, I have a column '# of Labels'. Is there a way I can use this data
to tell the merge wizard how many of each label to merge?

For example, I'd like 20 labels for product A, 40 labels for product B, 80
labels for product C, and so on.

Thanks Much!


  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default How to tell Word how many of each label to merge?

For random numbers of labels, then the simplest approach would be to change
(or create) the data source to reflect the appropriate number of records for
each label.

--

Graham Mayor - Word MVP

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



Arbo-Gregg wrote:
I'm trying to merge pricing labels via word merge from data stored in
an excel worksheet. Along with the basic info such as product name,
description and price, I have a column '# of Labels'. Is there a way
I can use this data to tell the merge wizard how many of each label
to merge?

For example, I'd like 20 labels for product A, 40 labels for product
B, 80 labels for product C, and so on.

Thanks Much!



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Arbo-Gregg Arbo-Gregg is offline
external usenet poster
 
Posts: 2
Default How to tell Word how many of each label to merge?

A simple solution! Thanks very much.
--
Type Type Type - Gregg


"Graham Mayor" wrote:

For random numbers of labels, then the simplest approach would be to change
(or create) the data source to reflect the appropriate number of records for
each label.

--

Graham Mayor - Word MVP

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



Arbo-Gregg wrote:
I'm trying to merge pricing labels via word merge from data stored in
an excel worksheet. Along with the basic info such as product name,
description and price, I have a column '# of Labels'. Is there a way
I can use this data to tell the merge wizard how many of each label
to merge?

For example, I'd like 20 labels for product A, 40 labels for product
B, 80 labels for product C, and so on.

Thanks Much!




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 merge--lost label template LNO Mailmerge 2 May 4th 07 02:51 PM
label merge advancing only one label/pg kuleama Mailmerge 1 May 1st 07 08:52 PM
in label merge, can I start at a specific label spot? RNS Mailmerge 1 August 16th 06 04:23 AM
How do you save a mail merge label document as JUST a label doc? GailD Mailmerge 3 March 29th 06 06:52 PM


All times are GMT +1. The time now is 11:25 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"