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