Mail worksheet in Body AND Attach File

[BenS]

Hi,

I'm successfully using Ron DeBruin's great code found here
(http://www.rondebruin.nl/mail/folder3/mail2.htm) to send emails with an
Excel worksheet in the body of the mail.

What I'd like to do, but have not been successful, is also attaching the
Excel file to the email. I thought this might be straightforward, by taking
code from Ron's other examples, but it hasn't worked.

I've tried adding the line:
Attachments.Add <PATH>

I don't get an error, but I also don't get the attachment. Can anyone offer
any suggestions here as to how I might get this to work?

Thanks!

 

[Ron de Bruin]

Hi Ben

Try this

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

 

[BenS]

Hi Ron,

That did it! Thank you so much, not only for the lightning fast reply, but
for all of the information on your web page. I can't tell you how many times
I've been able to solve a problem at work thanks to your site.

Kind regards,
Ben

 

[Ron de Bruin]

You are welcome