Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
one volunteer one volunteer is offline
external usenet poster
 
Posts: 1
Default Why does Mail Merge create mulitple copies of the same label?

I've created a custom 4"xc4" label with four on a page. When I mail merge
from an Excel list, each entry is duplicated on consecutive pages until I
have 4 of each. If I use 3"x4" labels with six on a page, it duplicates the
entries until I have each one 6 times. They aren't duplicated on the same
page, but on consecutive pages in the next label position on the page.
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Why does Mail Merge create mulitple copies of the same label?

You are not actually executing the merge. Rather all that you are doing is
viewing/printing a preview of the result as you iterate through the data
source one record at a time

You must execute the merge to a printer or a new document and then you will
get the data from four records on each page.

See the article €śMailmerge Labels with Word XP€ť on fellow MVP Graham Mayors
website at

http://www.gmayor.com/mail_merge_lab...th_word_xp.htm

or €śMail Merge with Word 2007€ť on fellow MVP Graham Mayors website at

http://www.gmayor.com/merge_labels_with_word_2007.htm


--
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, originally posted via msnews.microsoft.com

"one volunteer" one wrote in message
...
I've created a custom 4"xc4" label with four on a page. When I mail merge
from an Excel list, each entry is duplicated on consecutive pages until I
have 4 of each. If I use 3"x4" labels with six on a page, it duplicates
the
entries until I have each one 6 times. They aren't duplicated on the same
page, but on consecutive pages in the next label position on the page.


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
create a label from a mail merge letter GeorgeS Mailmerge 6 May 13th 22 08:59 AM
Mail merge to create the same label in triplicate KarenIam Mailmerge 1 March 24th 09 05:56 AM
having mulitple copies of a paragraph update autmatically Pat M - City of Reno Microsoft Word Help 3 November 8th 08 12:48 AM
trouble printing mulitple copies d2of5 Microsoft Word Help 3 February 10th 05 06:06 PM
Printing multiple copies of each label using mail merge picklet222 Mailmerge 3 February 2nd 05 03:51 PM


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