Sending Automatic emails from Excel

Hi All,

I have tried to create a workbook where an automatic email will be sent to a specified email adress from Outlook, 4 weeks before a contractor is due to finish.

However, I keep finding issues. Please could soemone help? I am very new to all this and am totally stuck.

If you need anymore info please let me know.

Just a note to everyone - this tries and sends an e-mail when you open it!

Alice - What are the issues?

Hi yudlugar ,

Thanks so much for getting back to me.

As I said I am very new to this and am maybe just not inputting the correct information. How did you check that it worked?

Alice.

You have a workbook_open event that calls the macro for sending an e-mail. So when I opened the workbook it tried to send an e-mail to the address on the worksheet.

I'm still not sure what the problem is - it seems to be ok?

Please Login or Register  to view this content.

Try that

Thanks again, so grateful for your help!

That is looking much better, Is it possible for the Expiry date to be shown in the email also.

I will be changing the text to say something like 'This contract expires on...'

Also for the email to be prompted from 20 days before the contract is due to end?

So grateful for the help!

No problem, this line:

Please Login or Register  to view this content.

Is what is going in your e-mail so you want to change it to:

Please Login or Register  to view this content.

This bit:

Please Login or Register  to view this content.

Is the instruction for how many days before expiry to send the email, so change 28 to whatever number of days you need.

This is amazing, Thanks so much!

Now, just one more thing. Is it possible to add URGENT to the email, either in the body or the subject if the contract is due to expire in the next 10 days?

Thanks!!