Graphs in E-Mail

[nagasrikanth]

Hi every body,

Good morning to all of u..

A small query from me.. "Is it possible to insert a graph in E-Mail"

If yes..How'z that possible..

Thanx & Regards
Srikanth.

[RobDog888]

A graph from Excel? Which version? Using any email client or ?

[nagasrikanth]

Hi Rob,

Actually im sending an mail in the following format (in a tabular format..here it was not coming tabluar way)

Sector No.of Datasets Planned No.of Datasets Realized Backlog
*East 0 0 0
*North 3 0 3
*North East 4 2 2
*ROE 0 0 0
*South East 1 0 1
*South West 2 0 2
*West 0 0 0

Now i want to include a graph also in my mail as shown in attachment..(basically the data will come from a Access Query)

[RobDog888]

You probably will be able to easily select and copy the chart as an image for pasting into your emails rtf or html body.

ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.ChartArea.Select
ActiveChart.ChartArea.Copy
 
'More code to bring up whatever email client or Outlook or ? for the paste
'...
'...