VBA code to look at a column and see if nil or not, if nil, to add the current date.

Hi all,

I have a problem I'm sure is probably pretty simple but I'm having some issues wrapping my head around it.

I have a script that essentially sends an email based on what is in 2 different column's cells if the current date is equal to the 'date received' column.

However, I'd like to change this to a 'Date Sent' column and want the macro to look at the cell, if it's empty - add the date and send. If the cell is not empty, I want it to ignore it.

The current script I have is shown below. Any help on this would be greatly appreciated!

Kind regards,
MW

Please Login or Register  to view this content.

Hi Nathan,

I've been trying to change that line into what it should be but kept getting run time errors stating there must be at least one name or contact group in the To, Cc, or Bcc

The columns are arranged as follows:

Column A - Date Recieved
Column B - Subject
Column C - Event
Column D - Actionee
Column E - Date Email Sent
Column F - reminder column
Column G - Email Address

My biggest concern is that it'll look at ALL the empty cells in the column and add today's date which then defeats the purpose the next day when new entries come in..


Kind regards,
MW

Aw, excellent. Cheers Nathan, I've tested this and it works perfectly. I've also in the mean time tried a

Please Login or Register  to view this content.

Which seems to have worked as well (for anyone looking for something like this)

Appreciate your time Nathan, thanks!

Kind regards,
Martin W

Ah I see what you mean, thanks for the tip! If I use UsedRange, will it still be backwards compatible with older versions? Some people seem to be using ancient Excel versions =/