Ask a new question

Mail Merge Label printing: Problem with data duplicating

Hi,

I have successfully merged my Excel spread sheet and formatted the labelling so it prints correctly.

However It is duplicating the names several times, but not in sequence: it re-runs the same 8 or so names several times, making what should be 6 page print-out into a 47 page print out.

Where is this error coming from?

Thanks

Lizzie

Answer
Answer
Are you sure you have actually completed the merge (Finish & Merge | Edit Individual Documents) and aren't just previewing it? The preview shows each record as the first label on a sheet, so you end up with as many "pages" as  you have records.
Microsoft MVP (Word) since 1999
Fairhope, Alabama USA
http://ssbarnhill.com
http://wordfaqs.ssbarnhill.com
Screen shots captured with TechSmith's Snagit

215 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated May 13, 2024 Views 36,956 Applies to: