Pasting Excel range as embedded object in outlooks body 
Author Message
 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



Mon, 05 Jul 2004 19:30:18 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Pasting excel range into outlooks body (rtf)

2. Paste from clipboard to outlook body in vb

3. Outlook CONTACT: copy/Paste BODY Field

4. Pasting Range from Excel 2002 via VBA to Word causes a New Workbook to open

5. Paste Special an Excel Range into a mail item

6. Woes = Excel Range to Word Doc paste = Guidance Please

7. How can I embed object an office document into Mailitem Body

8. Using VBA to embed excel ranges and graphs in a mail item

9. Using the Range object in Excel Object Library 9.0

10. Creating Excel Spreadsheet from Outlook message body data

11. Copying Excel Range into Outlook Note and E-mail

12. Paste picture from Excel into Outlook message.

 

 
Powered by phpBB® Forum Software