Hello all,
I do mailings a few times a year to subscribers whose information is contained in an Excel workbook, but the nature of the label creation is a little tricky. Let me explain.
I have 236 subscribers on the list, and in any given month, only about 30 to 40 will get a mailing (if you're curious, it's a non-profit ham radio QSL card service). What I need the mailing label to contain on the first line, above the name, is the balance left in their account following the current mailing. That balance will be found in a column in the spreadsheet. The subscribers' other label info are contained in columns N (callsign), P (full name), Q (Street Address), R (City), S (State) and T (Zip). But here's the part that I don't know what to do with.
What I need to tell Excel/Word is this: If any value whatsoever is present in column I (cost of a mailpiece) then (a) create a label for that subscriber and (b) have the first line of the label read You have XX credits remaining as of (current month/year), where the value of XX is found in column J for that subscriber.
The problem for me is that this project does not need to generate labels for all subscribers each pass. I only need to generate labels if the subscriber is getting a mailing that month, and it must be customized each time (with the balance info).
Thanks in advance. Any assistance greatly appreciated!
Bookmarks