Am 19 Jan 2006 06:15:06 -0800 schrieb chimp:

Thanks, now I understand you :-)

You do know the fixed file name, you need to know the date, and now you also
do know how to join strings. That´s all.

FileName = "fixed part" & Format(TheDateInQuestion, "yyyymmdd") & ".csv"


--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook



Thank you for your response, Michael. I re-read my initial post and
realized I failed to make myself clear concerning the second issue.

When our trading system creates the report on a daily basis, it
automatically adds the date to the end of the filename. For example,
yesterday's reports was named:

DestExecDetailsReport20060118.csv

Today's reports will be:

DestExecDetailsReport20060119.csv

My question is how do I reference a report that changes names everyday,
and attach it to an email, in my macro? In my test macro, I simply
used the static filename of TEST.txt to add that document as an
attachment to the generated email:

.Attachments.Add "c:\temp\TEST.txt"

However, the report I want to automatically attach using a macro
changes names everyday. Is there a way to attach that report that
changes every day to an email? And if so, I would I reference it in my
macro?

Thanks again for your help.