Skip to main content

I have a use case related to Excel and would like to know if it's possible to build a solution without using VBA macros.

Specifically, I need Excel charts to be automatically updated and reflected in Outlook. However, I’d prefer not to use VBA scripts, as they require significant reengineering after deployment.

Do you have any suggestions or alternative solutions that could help achieve this?

@Nirupama G P 

Microsoft documentation and community support describe a workflow where you:

1. Copy a chart from Excel.

2. Paste it in Outlook as a linked Excel object (via Paste Special → Paste Link → Microsoft Excel Worksheet Object).

3. Right-click the object in Outlook and choose “Update Link” when the underlying Excel data changes. This refreshes the image or data embedded in the email.

Is this what you're trying to do?


@Aaron.Gleason  , Yes Exactly the same .

I’ve tried this approach and it worked well initially. However, after I moved the chart to a different column within the same Excel sheet, the link in Outlook started throwing an error—saying the object cannot be found at the linked URL


@Nirupama G P This is more of an Office question than Automation Anywhere. All I can suggest is to manually relink the chart. 

You may wish to consider a different workflow too. Maybe consider exporting the chart as a graphic and then attaching the graphic to the email. When you're working with OLE, you're certain to have issues.