Thread: Send email with 2 or more attachments
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default Send email with 2 or more attachments
Hi

Repeat the Attachments.Add lines in my Outlook examples

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

If you use the SendMail examples it is not possible


--

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


"al_ba" <al_814 wrote in message ...
Hello,

Is there a code to send 2 or more (XL workbook) as email attachments? I used
Ron's code to attach 1 whole workbook in an email. I am using Microsoft
Outlook. XL 2003. Help please.

Thanks in advance.
Reply With QuoteReply With Quote