Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-02-2011, 02:47 PM
Reg1987 Reg1987 is offline Mail Merges Shifts Labels One Label per Page Windows Vista Mail Merges Shifts Labels One Label per Page Office 2007
Novice
Mail Merges Shifts Labels One Label per Page
 
Join Date: Jul 2009
Posts: 4
Reg1987 is on a distinguished road
Default Mail Merges Shifts Labels One Label per Page

Mail merge shifts my labels only one label to the right on each page, instead of 30 labels.

Thus, instead of have 3 pages of labels, I get 89 pages which are mostly duplicates except for one label per page.



Using MS Office 2010.

What am I doing wrong?
Reply With Quote
  #2  
Old 12-02-2011, 06:07 PM
Reg1987 Reg1987 is offline Mail Merges Shifts Labels One Label per Page Windows Vista Mail Merges Shifts Labels One Label per Page Office 2007
Novice
Mail Merges Shifts Labels One Label per Page
 
Join Date: Jul 2009
Posts: 4
Reg1987 is on a distinguished road
Default Correction

Correction...The labels shift one position to the left.
Reply With Quote
  #3  
Old 12-03-2011, 03:14 AM
macropod's Avatar
macropod macropod is offline Mail Merges Shifts Labels One Label per Page Windows 7 64bit Mail Merges Shifts Labels One Label per Page Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi Reg,

Your description suggests either:
• you're only doing Previews, not completing the merge; or
• most of the labels are missing the «Nextrecord» fields for most of the labels - there should be one at the start of each label except the first. You may be able to get that by clicking 'update labels' (make sure you don't end up with two «Nextrecord» fields in the label that presently has one). Alternatively, you could copy the one «Nextrecord» field you already have and paste it to the start of each label except the first.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #4  
Old 12-03-2011, 08:24 AM
Reg1987 Reg1987 is offline Mail Merges Shifts Labels One Label per Page Windows Vista Mail Merges Shifts Labels One Label per Page Office 2007
Novice
Mail Merges Shifts Labels One Label per Page
 
Join Date: Jul 2009
Posts: 4
Reg1987 is on a distinguished road
Default

When I "Preview results", there are 89 pages full of my records. Each page has the records shifted by one.

However, when I go ahead and print, I just get 89 records on 3 pages like I would expect. So, in the final analysis, it is working OK, just has a crazy interim step.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merges Shifts Labels One Label per Page Saving INDV mail merges During the mail merge sedain121 Mail Merge 2 10-04-2011 07:52 PM
i want to place labels on to the left of the page anchored to words within soooty Word 0 07-07-2010 09:18 AM
Labels will only print in center of page jferr Word 0 04-02-2010 09:52 AM
Mail Merge - Labels borislibman Mail Merge 0 12-13-2009 07:24 PM
Labels Mail Merge borislibman Outlook 0 12-13-2009 07:23 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:39 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft