#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
Any ideas please?
|
#3
|
||||
|
||||
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] |
#4
|
|||
|
|||
Thanks for your reply. Is that the only way around it because I really need to keep the formulas within the cells.
|
#5
|
||||
|
||||
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] |
#6
|
|||
|
|||
Quote:
|
#7
|
||||
|
||||
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] |
|
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 |
Conditional merge fields in mail merge | Aude | Mail Merge | 1 | 01-06-2012 07:38 PM |
Saving INDV mail merges During the mail merge | sedain121 | Mail Merge | 2 | 10-04-2011 07:52 PM |
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 |