I send out files each day to predetermined distribution lists. Each day the file names change because they end with the current date. Today's file is "test 02-17-10.doc" and tomorrow it will be "test 02-18-10.doc".
How can I set this up to append today's date to the file name in Total Access Emailer? I currently send the files with an Outlook macro and have it set up as shown below where the file name, today's date and file extenstion are concatenated. I need to accomplish the same thing in TAE.
olkFileDate = Format(olkTodaysDate, "mm-dd-yy")
"TOMATOES " & olkFileDate & ".rtf"
One of the attachment options in TAE is to reference the path and file name in a table field and I was wondering if this might be where I could set it up to work dynamically based on Today's Date.
Thanking you in advance.