Using VBA to convert text to table

M

Mike K

I'm sending a comma separated string to Outlook via some Excel VBA
code. I'd like the VBA to automatically run the Table/Convert/Text To
Table function that's available in the Outlook toolbar.

Does anyone know how to do this?
 
E

Eric Legault [MVP - Outlook]

To do this, you'd have to be sure that the reader is using Word to read Rich
Text messages. If that condition is satisfied, then you can run this macro
with the e-mail already open:

Sub ConvertToTable()
Dim objWord As Word.Application, objDoc As Word.Document

Set objDoc = ActiveInspector.WordEditor
Set objWord = objDoc.Application
objDoc.Select
objWord.Selection.WholeStory
objWord.Selection.ConvertToTable (" ")

Set objDoc = Nothing
Set objWord = Nothing
End Sub
 
Top