Email Workseet as Body of email

  • Thread starter Thread starter sunilkeswani
  • Start date Start date
S

sunilkeswani

Hi

I have tried the www.dicksclicks.com function and macro, it works, but
somehow, because it converts to HTML, the graphs and charts don't
apeear on the email body....can i not format as rich text and send
email on body?

Cheers
Sunny
 
Hi Ron. I have used your code before. Nice to get a response from you.

I use Office 200. Is there another way out?
 
Hi Ron. I have used your code before. Nice to get a response from you.

I use Office 2000. Is there another way out?
 
Hi Sunny

No not with code in 2000
The only way is to create a picture of the range and send that.
 
Hi Ron,

Can you please help me with automating this? Is there no way I can
automate creating a picture of that range and sending email through
Outlook 2000?

Regards

Sunny
 
Hi Sunny

I want to create a example for this on my site but don't have much time on this moment.
I want tu use Code from Harald staff for this.

A simple example is this that create a sile in C
You can use the outlook code from my site to send it

Sub Testing()
Application.ScreenUpdating = False
Selection.CopyPicture Appearance:=xlScreen, Format:=xlPicture

Set ctoTheChartHolder = ActiveSheet.ChartObjects.Add(0, 0, 800, 600)

Set chtTheChart = ctoTheChartHolder.Chart

' Paste the picture onto the chart and
' set an object variable for it
ctoTheChartHolder.Activate
With chtTheChart
.ChartArea.Select
.Paste
Set picThePicture = .Pictures(1)
End With

' Set the picture's properties...
With picThePicture
.Left = 0
.Top = 0
sglWidth = .Width + 7
sglHeight = .Height + 7
End With

' Change the size of the chart object to fit the picture
'better
With ctoTheChartHolder
.Border.LineStyle = xlNone
.Width = sglWidth
.Height = sglHeight
End With
' Export the chart as a graphics file
blnRet = chtTheChart.Export(Filename:="C:\range.gif", _
FilterName:="gif", Interactive:=False)
ctoTheChartHolder.Delete
Application.ScreenUpdating = True
End Sub
 
Thanks Ron, the above code works great, I had a look at your site, but
how do I add this image with the HTML format Outlook email's body?

Regards
Sunny
 
But I want in on the body of email. Is that not possible at all ? With
2000? Maybe another macro in Outlook to insert image before sending
that mail ? Just wondering
 
No, most people can see pictures in there mail program.
Time to upgrade (wait for Excel 12)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Email Macro-using range for email address,ccc,bcc,subject and body.Office Outlook as email 3
Paragrph in Email Body 3
Email Help: Email with voting buttons from excel, Body gets delete 0
Publishing XCL Range to HTML to insert into Email Body 1
How to include Excel charts in Outlook email *body* with VB 7
Outlook Looking for macro to save multiple emails as .msg to folder and extracting the invoice ref. from the email body as the filename 4
Display file path as hyper link in outlook email body 1
Copying Cell Value AND Format into Email Body Macro 1

Back
Top