Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-26-2014, 11:18 AM
niton niton is offline Macro problem Windows 7 64bit Macro problem Office 2010 64bit
Competent Performer
 
Join Date: Jul 2012
Posts: 102
niton is on a distinguished road
Default

Where you see

Code:
 
' replace the With block with your code
       With objSel
       ' Formatting code goes here
            .Font.Color = wdColorBlue
            .Font.Size = 18
            .Font.Bold = True
            .Font.Italic = True
            .Font.Name = "Arial"
       End With
use

Code:
 
objSel.PasteSpecial Link:=False, DataType:=wdPasteText

Code:
 
Public Sub PasteUnformatted_OutlookVersion()
    Dim objItem As Object
    Dim objInsp As Outlook.Inspector
 
    ' Add reference to Word library
    ' in VBA Editor, Tools, References
    Dim objWord As Word.Application
    Dim objDoc As Word.Document
    Dim objSel As Word.Selection
 
   'On Error Resume Next ' <--- Do not use this unless you have a specific purpose
 
'Reference the current Outlook item
    Set objItem = Application.ActiveInspector.CurrentItem
    If Not objItem Is Nothing Then
        If objItem.Class = olMail Then
            Set objInsp = objItem.GetInspector
            If objInsp.EditorType = olEditorWord Then
                Set objDoc = objInsp.WordEditor
                Set objWord = objDoc.Application
                Set objSel = objWord.Selection
 
                objSel.PasteSpecial Link:=False, DataType:=wdPasteText
 
            End If
        End If
    End If
 
    Set objItem = Nothing
    Set objWord = Nothing
    Set objSel = Nothing
    Set objInsp = Nothing
End Sub

Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
EXCEL macro problem please help! ryguy551 Excel Programming 2 05-22-2014 03:58 PM
Problem with macro MS baby Excel Programming 4 03-31-2014 02:47 PM
Macro problem Problem with macro tmill29 Excel Programming 1 06-08-2013 09:59 AM
Macro problem Moving data macro problem MattMurdock Excel Programming 1 07-20-2012 04:49 AM
Macro problem Another simple macro problem Ulodesk Word VBA 1 06-08-2012 06:24 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:20 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft