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


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
 
Ad

Advertisements

J

JP

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top