Follow Up Email

[Drunkenneo]

I am having a table from where email is send to customers, and update the table as response send as true if customer replies back,

I need to set up a followup email when ever customer didn't replied in 5 days, on replying upon previous email, could this is possible in VBA?

 

[sxschech]

As an idea, if your table has a date field for the date_sent and date_customer_replied, then you can write a query to compare the date_sent against that date_replied field and if the replied field is null and the number of days between date_sent and today is >= 5, then you have the list of people and from that you can send out the emails based on that list.

 

[Drunkenneo]

Yes, it seems to be ok with query, but i don't want to be it in new email i want to add the contect on previously sent email, could that be possible

 

[sxschech]

Are you saying you want to resend the original email. Couldn't you recreate the original email and send out the same way as before to the list of people derived from the query or am I missing something in your process?