Sending an attachment where the name contains todays date.

[tozey]

Hello, I am having trouble with this part of my code.



Set objOutlookAttach = .Attachments.Add("C:\Export\TTF" & "*" & ".xls")"

above is the last attempt of getting it right, my file name is TTF190312.xls tomorrow it will be TTF200312.xls. I want my code to pick up this file.

It is the only file in the folder, I just to be able to pick the file up daily and send it...I keep getting an error saying the path doesnt exist (even though it does)

Any ideas how I can get this code to pick up my file regardless of what the 6 digit number is after the TTF.

Thanks in advance

Alex

[June7]

Can't use wildcard. Must specify file name. If you know the file will be there and name will include current date, try:

("C:\Export\TTF" & Format(Date(), "ddmmyy") & ".xls")"