I have a document that has a worksheet for every day of the month. The names of each tab are numbered 1-31 (or 30 depending on the month). The name of the document ends in "2013-09"(where the 09 would change to 10 if the month were Oct, 11 for Nov, etc).
CODE 1
I send each worksheet out the day after the day of the worksheet (so Sept 20 gets sent out on Sept 21). This works for everyday except the very last day because this code takes the name of the current month. So when I do Sept 31, which is sent on Oct 1, it's going to say Oct 31 in the subject line.
CODE 2
This code will work as long as you send the document on the day you're supposed to. So if I send Sept 19th's info on Sept 20th no problem. But if I am not in the office and I need to send more than one day's info, it's going to put yesterday's date on both emails.
Does anyone have any suggestion on how I can make my custom subject line work? Perhaps base it on the latter part of my document name? (which ends in 2013-09 for Sept).
Bookmarks