adding sent date when email

[laduk]

this is my sheet and im happy with how it looks but would like the code for column f
to tell me when email has been sent

[RHCPgergo]

Hi,
paste this into your code

Please Login or Register  to view this content.

--> position after these lines:

Please Login or Register  to view this content.

Note: if the cell already contains a time, then the code will not delete it, it will ad the present time at the end of it.

[laduk]

great thanks

[laduk]

found two problems one is it will put date in more than once if already sent and why do my sheet not send mail past row 11

cheers

[RHCPgergo]

Hi,

I updated your code a little, I found why it only went to row 11. (It counted the rows on sheet "email" - I suppose by accident.) I also removed the feature to add more dates. Now it only adds the date when the last email was sent.

Please Login or Register  to view this content.

[laduk]

thanks your a star

[laduk]

everthing working great, but is possible for it to ignore row when email already sent

cheers

[RHCPgergo]

Hi,

change this line

Please Login or Register  to view this content.

to this

Please Login or Register  to view this content.

[laduk]

thanks for everything