Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Mail Merge labels for price
 
Posts: n/a
Default full page same labels using paste from Excel

I would like to make price labels using Mail Merge from a source in Excel. I
would like to make the full page of 80 identical labels. Can I accomplish
this from an Excel table that has only one line for this price? In other
words, the table has many items, but I only want one item repeated many times
in the finished product in Mail Merge? I am in Office 2003.
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
 
Posts: n/a
Default full page same labels using paste from Excel

A mailmerge to labels indexes (moves) to the next record in the datasource
(when you execute the merge) because of the presence of the Next field
before the first mergefield in all of the labels on the sheet except for the
first one. When a new sheet starts, it automatically advances to the next
record for the first label on the new sheet. If you want multiple labels
created from each record, remove the appropriate number of Next fields

If there are 80 labels on the sheet, then remove the Next field from all
labels on the sheet. If there are less than 80 labels on the sheet, then
you will either have to duplicate or triplicate each record in the
datasource, or execute the merge multiple times.

--
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

"Mail Merge labels for price" Mail Merge labels for
wrote in message
...
I would like to make price labels using Mail Merge from a source in Excel.
I
would like to make the full page of 80 identical labels. Can I accomplish
this from an Excel table that has only one line for this price? In other
words, the table has many items, but I only want one item repeated many
times
in the finished product in Mail Merge? I am in Office 2003.



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
How do I Print a full page of return adress labels 1crazytab Microsoft Word Help 7 March 7th 06 12:31 AM
Paste from Excel mully Tables 1 November 3rd 05 09:10 PM
page number printing on a merged report Print Page # On Merged Report Mailmerge 6 October 17th 05 05:18 AM
How do I paste an item into a full page of cassette labels at once Ken Microsoft Word Help 2 October 4th 05 03:20 PM
creating labels, not addresses, from an Excel file some_guy79 Mailmerge 1 June 11th 05 03:54 AM


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

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"