ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   attaching specific files to e-mails (https://www.excelbanter.com/excel-programming/384974-attaching-specific-files-e-mails.html)

Stefi

attaching specific files to e-mails
 
Hi All,

I made good use of Ron de Bruin's Sub Mail_small_Text_Outlook(), thanks for
it.
Now Im 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

attaching specific files to e-mails
 
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



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Stefi" wrote in message ...
Hi All,

I made good use of Ron de Bruin's Sub Mail_small_Text_Outlook(), thanks for
it.
Now Im 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




All times are GMT +1. The time now is 12:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com