getinspector.wordeditor.range.paste will overwrite the body in Outlook

[jimmy123j]

I script the auto mail by OutlookEX, and need to copy the Excel range into Outlook body

But used the getinspector.wordeditor.range.paste will overwrite the body

And getinspector.wordeditor.range.collapse($wdCollapseEnd) or .collapse(0) no response

I used the OutlookEX create Outlook item by the way

'cause the company security (IT lock the upload system), I can' upload and file, even answer the post, sorry

 

[JLogan3o13]

12 minutes ago, jimmy123j said:

'cause the company security (IT lock the upload system), I can' upload and file, even answer the post, sorry

 

If you cannot post your script then you are out of luck, our last crystal ball just went into the shop. You mention in your title copying an Excel range but then state you are using getinspector.wordeditor functions. If you are copying out of excel you should be using the _Excel_* functions (look in the help file). Beyond that, without seeing your script it is pretty much impossible to help you fix it.

[jimmy123j]

22 minutes ago, JLogan3o13 said:

If you cannot post your script then you are out of luck, our last crystal ball just went into the shop. You mention in your title copying an Excel range but then state you are using getinspector.wordeditor functions. If you are copying out of excel you should be using the _Excel_* functions (look in the help file). Beyond that, without seeing your script it is pretty much impossible to help you fix it.

 

I script at my company, my code almost like this

$oExcel = _Excel_Open()
$oWorkbook = _Excel_BookOpen ($oExcel, "D:\Desktop\123.xlsx")
$oWorkbook.Sheets(1).UsedRange.Copy
_Excel_Close($oExcel, False)

$oOutlook = _OL_Open()
$oItem = _OL_ItemCreate($oOutlook, $olMailItem)
$oItem.To = "ABC@123.com"
$oItem.CC = ""
$oItem.Subject = "Auto Mail Testing"
$oItem.HTMLBody = "Hello World,"
$oItem.Getinspector.Wordeditor.Range.InsertParagraphAfter()
$oItem.Getinspector.Wordeditor.Range.Collapse($wdCollapseEnd)
$oItem.Getinspector.Wordeditor.Range.Paste
$oItem.Display

 

I hope the mail body can be

 

 

But the body always like

 

[water]

I suggest to use the Word editor to create the full mail body including ‚Hello world‘

[jimmy123j]

9 hours ago, water said:

I suggest to use the Word editor to create the full mail body including ‚Hello world‘

Thank you water, it's work to me

But any possible to use the Outlook only ?

I mean I don't like to use excel to word, then to outlook, that's complex  = ="

[water]

If you can manage to create HTML for everything and then set property HTMLBody ...

[macran]

TRY:

 

12= length("hello world!")

$oItem.Getinspector.Wordeditor.Range(12).Paste