Custom subject line with vb

[Wheelie686]

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

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

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).

[tehneXus]

Please Login or Register  to view this content.

This will give you the Month abbreviation according to the month number in the filename which is alsways the last part of th ename before the extension separated by "-", e.g. 2009-08 will be "Aug"

[Kenneth Hobson]

Please Login or Register  to view this content.

[Wheelie686]

Much appreciated tehneXus! Works perfect!