Hello,
Based on my very limited knowledge about VBA I must once again ask for help, but I'm a fast learner.
I have a macro that sends emails. The outlook email body needs to contain the first day of the next month.
I have this line in my macro:
strbody = strbody & "the cases listed below are scheduled to be closed out in our system on " & "<b>Format(DateSerial(Year(Now()), Month(Now()) + 1, 1), (dd-mm-yyyy))</b>" & "." & "<br>"
The current output to outlook looks like this:
the cases listed below are scheduled to be closed out in our system on Format(DateSerial(Year(Now()), Month(Now()) + 1, 1), (dd-mm-yyyy)).
Cant find how to get the date function to work.
I'm using Office 365.
Any help is greatly appreciated!
Thank you in advance!
Bookmarks