I
Ian Elliott
Thanks in advance.
I want to make a macro in Excel that opens Outlook,
prompts the user to select and email and an attachment
(like msgbox), and when that attachment is selected, Word
opens it and searchs for a string.
Can I use the AttachmentRead event in the Excel macro to
trigger when an attachment is double-clicked in Outlook?
And should I use shell("\outlook.exe")
or Createobject(outlook.application")?
Thanks again.
I want to make a macro in Excel that opens Outlook,
prompts the user to select and email and an attachment
(like msgbox), and when that attachment is selected, Word
opens it and searchs for a string.
Can I use the AttachmentRead event in the Excel macro to
trigger when an attachment is double-clicked in Outlook?
And should I use shell("\outlook.exe")
or Createobject(outlook.application")?
Thanks again.