Graphs in E-Mail

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. :)

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

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)

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

VB Code:

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
'...
'...