Advanced mail merges from Excel

  • Thread starter Thread starter Karen
  • Start date Start date
K

Karen

I have a large database in excel on which I record
candidate information for our graduate training scheme. I
would like to be able to include both their term-time and
vacation addresses, and to put in the dates they can be
contacted at each, and then to put some sort of filter on
so that the address that the letter pulls up is the right
one for the date I print off their letters. Does anyone
have any idea of how this may be possible?
 
Karen said:
I have a large database in excel on which I record
candidate information for our graduate training scheme. I
would like to be able to include both their term-time and
vacation addresses, and to put in the dates they can be
contacted at each, and then to put some sort of filter on
so that the address that the letter pulls up is the right
one for the date I print off their letters. Does anyone
have any idea of how this may be possible?
Click to expand...

This is the way I would approach this, in principle. I appreciate that the
address will probably occupy several cells, but I will talk of just one for
clarity.

I would have one address in column A and the other in column B, with further
columns for dates (depending on how many you need). Then I would write an IF
formula to determine if it's term time, comparing TODAY() and the various
dates as necessary. I would use this result to get the current address in
another column, say J. I would do the mail merge based on this column,
rather than A or B.
 
Back
Top