automatically attach and send by e-mail

Hi Simon. This code can be used for your purpose. It will send an Outlook email to the recipients whose email addresses are in A1 and CC to A2. Please modify as needed.

Also, when you copy this code into the VBE, be sure to select Tools > References, then check the box for "Microsoft Outlook xx.x Object Library".

Please Login or Register  to view this content.

HTH

Jason

Hi, thanks! But I wouldn't want the mail to be sent automatically, which seems to be what this macro is doing. Rather I just want the New Mail to pop up with the file attached and the 2 recipients in it. They will have to write their own additional text and send it. How can I do that ?

Just change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Jason

Perfect, thanks a lot !

No problem, Simon.

Jason

Hm.. I have another problem, probably nothing serious as I'm not an expert:
I have a macro that copies one sheet of the workbook to a new one, but the new, generated sheet still has the link to the old one for my mailing macro and it also attaches the old source sheet, not the newly generated one. How can I change that ?

I'm not positive, but I think in order for the above code to work, the workbook needs to be saved first. Also, you can try changing ThisWorkbook to ActiveWorkbook.

HTH

Jason

Sorry VBA Noob, is it because I asked the same question in a new thread ?
@ Jasoncw: Thanks, I got it to work with a command button, the only problem I have is that Microsoft Outlook Object Library isn't enabled in the new, generated workbook, so it doesn't work until I enable it manually. (which I can't make the users do)

Got it to work, am a happy man now !
Thanks for the help,

Simon

Glad you got it, Simon.

Jason

I still seem to have the problem sometimes when other people open the workbook on their computer that they haven't got object library enabled, shouldn't it be enabled because of the workbook itself ?