Share via

How would I mail merge from a Word document template and excel file using power automate?

Anonymous
2023-03-09T14:15:44+00:00

Hi,

I have a word document which is a template for mail merge. The document contains a picture as well. I have to use this template with the picture. How can I use power automate and perform mail merge with a Word document.

I need an urgent help regarding this. Because by default the Word mail merge ruins the picture resolution

Thanks

Outlook | Windows | Classic Outlook for Windows | For home

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-03-09T18:34:35+00:00

    Dear Imranul,

    Thanks for your updates.

    When using the email body in Power Automate, you may need to use HTML content. So you may adjust the code to apply to the alignment of your Word template.

    If it is convenient, I'd like you to share the file of the template you are using for us to see if the content can be emailed via Power Automate suitably. If the file and the file link can be shared here directly, please add your confirmation and provide the file link here.

    If no, welcome to let us know and we'll take the next step to collect the file.

    Thanks for your effort and time!

    Sincerely,

    Cliff | Microsoft Community Moderator

    Was this answer helpful?

    0 comments
  2. Anonymous
    2023-03-09T15:29:20+00:00

    Thank you so much for the suggestion. But I have a mail merge template in Word. It has some alignments too. The coded process will break the alignments and also the problem with mail merging with outlook and word is that, the image gets distorted.

    For this I was looking for a suitable solution in Power Automate

    Was this answer helpful?

    0 comments
  3. Anonymous
    2023-03-09T15:19:39+00:00

    Dear Imranul,

    You may convert the Word file content to HTML first and then use the flow to send emails to each user in the sheet.

    Here is a demo for your reference.

    Create a sheet like the following in a site in SharePoint Online.

    Create the HTML email body like the following.

    <!DOCTYPE html>

    <html>

    <body>

    <h2>Hi This is a test file</h2>

    <h3>Have a Good Day and Please see the picture below</h3>

    <img src="data:image/jpeg;base64,/9j/4AAQSkZJRgABA***CQcJCQkJCwkJCQkJCQsJCwsMCwsLDA0QDBEODQ4MEhkSJRodJR0ZHxwpKRYlNz***"" />

    </body>

    </html>

    To show the image in the HTML code, you may use the dataUri string.

    For your reference: Solved: Image Not Showing in PDF - Power Platform Community (microsoft.com)

    Finally create the flow as follows.

    Result:

    Welcome to share any updates when you have time if you need further help on this issue.

    Thanks for your effort and time!

    Sincerely,

    Cliff | Microsoft Community Moderator

    Was this answer helpful?

    0 comments