VBA open outlook attachment in its own application

gazmoz17

Board Regular
Joined
Sep 18, 2020
Messages
158
Office Version
  1. 365
Platform
  1. Windows
Hi,

How do I do this? Not necessary for me to save the attachment unless that's necessary to achieve me viewing the file in its own application.

Currently use autohotkey to single click where 1st attachment should be and from there send ALT JAOP to fire the open attachment in its own application button.

Aware could have this button in QAT but still need to highlight the attachment.

*I don't need to do this for multiple attachments in the same message, messages where multiple attachments I can click individually.

Some times my Attchment location co-ordinates will differ so it doesn't always highlight the attachment to then fire the rest of the autohotkey script.

To add I don't want generally open an email in its won window but from the reading pane.

Many Thanks
Gareth
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
If you double-click the attachment, doesn't it open in the default application for that file type?
 
Upvote 0

Forum statistics

Threads
1,214,978
Messages
6,122,549
Members
449,089
Latest member
davidcom

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top