Generating email's or reminders in outlook from date in Excel

  • Thread starter Thread starter Drew
  • Start date Start date
D

Drew

I have a database of sales leads that are organized by date. I am trying to
figure out how to have either an email sent to myself or an
appointment/calendar entry if possible added to my outlook calendar one month
prior to the date I have listed in my spreadsheet. I don't want the
worksheet sent but rather to have a specific cell that I have all account
info in sent to me or posted as a reminder on my calendar. Any help would
be much appreciated.

Thanks,

Drew
 
Drew,

There are several ways you can do this. You could do a filtered mail
merge (in MS Word) and only send out emails to specific rows on your
ss.

See here for example: http://www.uwec.edu/help/Word03/MM-query.htm

Or you could simply filter the ss by hand and do a mail merge on those
records only.

Or you could write some code that goes through the ss and adds task
reminders for each one one month prior to the date you have listed in
the row.

If you need help writing the code, can you post a few rows of the
data?

HTH,
JP
 
Back
Top