attaching specific files to e-mails

[Stefi]

Hi All,

I made good use of Ron de Bruin's Sub Mail_small_Text_Outlook(), thanks for
it.
Now I’m looking for a solution for attaching specific files to e-mails sent
via Excel. I would greatly appreciate if anybody could give me some tips how
to achieve this.

Regards,
Stefi

 

[Ron de Bruin]

I reply to your private mail, please not post private and in the newsgroup at the same time.

In my other Outlook examples you can see that you can add a line in the code like this

..Attachments.Add ("C:\test.txt")

before the .Send line

You can repeat this line for every file you want

Have a nice weekend