(LEO)_reading file name from outlook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
i need to e-mail everyone their salary slips whose files formats are MDI.
The file-names are the same as their e-mail address aliases.
so for automation, i need the VBA code read and get the filenames in a
string array, which then i can send them each their own files in a loop.
How can it be done in Outlook VBA?! in other word, how can I retreive the
file name in a particular folders, assign them to a string array variable??!
 
Am Tue, 13 Sep 2005 23:02:02 -0700 schrieb Leo:

Leo, you can add a reference on the Microsoft Scripting Runtime to your
project and use its FileSystemObject.

The function FileExists returns true if a specified file exists. GetFolder
returns a folder object which in turn has a Files collection.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
Hi,
i need to e-mail everyone their salary slips whose files formats are MDI.
The file-names are the same as their e-mail address aliases.
so for automation, i need the VBA code read and get the filenames in a
string array, which then i can send them each their own files in a loop.
How can it be done in Outlook VBA?! in other word, how can I retreive the
file name in a particular folders, assign them to a string array
Click to expand...
variable??!
 
Back
Top