
Pasting Excel range as embedded object in outlooks body
I'm trying to get Excel and Outlook (97 and 2000) to work
together.
Creating a workbook and sheets in Excel from VB or
VBA is
not the problem, nor is creating an email message but what
I want to do is to copy part of a worksheet and paste it
into the email's body as an embedded item. (the entire
workbook would be
sent but an specified range would be shown in the emails
body)
I haven't found a way to do it.
Anybody???
Thanx in advance.
Ben
-----Part of the outlook code-----
With objOutlookMsg
..To = Rst!email
..Subject = "Address Check"
..Body = "Dear " & Rst!Title & " " & Rst!LastName &
vbNewLine & vbNewLine
..Body = .Body & "blablabla"
..Body = .Body & vbNewLine & "Ben"
'Here I want to paste the Excel.selection
..Importance = olImportanceHigh
..Send
End With