A
Andrew@Telstra
To Whom it may concern,
I am using an Excel 2003 marco to create a number of emails, with attached
files. The files I am attaching follow a "format", are CSV type, and are
unique to the folder, but are not sequential, eg., CML_1234567.csv. I've
tried a few versions of the following code (without success);
.Attachments.Add (PathtoFile & strFileA & "CML" & "*" & ".csv")
&
.Attachments.Add (PathtoFile & strFileA & "CML" & "*.csv")
How can I use a "Wildcard" to select a file for attachment to an email?
TIA
Andrew from Telstra
I am using an Excel 2003 marco to create a number of emails, with attached
files. The files I am attaching follow a "format", are CSV type, and are
unique to the folder, but are not sequential, eg., CML_1234567.csv. I've
tried a few versions of the following code (without success);
.Attachments.Add (PathtoFile & strFileA & "CML" & "*" & ".csv")
&
.Attachments.Add (PathtoFile & strFileA & "CML" & "*.csv")
How can I use a "Wildcard" to select a file for attachment to an email?
TIA
Andrew from Telstra