This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi,
When I create mail with SharePoint links in body, Outlook is trying to check whether all recipients has access to the link or not.
I would like to suppress this pop up through VBA. Any suggestions will be appreciated.
Please refer to the attachment.
Regards,
Sakthi
hi guys,
instead of using .send please use :
Application.SendKeys "%s"
Application.SendKeys "s"
this works for me
Hi @Alexander ,
Greetings, Kindly suggest if you have any solution for handling the above pop up.
Thanks & Regards,
Sakthi
Hi @Sakthi-31397 ,
As I know, there's a function in outlook as shown in the below picture which can't be turned off.
Does your recipient include people who don’t have access to the links? If so, will the pop-up appear if only the email containing this link is sent to the people who have access to it?
Through my research, considering the impact of sharing permission of SharePoint links, if you are using a personal account, it is recommended that you check the sharing permission of SharePoint links. If you are a member of an organization, it is suggested that you could contact your administrator and research the shared permissions to see if the permissions of links can be modified. For more information, please refer to:
Manage sharing settings
Change the default link type for a site
And I noticed that you want to get some suggestions about VBA, please kindly understand that the Outlook tag here we mainly focus on general issues about Outlook desktop client and know little about VBA. In order to better solve your problem, it is suggested that you could add "office-vba-dev" tag for your post. Thanks for your understanding!
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hi @ChristyZhang-MSFT ,
Thank you for your suggestion.
Hi @Sakthi-31397 ,
Just checking in to see if above information was helpful. If you have any further updates on this issue, please feel free to post back. If you think my reply is helpful to you, please remember to mark it as an answer. Warm thanks.
Hi @Sakthi-31397 ,
Is this issue resolved now? If so, would you mind marking the helpful post as an answer? Which would benefit others who also has similar issues in forum.
Hi, in our company we are always late with OS and MS Apps updates, but I am pretty sure that the issue is still not solved.
The fact that this problem is related to VBA automation is not important.
So-called "Link Preview" was introduced to Web versions of Outlook with the proper UI changes and supporting documentation, such as:
https://support.microsoft.com/en-us/office/use-link-preview-in-outlook-com-and-outlook-on-the-web-ebbfd8ce-d38e-40ef-bb8c-a5362e881163
Now, it's also live in the desktop app, but without any changes to the settings menu...
Could you please give us the Registry path and key to be changed to disable "Link Preview"?
Obviously this is a very inconsiderate FAILED design.
Think if you are sending one email containing 10 links to 10 colleagues. Each colleague can access one own link but not the other 9 links. This is a very common case, but the access check is just annoying to warn "some one cannot access some link".
Of course I don't what to send 10 emails to 10 people.
hi guys,
instead of using .send please use :
Application.SendKeys "%s"
Application.SendKeys "s"
this works for me
Sending key is a dirty and unstable workaround, not a solution.
Imagine another window/dialog pops out during running macro, you never know what mess the %s and s key would cause. Also, if screen auto-locks after several minutes, this SendKey trick just fails.
Sending key is not reliable. During running macro, if another window/dialog pops up or if Windows auto-locks, then this trick just fails.
This issue bit me this morning. I have an Excel macro that sends an email to myself with a link to a file in a Sharepoint/OneDrive site, and the popup was hanging the macro until I acknowledged that all recipients do indeed have access to my file.
I haven't found an Outlook setting to explicitly disable those popups, but I did notice that the popups only happen for me if my VBA code is .Displaying the new email message before I'm .Sending it.
I don't actually need to .Display it first, so I tried commenting that out, and now the emails are being sent again and the macro doesn't hang.
I know this is an old question, but I have the answer for those who are currently searching as I was.
From the Microsoft website:
To troubleshoot links not working in an email message, use the following steps.
Check to see if the email message you're composing or viewing is in plain text.
Check to see if an InfoBar at the top of the message informs you that links are disabled. If so, click the button in the InfoBar to enable external content.
In Outlook 2010, check your Junk Email options.
In the Delete group, select Junk > Junk Email options.
On the Options tab, clear the Disable links and other functionality in phishing messages (recommended) checkbox.
If some (not all) of your links can see and use your links and some cannot, it is mostly point 1.
POINT 1 WAS THE ONLY ONE I TRITED AND IT SOLVED THE PROBLEM FOR ME.
Sign in to comment