Send Mail Merge Auto-Emails based on date
 

I have a database-like spreadsheet with a few key columns:
Company (text field)
Agent (text field)
Agent Email Address (valid email address)
Client (text field)
Sent Forms (date field)
Received Forms (date field)
Reminder Sent (text field)

I would like to create a macro that automatically sends an email to the
Agent 3 weeks after the Sent date if the Received date is not populated.
To avoid sending multiple emails, once an email is sent, the Reminder
Sent column should get populated with "yes" and not allow subsequent
emails.

The email would use a mail-merge type format so I can say "Dear
[Agent], we have not received [Client] forms from [Company]. Please
send asap."

Is something like this possible using Excel? I know Access is better
for databases but I don't know it very well.
Thanks,
Phillycheese


--
Phillycheese5
------------------------------------------------------------------------
Phillycheese5's Profile: http://www.excelforum.com/member.php...o&userid=24196
View this thread: http://www.excelforum.com/showthread...hreadid=485875

Send Mail Merge Auto-Emails based on date
 

Hi Phillycheese5

You can create worksheetfunction that diplay "yes" if you want to send.a mail
And use a macro like this
http://www.rondebruin.nl/mail/folder3/message.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Phillycheese5" wrote in message
news:Phillycheese5.1ynb4n_1132238403.292@excelforu m-nospam.com...

I have a database-like spreadsheet with a few key columns:
Company (text field)
Agent (text field)
Agent Email Address (valid email address)
Client (text field)
Sent Forms (date field)
Received Forms (date field)
Reminder Sent (text field)

I would like to create a macro that automatically sends an email to the
Agent 3 weeks after the Sent date if the Received date is not populated.
To avoid sending multiple emails, once an email is sent, the Reminder
Sent column should get populated with "yes" and not allow subsequent
emails.

The email would use a mail-merge type format so I can say "Dear
[Agent], we have not received [Client] forms from [Company]. Please
send asap."

Is something like this possible using Excel? I know Access is better
for databases but I don't know it very well.
Thanks,
Phillycheese


--
Phillycheese5
------------------------------------------------------------------------
Phillycheese5's Profile: http://www.excelforum.com/member.php...o&userid=24196
View this thread: http://www.excelforum.com/showthread...hreadid=485875