Mail Merge causing constant security pop up

Hi

I have a client who is trying to do a mail merge and sending emails via Outlook. The HTML option works OK but if trying to send as an attachment they are constantly getting the pop up stating "A program is trying to access email address information stored in outlook" over and over again. Usually, when I've seen this you can click allow access for and set time however while you can click the box there is nothing in the drop-down box to select a time to allow access for. The user has to click allow over and over again

Things of note

The AV is up to date
I can reproduce this issue on any laptop or PC, I've ruled out any environmental issues caused by policies that may be set by trying this on a home PC and laptop. We are using ESET on the domain PC but just defender on the home PC / Laptop

Reproducible on x64 and x86 versions of Microsoft Office 365.

The latest version of M365 has been tried

I've opened all apps as an administrator to see if that makes a difference, it didn't

I've set the programmatic access security to never warn me about suspicious activity, made no difference

Steps to reproduce

Create a spreadsheet with any heading in A1 and some email addresses in A2,A3 etc

Open a word document and start a mail merge

Select the recipients from an existing list and use the excel document as the source

Click finish and merge and select send email messages

At this point if you use the mail format  HTML it should work, if you use the mail format attachment you should get the issue reported

* Please try a lower page number.

* Please enter only numbers.

* Please try a lower page number.

* Please enter only numbers.

Hello Norman McLean,

Thank you for sharing this with us. I’m aware of it and may I further collect current version and Microsoft 365 suite product for further testing and consulting? You can open Outlook -> File -> Office account to check this information.

Besides, if you want to temporarily prevent this window from appearing, you can try the method in this article to see if it works for your situation: I get warnings about a program accessing email address information or sending email on my behalf

Best Regards,

Anna

--------* Beware of Scammers posting fake Support Numbers here.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Hi

We'll I've tried it on various machines and various versions, I don't have access to the client's machine at the moment but it's not limited to one machine and occurs across a range of versions (the home PC and laptop are x64 office, the works laptop and the clients laptop are x86 office)

This is my works laptop 

And this is my home PC

And this is my home laptop

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Hi Norman McLean,
          
According to your detailed reproduce steps, I’ve test it again on Word version 2008, I get the same behavior as yours, see the below screenshot.
 

  

Considering your scenario, you can refer what Anna suggests to check if it works, moreover, as we can reproduce it, we think it could be a bug, so given this situation, we sincerely recommend you go to Feedback to the related team. Please click File> Feedback> I Like Something.
      
Appreciate your understanding and cooperation again!
       
Wish you a nice day!😊
      
Best regards,
Gloria

-----------------------
* Beware of scammers posting fake support numbers here.
* Kindly Mark and Vote this reply if it helps, as it will be beneficial to more community members reading here.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Hi

Anna's solution was one I've already tried I'm afraid

I have submitted feedback

Regards

Norman

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Norman,

The Outlook In App team has logged a bug for this issue.  If I get any update on fix status I'll post back.  Just wanted you to know it is being followed up on.  

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Hi,

Is there any update on this as we have the same problem and it is causing us massive issues, as we can't send documents out via a mail merge. We're having to click allow manually for each record.

Thanks 

Neil









Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

@Neil,

I checked the bug and the dev has created a fix and she is getting ready to check it in.  We are likely still a couple weeks from the fix getting to Insider/Beta.  

If the issue started in the versions listed above you could workaround the issue by reverting Office to a build before the issue started.  If you want to try this here are the instructions:

1.  Open a Command Prompt

2.. Type/Paste the two commands below one at a time and press Enter after each

cd %programfiles%\Common Files\Microsoft Shared\ClickToRun 
officec2rclient.exe /update user updatetoversion=16.0.13001.20498


I pulled the version from the Update History page, Update history for Microsoft 365 Apps (listed by date) - Office release notes | Microsoft Docs.  

If that version works in Outlook click File, Office Account, Update Options, Disable Updates.  Then add an appointment on your calendar to re-enable updates in early January.  The fix should be in the 2012 Version.  The 2011 version is going out 11/23/20 and Office might wait until early January after the holidays to release 2012 version.   

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Hi Neil,

 

Thanks for sharing your experience in our community, regarding to your issue, we kindly suggest you post a new thread and other community engineers will further investigate it.

 

Appreciate your cooperation!

  

Best regards,

Gloria

-----------------------
* Beware of scammers posting fake support numbers here.
* Kindly Mark and Vote this reply if it helps, as it will be beneficial to more community members reading here.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Hi Gloria,

Why would I start a new thread when I have exactly the same issue, and you say a bug has been logged for it? I was merely asking if it has been sorted as we have the same issue and it is causing massive issues.

Kind regards

Neil







1 person found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

I too am having this issue. How can I be notified when the bug is fixed?

1 person found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

* Please try a lower page number.

* Please enter only numbers.

* Please try a lower page number.

* Please enter only numbers.

 
 

Question Info


Last updated July 1, 2024 Views 4,872 Applies to: