Hi,
Trying to copy and paste a range of Excel data as TEXT to Outlook email, I can't find the proper way to do it. Here are parts of my code that works but without pasting as TEXT
'set active inspector
Set wEditor = mailApp.ActiveInspector.wordEditor
Set ObjSel = wEditor.Windows(1).Selection
[..]
Range("E5").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy
ObjSel.Select
'Paste data as Excel Format
'ObjSel.Application.Selection.Paste
'Doesn't past Data as Text to Outlook as I was expecting
ObjSel.Application.Selection.PasteSpecial DataType:=wdPasteText
Any kind of help appreciated.
Regards
Bookmarks