Results 1 to 2 of 2

Thread: formatting lost for new replaced hyperlinks(word->outlook)

  1. #1

    Thread Starter
    New Member
    Join Date
    Jun 2011
    Posts
    5

    formatting lost for new replaced hyperlinks(word->outlook)

    I have written a code which replaces the text of certain format into a hyperlink. This code is invoked by a rule during an Incoming email.

    Incoming email -> copy the email to word editor -> make necessary changes -> copy from word editor to outlook mail item(replaced hyperlinks gets lost in mail item, while newly added text reamins intact)

    My code is here for your refernce..


    Code:
    Sub IncomingHyperlink(MyMail As MailItem)
      Dim strID As String
      Dim Body As String
      Dim objMail As Outlook.MailItem
      Dim myObject As Object
      Dim myDoc As Word.Document
      Dim mySelection As Word.Selection
      
      strID = MyMail.EntryID
      Set objMail = Application.Session.GetItemFromID(strID)
      
      'Creates word application
      Set objWord = CreateObject("Word.Application")
      objWord.Visible = True
      Set objDoc = objWord.Documents.Add()
      Set objSelection = objWord.Selection
      'Copies contents of email into word document
      objSelection.TypeText "GOOD" & objMail.HTMLBody
      
      With objSelection.Find
       .ClearFormatting
       .Text = "ASA[0-9][0-9][0-9][0-9][a-z][a-z]"
       .Forward = True
       .Wrap = wdFindAsk
       .MatchWildcards = True
      End With
      
      objSelection.Find.Execute
      objSelection.Hyperlinks.Add Anchor:=objSelection.Range, _
      Address:="http://www.code.com/" & objSelection.Text, _
      TextToDisplay:=objSelection.Text
      
      'Copies contents to email item from word document
      objMail.HTMLBody = objDoc.Range(0, objDoc.Range.End)
      objMail.Save
      Set objMail = Nothing
     End Sub
    Also, this code replaces only the first occurrence of the needed text and does not replace others.

    Please help solve these problems. Thank you...
    I have tried out different options and still not able to get it work.

  2. #2
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,974

    Re: formatting lost for new replaced hyperlinks(word->outlook)

    Thread moved from 'VB6' forum to the 'Office Development/VBA' forum (while VBA and VB6 have some similarities, they are not the same thing)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width