Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-18-2013, 03:42 AM
dazwm dazwm is offline Help With Printing Mail Merge Windows XP Help With Printing Mail Merge Office 2007
Advanced Beginner
Help With Printing Mail Merge
 
Join Date: May 2012
Posts: 59
dazwm is on a distinguished road
Default Help With Printing Mail Merge


I use an excel database to print labels through mail merge. I have a template that has a little image for each label and inserts the data from the excel file. The problem I have is that when I go to print it prints several dozen sheets instead of the amount I need. I think that this is because there are formulas within the excel cells, so even if there is no visible data it is printing all the labels with just the image. What can I do about this please?
Reply With Quote
  #2  
Old 04-18-2013, 08:25 AM
dazwm dazwm is offline Help With Printing Mail Merge Windows XP Help With Printing Mail Merge Office 2007
Advanced Beginner
Help With Printing Mail Merge
 
Join Date: May 2012
Posts: 59
dazwm is on a distinguished road
Default

Any ideas please?
Reply With Quote
  #3  
Old 04-19-2013, 03:17 AM
macropod's Avatar
macropod macropod is offline Help With Printing Mail Merge Windows 7 64bit Help With Printing Mail Merge 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

In Excel, press Ctrl-End to go to the last active cell. If that is beyond your last data row, delete entirely all rows below your last data row.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #4  
Old 04-19-2013, 03:24 AM
dazwm dazwm is offline Help With Printing Mail Merge Windows XP Help With Printing Mail Merge Office 2007
Advanced Beginner
Help With Printing Mail Merge
 
Join Date: May 2012
Posts: 59
dazwm is on a distinguished road
Default

Thanks for your reply. Is that the only way around it because I really need to keep the formulas within the cells.
Reply With Quote
  #5  
Old 04-19-2013, 03:39 AM
macropod's Avatar
macropod macropod is offline Help With Printing Mail Merge Windows 7 64bit Help With Printing Mail Merge 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

In that case, when you tell Word to Finish the merge, tell it what record # to end at (this will be 1 less than the last used row's #). Alternatively, you could use a SKIPIF field to tell Word to ignore any rows for which a given field is empty. Do note that the second solution could result in the merges taking much longer than the first one, as each record still has to be evaluated.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #6  
Old 04-19-2013, 04:33 AM
dazwm dazwm is offline Help With Printing Mail Merge Windows XP Help With Printing Mail Merge Office 2007
Advanced Beginner
Help With Printing Mail Merge
 
Join Date: May 2012
Posts: 59
dazwm is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
In that case, when you tell Word to Finish the merge, tell it what record # to end at (this will be 1 less than the last used row's #). Alternatively, you could use a SKIPIF field to tell Word to ignore any rows for which a given field is empty. Do note that the second solution could result in the merges taking much longer than the first one, as each record still has to be evaluated.
How do I do either of these please? (Word 2007, Excel 2010).
Reply With Quote
  #7  
Old 04-19-2013, 05:15 PM
macropod's Avatar
macropod macropod is offline Help With Printing Mail Merge Windows 7 64bit Help With Printing Mail Merge 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

The first one is available from the 'Merge to New Document' popup that appaears when you click 'Finish and Merge>Edit Individual Documents'.

The second one can be created via the Rules dropdown on the Ribbon's Mailings tab. Having inserted that field, you insert the relevant mergefield name and the 'skip' condition (eg:{SKIPIF«myField» = ""}). Without knowing more about your data fields and what they actually contain when you don't want them to be output, I can't be more specific than that.

Note: The field brace pairs (ie '{ }') for the above example are created in the body of the document via the Rules dropodown or via Ctrl-F9 - you can't simply type them or copy & paste them from this message. Likewise, you can't type or copy & paste the chevrons (ie '« »') - they're part of the actual mergefields, which you can insert via 'Insert Merge Field'.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Duplication of address on merge RICKY Mail Merge 1 09-26-2012 03:14 PM
Help With Printing Mail Merge Conditional merge fields in mail merge Aude Mail Merge 1 01-06-2012 07:38 PM
Help With Printing Mail Merge Saving INDV mail merges During the mail merge sedain121 Mail Merge 2 10-04-2011 07:52 PM
Help With Printing Mail Merge Mail Merge Skipping 2 Labels when Printing mbsfirst Mail Merge 3 12-27-2010 04:28 PM
Printing problem with mail merge irenej48 Mail Merge 0 01-01-2010 03:03 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:08 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