Mail worksheet in Body AND Attach File

  • Thread starter Thread starter BenS
  • Start date Start date
B

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!
 
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
 
Back
Top