insert a chart in Outlook Body

S

Shirley

I need to insert a couple charts that are generated in ACCESS to Outlook
email body automatically using VBA, to dramatically increase communication
efficiency. I tried:

method 1 -- failed:
1. generate charts in Access
2. output it to a file in local drive
3. use html <img> to include the file in outlook body
result: receipant can't see as the <img> is looking for the file in local
drive

method 2 -- failed
1. generate charts in Access
2. use accmdcopy
3. create outlook file with other required message
4. try to use PasteFace or acCmdPaste, but didn't work

method 3 -- failed
1. generate charts in Access
2. use acCmdCopy
3. try to find the CID, so I can use <img> in html, but unalbe to make any
progress.

I believe there must be a way to do this. Really appreciate any help from
you...

Thank you in advance!!!!!!

Shirley
 
Top