How to click YES for the popups when open an Outlook Email template from Excel Macro?

Dear all,
Please help me, I have a problem recently.
What I was trying to do is that I have macro in excel to open a email template in Outlook to send out. And the email template in outlook contains link to other excel data. So when the template is opening, there is a pop up window saying: "the document contains links to other data, do you want to update the links?". Everytime the excel will stuck here and I need to swich to outlook window to click Yes then the marco will continue. Please do you have any idea what I can put in my macro to click Yes to update the links. Or, is there any setting in outlook whenever there's link, don't ask me and just update it? Thank you so much!! Waiting online for the answer... :thumb:

My code is simple:

Sub OutlookTemplate()

Dim myolapp As Object
Dim myitem As Object

Set myolapp = CreateObject("Outlook.Application")
myolapp.Session.Logon

Set myitem = myolapp.CreateItemFromTemplate("C:\test\outlook template test_.oft")
myitem.display

End Sub

Perhaps adding command "UpdateLinks" to your macro will work?

Please Login or Register  to view this content.

Alf

Originally Posted by Alf

Perhaps adding command "UpdateLinks" to your macro will work?

Please Login or Register  to view this content.

Alf

Thank you for your reply Alf.
but update links is not working. Excel will be in dead model, unless I change to the window of outlook, then I'll see the pop up windows asking if wanna update the linked data.
Is there other ways? or, is there way in outlook to disable this asking to automaticlly update the linked data? Thank you!

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here