Combine mail VBA, and make it insert a timestamp.

**horsefish01** · 08-19-2015, 04:29 PM

I have this VBA for a "send mail button"

-Is there a way to make this leave a timestamp in "A10" that says "Shipped TIME+DATE" ?

Please Login or Register  to view this content.

**AlphaFrog** · 08-19-2015, 04:44 PM

Add this line. Change the Time and Date format to suit.

Please Login or Register  to view this content.

**horsefish01** · 08-20-2015, 09:15 AM

Originally Posted by AlphaFrog

Add this line. Change the Time and Date format to suit.

Please Login or Register  to view this content.

Awesome, thanks a million!!!

If it's not to big of a hassle, and sorry for not asking before - is it possible for it to change the cell-color to light-green?

**AlphaFrog** · 08-20-2015, 09:21 AM

Range("A10").Interior.ColorIndex = 35

TIP: you can start recording a macro and do the steps (e.g. change the cell color) to get the example code.

Re: Combine mail VBA, and make it insert a timestamp.