![]() |
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 have a word file with VBA to save the content to Draft in Outlook. It works
but the link in the content change to text rather than link even if it is actually a link in Word and I have set the mail format to HTML in Outlook. I find the end of each line in the draft mail contain a space and the link recovers if I delete the ending space. Grateful if you can help with the following word VBA. Private Sub CreateOutlookMessage() Dim objOutlook As Outlook.Application Dim objOutlookMsg As Outlook.MailItem On Error GoTo ErrorMsgs ' Create the Outlook session. Set objOutlook = CreateObject("Outlook.Application") ' Create the message. Set objOutlookMsg = objOutlook.CreateItem(olDraftItem) With objOutlookMsg .To = " .Subject = "test" .BodyFormat = olFormatHTML .Body = ActiveDocument.Content .Save End With Set objOutlookMsg = Nothing Set objOutlook = Nothing Set objOutlookRecip = Nothing Set objOutlookAttach = Nothing Exit Sub ErrorMsgs: If Err.Number = "287" Then MsgBox "You clicked No to the Outlook security warning. " & _ "Rerun the procedure and click Yes to access e-mail" & _ "addresses to send your message. For more information, " & _ "see the document at http://www.microsoft.com/office" & _ "/previous/outlook/downloads/security.asp. " End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Extract word document content and save in MS Access | Raju A[_2_] | Outlook and VBA | 0 | September 3rd 07 11:50 AM |
Extract word document content and save in MS Access. | Raju A[_2_] | Outlook and VBA | 0 | September 3rd 07 11:50 AM |
Currently opened document content from word/ppt/Excel ? | Malleswar | Outlook - Using Forms | 0 | July 18th 07 04:58 PM |
Word attachments go to Content.IE5 folder | PeggyN | Outlook Express | 9 | March 26th 07 08:36 PM |
Problem in getting the content of email | Danish | Outlook Express | 1 | April 26th 06 08:46 PM |