![]() |
#8
|
|||
|
|||
![]()
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 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 |
|
![]() |
||||
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 |
![]() |
tmill29 | Excel Programming | 1 | 06-08-2013 09:59 AM |
![]() |
MattMurdock | Excel Programming | 1 | 07-20-2012 04:49 AM |
![]() |
Ulodesk | Word VBA | 1 | 06-08-2012 06:24 PM |