How to migrate to the Microsoft Outlook connector in Qlik Automate

[Emile_Koslowski]

The Microsoft Outlook connector in Qlik Automate has been updated to support file attachments.  This article describes how you can migrate your automations from the Mail connector to the Microsoft Outlook connector.

We strongly suggest that all Microsoft users make this update in order to prepare for Microsoft's deprecation of SMTP authentication for Outlook on March 1, 2026, as announced here.

To use the Send Mail with Attachments block, you must select default + attachment support permissions when setting up the Microsoft Outlook connection. This requires the Mail.ReadWrite scope, which needs to be approved by your company for the connection to be established successfully.

For more information about the Microsoft Outlook connector, see How to: Getting started with the Microsoft Outlook 365 connector in Qlik Application Automation.

Migration steps

1. Locate the current Send Mail block(s) in your automation
   
   Use the block search in the automation editor:
   
   
   
   
2. Add either the new Send Mail or Send Mail with Attachments block from the Microsoft Outlook connector
   
   Search in the connector tab on the left-hand side of the automation canvas for the Microsoft Outlook connector, open up the connector, then drag the required block into your automation.
   
   
   
   
3. Copy and paste the inputs from the old Send Mail block into the new block (Send Mail or Send Mail with Attachments); no modifications are necessary
   
   
4. Once all inputs are set, delete or disable the old Send Mail block
   
   
   
   

Environment

• Qlik Automate
• Qlik Cloud Analytics

[Crichter141]

Is there a walk through that could help us translate from Alert to Report if we want to use this option to replace the Alerts?  Maybe a video?  I'm still learning to understand Automations so I'd love one if one exists.  Thanks!

[Sonja_Bauernfeind]

Hello @Crichter141 

Reports and alerts are separate enough that a one-to-one migration doesn't have a solution. We do, however, have a template to Notify your team on Microsoft Teams based on a measure if that helps: Qlik Automate: Send notification on Microsoft Teams based on a measure. This can be combined with the Reload Finished webhook as explained in Qlik Application Automation and Slack: Send notifications based on app successful or failed reload.

If you need more detailed help, I recommend reaching out to our larger community and active support agents in the Qlik Automate forums.

All the best,
Sonja

[kpedersen]

Hi,

When trying to use the new MO365 "Send mail with attachments" I get this error: (Both with attachment and without)

When using the the MO365 "Send mail" everything is working fine. Both are using the same connection. 

Anyone knows why?

[Sonja_Bauernfeind]

Hello @kpedersen 

The error indicates an authentication problem. Review the credentials used. You can read more about the connector in How to: Getting started with the Microsoft Outlook 365 connector in Qlik Application Automation.

If this does not help, please post the question in the Qlik Automate forums, where our active support engineers and your knowledgeable Qlik peers can assist you best.

All the best,
Sonja

[Richard_Norris]

@kpedersen It looks like we need to grant admin consent for "Mail.ReadWrite" in Azure AD to the App. I don't see that in any of the Qlik documentation, but it's in the Graph API docs for creating a draft.

The older Qlik “Send Mail” presumably used Graph’s simpler “sendMail” endpoint (or even legacy Office-365 API) which only needs Mail.Send. The newer block uses /me/messages, a different Graph pathway that requires more privileged permissions to draft/write.

I'm going to message my admins to grant this today, I'll let you know if it works.

[Bel01234]

Hi, I'm trying to establish a connection, but it says I need access. 

I requested the necessary approval and received this email last week, but I haven't heard anything back yet.

What should I do?

Thanks

[Jk_R]

@kpedersen got the same problem you got.

Did it work out for you / did you open another Thread?

[Richard_Norris]

@Bel01234 Yeah, so, this request doesn't go to Qlik, it goes to your internal IT admin team. For me at least, when I did this the first time, the request got 'lost' among some other requests. I can't really be any more specific than that because I never saw anything at their end, but they explained that it took them some digging to find the particular thing they needed to actually 'approve', and it wasn't until I got on a call with them that they sorted it, just because, it wasn't totally apparent they needed to do anything.

[Richard_Norris]

@Jk_R did you try granting the app Mail.Readwrite ?

[Jk_R]

Yep, but same error message 😕