Sending an email on a particular date

Hi All,

I hope you're well.

I was hoping someone wouldn't mind offering a little advice on how to automatically send an email, or create a macro, to send out a reminder email to a client on a specific date.

For example :

In collumn "A" I have the clients email addresses.
In collumn "B" I have the body of the message I'd like to send to that particular client once the threshold has been met.
In collumn "C" I have the date that the email should be sent.

Ideally once the date has been met - for example in cell A3 - the macro should compose an email using the information from B3.

I'm struggling to get my head round this.

I found some code online that seems to be basically the same, but i cant get it to work in my particular context.

Any advice would be wonderful

I hope you all have a great day.

Also the code i have is below.

Please Login or Register  to view this content.

Hi - Welcome to the Forum

Can you work with this?

Please Login or Register  to view this content.

Hi Paul,

Thanks for your quick response.

That does seem to work, however it's not generating more than one email.

It seems to only grab details from the bottom row.

Any ideas?

Thanks again.

Originally Posted by manfeelings

It seems to only grab details from the bottom row.

Any ideas?

So there is only a date in the bottom row of Column C?

If Column A is populated all the way try this;

Please Login or Register  to view this content.

The code is looking in Col C for dates that match todays date and sending an email if it finds one.

If it still doesn't work if you could upload a copy of your Workbook that'd be handy so I could see what was going on properly.

It just needs to be a sample of the workbook and doesn't have to be real data - Just an example or indication of the real book.

To upload it "Go Advanced" and use "Manage Attachments" underneath the main reply box, the paper clip button doesn't work.

Hi Paul,

I'll upload the workbook here, it should hopefully be easier to understand.

I know I'm not doing a good job of explaining it.

Best,

No, it is fine - The mistake was mine, I couldn't see it till I put the code in the VBE - I've definitely not had enough coffee today.

Here, try this;

Please Login or Register  to view this content.

Hi Paul,

Nope still not working. It's only generating the first email in the row (Which is the correct date) but it wont generate any subsiquent emails.

Best,

Then... I don't know what to tell you

That code works given the Workbook you provided... I got emails for 1, 6, 7, 13, 18, 19 and 24

I've literally just Downloaded your book again, copied and pasted from the my post in to the Module and tried it :-/

I've attached it back to you - *just in case*

Let me know?

Mate, dunno what I've been doing but that works a treat!

You're a gem and a saviour!

Have a good one ma man!

No problem at all - Glad I could help

For the record it works for me. Can't see what i would change. To produce 1 email the references to outlook should be working, so that is unlikely to be the problem