Knockoutpie
Board Regular
- Joined
- Sep 10, 2018
- Messages
- 116
- Office Version
- 365
- Platform
- Windows
How do I make this to have multiple lines? Seems it doesn't like my underscores or date format, but I am using this same format as the file name.
Also, is there a way to get my date format on deadline (2nd line from bottom) to read the date of 8 days from now? Ex: "Thursday, May 28"
Also, is there a way to get my date format on deadline (2nd line from bottom) to read the date of 8 days from now? Ex: "Thursday, May 28"
VBA Code:
.Body = "The forecast file for Format(DateAdd("m", 1, Date), "mmm") & "-" & Format(DateAdd("m", 3, Date), "mmm_YYYY") is ready to be updated" _
& vbNewLine & "If you need to add new customers to your forecast, please insert a new row above your last line item and highlight the new line in yellow. " _
& vbNewLine & vbNewLine & "DO NOT delete any columns or rows"& vbNewLine & vbNewLine & "DO NOT Freeze panes" _
& vbNewLine & vbNewLine & "DO NOT HIDE columns but ok to shrink the size so your view is better" _
& vbNewLine & vbNewLine & "DO NOT Freeze panes" _
& vbNewLine & vbNewLine & "Deadline to complete is (8 days from now) by 12pm " _
& vbNewLine & vbNewLine & "Click here to access the file: " _