e-mail, PROBLEM SOLVED

elgringo56

Well-known Member
Joined
Apr 15, 2002
Messages
869
Not sure I can explain this, but here goes.

I have a word document I want to send as the body of an e-mail. I want to attach a worksheet to it in the e-mail. My biggest problem is that I dont know how to specify to outlook express in Excel VBA to put the word document as the body of the e-mail. Any ideas?
This message was edited by elgringo56 on 2002-10-15 09:09
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

elgringo56

Well-known Member
Joined
Apr 15, 2002
Messages
869
Dennis, I tried this with my e-mail address in it and got a runtime error 1004, Method 'EnvelopeVisible' of object '_Workbook' failed. Havn't a clue what that means.
 

elgringo56

Well-known Member
Joined
Apr 15, 2002
Messages
869
Sorry, Denis. I figured that one out, I had netscape set as my email program, when I changed it back to OE, the error went away and the page sent.
 

XL-Dennis

Well-known Member
Joined
Jul 27, 2002
Messages
1,920
elgringo56,

Great! One problem less :)

Please mail back if You need some help with using it with MS Word.

Kind regards,
Dennis
 

Forum statistics

Threads
1,181,684
Messages
5,931,412
Members
436,788
Latest member
Oteez

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top