![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
![]()
I am trying to email a word doucument from Excel. I have some data in
Excel that I am inserting into a new Word document that I create from a template. Then I want to send that Word document as the BODY of an email which I can do manually by selecting File Send To Mail Recipient. In VBA, I can open the "EnvelopeWindow" but can not enter any info into the TO or Subject lines. I receive the following error. Run-time error '-2147417851 (80010105) Automation error The server threw an exception I also get this error when I try to save the Word document with SaveAs. I am not stuck on any one process but I would like to be able to send these messages automatically. As there are over 300 of these messages that need to be sent each month, I would like to eliminate this manual step. My code snippet: WDApp.ActiveWindow.EnvelopeVisible = True With WDApp.ActiveDocument.MailEnvelope .Item.To = " .Item.Subject = "SOX Review" End With |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
sending rtf,doc,text as message body in outllook 2003 in vb.net | Digit Solver | Outlook - Using Forms | 3 | March 31st 06 04:37 PM |
Insert a hyperlink to section of Word doc in an outlook message | [email protected] | Outlook - General Queries | 0 | February 8th 06 06:07 AM |
Body mail from MsWord | Marcelo | Outlook and VBA | 0 | February 6th 06 04:11 PM |
Embed an image in rtf doc (appointment or email body) | Sue Mosher [MVP-Outlook] | Outlook and VBA | 0 | February 1st 06 05:20 PM |
HTML in mail body - no display with Word option checked | Sue Mosher [MVP-Outlook] | Outlook and VBA | 0 | February 1st 06 05:14 PM |