Send email on workbook refresh

[rikapple]

Hi

I think this is a big ask, but here goes!

I have an excel sheet which is refreshing and pulling data from a googlesheet. What I am wanting to do is when a refresh occurs any new line will trigger an email.

The data coming in will include an email address (Column J) I would also like to include some other information in the body of the email. So my hope is it would look something like this:


Email to (Value of Cell A1)

Dear Sir

Your delegate (VALUE on B1) has requested a break on (Value of O1) and hope that (value of K1) is acceptable.

Kind Regards

Rachel

I have set the workbook to refresh every 30 minutes so if another line of code is updated then I would like it to just send the above email to the new line not everyone on the list.

Please let me know if this is even possible if so how? I am not very advanced in VBA which I am sure where this is going to go so please keep any explanations simple.

Many thanks in advance

Rachel

 

[Paul Ked]

Ron de Bruin has some excellent email routines here https://www.rondebruin.nl/win/s1/outlook/mail.htm

Have a read, I'm sure it will give you a very good insight and help you set your direction.