I am using a spreadsheet to feed a mail merge in word, and I've run into a problem:
on sheet1 Column A through O contains data that I paste in from another workbook, Column P contains the following formula;
and is working fine. However, since I don't know how many rows I will be pasting in on a given day, I autofilled down to row 100. When I do the mail merge, Word 2007 assumes any row containing a value needs to be merged (a fair assumption in most cases), so it will always want to print 100 letters regardless of how many are filled with real data vs just containing the formula.
Is there a way to have my cake and eat it too? I can get around it by specifying to only print x number of records, but I can't help but think there is a better way.
Any Ideas?
Thanks in advance.
on sheet1 Column A through O contains data that I paste in from another workbook, Column P contains the following formula;
Code:
=IF(NOT(ISBLANK(A2)),VLOOKUP(TRIM(A2),Sheet2!A:D,4,0),"")and is working fine. However, since I don't know how many rows I will be pasting in on a given day, I autofilled down to row 100. When I do the mail merge, Word 2007 assumes any row containing a value needs to be merged (a fair assumption in most cases), so it will always want to print 100 letters regardless of how many are filled with real data vs just containing the formula.
Is there a way to have my cake and eat it too? I can get around it by specifying to only print x number of records, but I can't help but think there is a better way.
Any Ideas?
Thanks in advance.
