Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
send e-mail alerts by due date | Excel Discussion (Misc queries) | |||
Send a letter via e-mail merge to several people? | Excel Discussion (Misc queries) | |||
Link Worksheet and Auto send e-mail | Excel Worksheet Functions | |||
Is their any way to set Excel to send an e-mail on date | Excel Discussion (Misc queries) | |||
Send a auto mail via Notes | Excel Discussion (Misc queries) |