Hi

I am looking to set up a VBA to send follow up emails from excel. I have a few parameters outside of the norm for the macro to do what I would exactly like.

I would like the macro to run down Column P and send a mail each time it finds a cell containing either todays date (date macro is run) or a date in the past.
If cells in column P are blank or a date in the future no email would be sent. (Dates are normally displayed in written form e.g. 25 July 2019 - not sure if that makes a difference?

If a suitable date is found then an email would be sent to the email address in the same row which would be in column i.

Before an email is actually sent I would like the VBA to search all folders in outlook for the last email correspondence (sent or received) from that address and send it as a reply all and therefore keeping all previous content from earlier emails. (All VBA examples I can find are based on finding most recent subject line)

In terms of the email itself I would the other information to be found from the information found in the same row as the email it is being sent to-

  • Cc email address - in column J - (often there will be no cc and this column blank)
  • The subject of the email in column Q
  • The greeting - Dear name - to be found in column R
  • The body of the email to be found in column S
  • Signature in column T
  • Attachment location in column U - if none found send anyway


I can find similar code to most of my requests but putting it together or making the adjustments is beyond me.

Many thanks if anyone can help
Alan