Technologiate
Technologiate
  • 110
  • 1 214 608
How to Mail Merge with Separate Attachments using Power Automate | Send Mails with Separate Files
In this video, you will see how to send multiple emails with separate attachments for each recipient (Mail Merge with Separate file) using Power Automate. The process only works when you want to send files to each of the recipients. If you want to send mail merge with Power Automate without an attachment, watch this video: ua-cam.com/video/ItrVEQCwKW0/v-deo.htmlsi=JpQf4oVG8Ac1Dk3I
The flow I have created in the video only works when it finds a file reference for the row. let me explain how it works:
1. It reads the contact table using the 'List rows present in a table' action.
2. Send the date into a loop.
3. Inside the loop, it searches for the filename for the contacts with the filename defined in the Excel file.
4. If it finds a filename, it sends the data to another loop.
5. Inside the second loop, it gets the content for that file.
6. Uses the email template created using the 'Send an email (V2)' action.
I have used expressions for the dynamic fields in the email body. The expression is pretty simple. Let me know in the comments if you have any questions.
When you need to send emails to a large group of contacts, you can set a 'Delay' action after the send email action. It is not necessary, but someone asked in the other video that they need it.
Check out this video for sending Mail merge emails on Outlook desktop: ua-cam.com/video/NikC2cJ_tHQ/v-deo.html
For mail merge in Gmail, check out this video: ua-cam.com/video/qjIAa1mJPiY/v-deo.html
Chapters:
0:00 Intro
0:55 Format the data into a table
1:24 Fix the date and currency formats
2:14 Create a new Power Automate flow
3:00 Read the data in the Excel file
3:47 Create a Apply to each action
4:22 Search for the file using the filename in the Excel file
5:10 Create the second Apply to each loop
5:29 Get the file content
5:55 Create the email template
6:22 Set up the dynamic email list and other dynamic fields.
8:42 Set the dynamic attachment for the emails
9:04 Set the dynamic CC addresses
9:34 Save the Power Automate flow
9:44 Run the flow
***In the video, I kept the contacts file in the same folder where I have the attachment files. Sometimes, the search can cause a mismatch. The best practice is to keep the contact data and the attachment files in separate folders.
Subscribe to the channel:
ua-cam.com/channels/QdbJgo3DZKkW8VK5HbjzrA.html
Follow and engage on social media:
Facebook: technologiate
Instagram: technologiate
#mailmerge #powerautomate #sendmails #attachments
Переглядів: 160

Відео

How to Convert Latitude and Longitude to Addresses | Reverse Geocoding | Lat-Long Conversion
Переглядів 284День тому
In this video, you will see how to convert latitudes and longitudes into addresses for bulk lat-long data. I made a Google Sheet Apps script which generates the address from the latitudes and longitudes. It connects with the LocationIQ to get the addresses. The free tier of LocationIQ offers 5000 requests per day. So, for most people, the free tier would be enough. However, you can subscribe to...
How to Convert Latitude Longitude to Decimals in Bulk | Lat Long to DMS (Degrees, Minutes & Seconds)
Переглядів 13614 днів тому
In this video, you will see how to convert latitude and longitude to decimals or DMS (Degrees, Minutes & Seconds) for bulk data. I have used a simple script in the Google Sheet to convert the lat long to DMS. You can copy the link into your Google account and convert the lat long data to DMS in bulk. The Google Sheet has two worksheets. In the first worksheet, you need to copy the latitude and ...
How to Enable DKIM for Microsoft 365 | Secure Email Reputation
Переглядів 16728 днів тому
In this video, I will show how to set up DKIM (Domain Keys Identified Mail) for Microsoft 365 account. DKIM proves the authenticity of the email sender. Without the DKIM, the receivers' email servers or the spam filters can detect that you are the real sender of the email. No bad guys can fake your email address to send emails on behalf of you using your email. Setting up the DKIM on Microsft36...
Automated Data Entry Online using Data from Excel | Auto Fill Forms using Chrome Extension
Переглядів 5 тис.Місяць тому
In this video, you will see how to auto-fill forms online using the data source in a Microsoft Excel file. I have used an extension for the Google Chrome browser; the extension works on the Microsoft Edge browser. The extension is free to use. Here is the link to download the extension: chromewebstore.google.com/detail/excellent-data-filler-cth/abafaagbfhobgjkcepckbnadafflkdea The process is ve...
Outlook Tasks Management | How to Manage Tasks Smoothly | Microsft 365
Переглядів 429Місяць тому
In this detailed video, I’ll explain everything you need to know about using Outlook tasks to stay organized and productive. We'll start with the basics: creating a task in Outlook. I'll show you step-by-step how to set up your tasks from the Outlook interface, whether you're on your desktop or using the mobile app. Learn to name your tasks, set start and due dates, and save them for easy acces...
How to Sign Up for Microsoft 365 Business Email with Your Custom Domain
Переглядів 3502 місяці тому
In this video, I'll guide you through the entire process of signing up for a Microsoft 365 Business account and connecting your custom domain. Whether you're a small business owner or managing multiple accounts, this tutorial will help you easily get started. For this tutorial, I chose the Microsoft 365 Business Basic plan because it includes essential applications like Word, Excel, PowerPoint,...
How to Download ALL Attachments in Outlook (All Emails)
Переглядів 1,8 тис.2 місяці тому
In this video, I'll guide you through the process of downloading all attachments from your Outlook emails into a folder. No more searching through emails to find the files you need! First, we enable the Developer options in Outlook. Open Outlook, go to the ‘File’ menu, select ‘Options,’ and then ‘Customize Ribbon.’ Check the ‘Developer’ option and click ‘OK.’ Next, visit ‘The Techie Guy’ websit...
How to Compare Two Word Documents Side by Side
Переглядів 2392 місяці тому
Microsoft Word has a built-in feature that allows users to compare Word documents. When you want to check the revisions made by someone else on an original document, use the Compare feature. It says where text has been replaced, added new words, deleted some text, etc. For that, select the' Compare' option under the 'Review' tab of Microsoft Word. Then, upload the original and revised versions ...
How to Create a Group in Outlook | Shared Files, Calendar, OneNote between Members
Переглядів 2472 місяці тому
In this video, I explain how to create Outlook Groups and how to manage and make the most of groups to keep your team connected. The Group option in Outlook is available for Microsoft 365 users. When you create a group, you can make the communication smoother for the members. It's like a shared place for all where you can send emails, share files, create a shared notebook, use the List, etc. It...
How to Create a Distribution List in Outlook | Microsoft Outlook Contact Group
Переглядів 6 тис.3 місяці тому
Outlook Distribution List is a useful feature for sending the same email to a group of people. In the Outlook application, the Distribution list is named 'Contact Group.' The name suggests that it is a group of contacts. When you have different teams in your company, like a Sales or Marketing Team, you can create lists for each team. When you need to send an email, type the name of the list ins...
How to Send HTML Email in Gmail | HTML Email Templates
Переглядів 1,1 тис.3 місяці тому
In this video, I have explained how to send HTML emails in Gmail. By default, Gmail doesn't support HTML codes in the compose window. But I have a workaround and two easy tips. METHOD: 1 First, you need to create the HTML code you want to send via Gmail. For the fonts, you can use only the available fonts in Gmail; no other web font is supported. If you want to add images in the HTML email body...
How to Send Automated Birthday Emails with Google Sheet Data (The Easy Way!)
Переглядів 5944 місяці тому
Learn how to send automatic birthday emails in just a few simple steps with our automated birthday email guide. I used Google Sheets as the contacts database and Lido to send the automated emails. After connecting Google Sheets with Lido, I configured the email template. You can add a photo to the email and add CC and BCC as well. Before setting up the automated email, I used a formula to check...
How to Disable or Enable Two-Factor Authentication in Office 365 | Microsoft 365
Переглядів 7 тис.4 місяці тому
This video covers all the steps for enabling, disabling, or enforcing Two-Factor Authentication (2FA) / Multi-Factor Authentication (MFA) for individual users or your entire organization on Microsoft 365. 2FA is an essential security feature that adds an extra layer of protection to your account, but sometimes, you may need to disable it. To enable or disable 2FA, follow the steps: 1. Log in to...
How to Map Your Custom Route with Google Maps | 3 Route Planning Methods
Переглядів 3,2 тис.4 місяці тому
How to Map Your Custom Route with Google Maps | 3 Route Planning Methods
How to Send Encrypted Emails in Gmail | Send Secure Emails with Gmail Confidential Mode
Переглядів 2,2 тис.5 місяців тому
How to Send Encrypted Emails in Gmail | Send Secure Emails with Gmail Confidential Mode
Create a Custom Google Map with Pins from Excel Address List | Drop Multiple Pins on Google Maps
Переглядів 4,5 тис.5 місяців тому
Create a Custom Google Map with Pins from Excel Address List | Drop Multiple Pins on Google Maps
Microsoft Excel Essential Skills for Beginners | Excel Tutorial | Basic Functions
Переглядів 3026 місяців тому
Microsoft Excel Essential Skills for Beginners | Excel Tutorial | Basic Functions
How to Mail Merge on Outlook Web App with CC, BCC & Attachment |Send Email from Excel PowerAutomate
Переглядів 6 тис.6 місяців тому
How to Mail Merge on Outlook Web App with CC, BCC & Attachment |Send Email from Excel PowerAutomate
How to Create Google Calendar Appointment Scheduling Page
Переглядів 2,8 тис.6 місяців тому
How to Create Google Calendar Appointment Scheduling Page
How to Setup Google Workspace Account | Verify Domain, Add MX Records
Переглядів 4146 місяців тому
How to Setup Google Workspace Account | Verify Domain, Add MX Records
How to set up Webmail on Outlook with Company Email Configuration
Переглядів 2,9 тис.7 місяців тому
How to set up Webmail on Outlook with Company Email Configuration
How to Create Multiple Pins on Google Maps | Pin Multiple Locations on Google Maps
Переглядів 11 тис.7 місяців тому
How to Create Multiple Pins on Google Maps | Pin Multiple Locations on Google Maps
Enable Email Read Receipt in Outlook | How to Track Emails in Outlook
Переглядів 2,4 тис.7 місяців тому
Enable Email Read Receipt in Outlook | How to Track Emails in Outlook
How to Convert Addresses to Lat Long (BULK) | Latitude & Longitude from Address
Переглядів 4,6 тис.7 місяців тому
How to Convert Addresses to Lat Long (BULK) | Latitude & Longitude from Address
How to Mail Merge in Gmail | Send Bulk Emails on Google Sheets
Переглядів 6 тис.7 місяців тому
How to Mail Merge in Gmail | Send Bulk Emails on Google Sheets
How to Sync the Outlook Signature Across Devices | Company-wide Email Signature
Переглядів 1,7 тис.8 місяців тому
How to Sync the Outlook Signature Across Devices | Company-wide Email Signature
How to Synchronize Android Keyboard Dictionary to Cloud
Переглядів 3108 місяців тому
How to Synchronize Android Keyboard Dictionary to Cloud
Google Sheets: Import Data from Another Google Sheet | Import Data from Different Sheet Account
Переглядів 3719 місяців тому
Google Sheets: Import Data from Another Google Sheet | Import Data from Different Sheet Account
How to Sync Your Outlook Email Signature Across Desktop, Mobile, and Web | Outlook Mobile Signature
Переглядів 11 тис.9 місяців тому
How to Sync Your Outlook Email Signature Across Desktop, Mobile, and Web | Outlook Mobile Signature

КОМЕНТАРІ

  • @JuliePerkins-m3k
    @JuliePerkins-m3k 21 годину тому

    I need to find maria Perkins Helena manico

  • @KDCreates_
    @KDCreates_ День тому

    but you have to pay for this extension after creating calendar how many events can you dO A DAY?

  • @Gandaki_News
    @Gandaki_News День тому

    does it works in private network ?

  • @RafiqulIslam-vd1ie
    @RafiqulIslam-vd1ie 2 дні тому

    I am trying. But did not work properly. Always shows "Roll number exists. Data has been brought to input fields."?

  • @StupendousGroup
    @StupendousGroup 2 дні тому

    What if i don't have the Excel subscription? i have only outlook basic plan

    • @technologiate
      @technologiate 2 дні тому

      It works with the free version of Outlook as well. Make sure you do not select the Office 365 actions in the Power Automate flow. Excel online is free.

  • @technologiate
    @technologiate 2 дні тому

    *Send Emails with Separate Attachments using Power Automate:* ua-cam.com/video/WcNqe3hRZxk/v-deo.html

  • @technologiate
    @technologiate 2 дні тому

    *Mail Merge without attachments using Power Automate:* ua-cam.com/video/ItrVEQCwKW0/v-deo.html

  • @PremChauhanlegalpoint
    @PremChauhanlegalpoint 4 дні тому

    Nice

  • @SianDoherty
    @SianDoherty 4 дні тому

    PSA: Be careful when blindly copying chatgpt code or any LLM AI code. It's much better to try and understand first what you are copying. Ask for a detailed explanation in your prompt so you can learn at the same time.

  • @StupendousGroup
    @StupendousGroup 5 днів тому

    How can we set the limitation, Ex: i have the list of 1000 emails considering sending limitations how can we set how many emails to be sent in 1 second/minute/hour

    • @technologiate
      @technologiate 4 дні тому

      Hi, You can set a 'Delay' action after the 'Send an email (V2) action. See the screenshot: i.imgur.com/xbOsArC.png

    • @StupendousGroup
      @StupendousGroup 2 дні тому

      @@technologiate How can we enable delivery note and read receipt?

  • @sxchinnnn
    @sxchinnnn 5 днів тому

    Will it work for a website and if it works does it show to the owner that data has been entered automatically

  • @ednadrew6125
    @ednadrew6125 5 днів тому

    Thank you for producing this tutorial. Very helpful. Discovered you today

    • @technologiate
      @technologiate 5 днів тому

      Thank you so much! I'm glad you found the tutorial helpful. Welcome to my channel, and I hope you enjoy my future content!

  • @Archai.
    @Archai. 5 днів тому

    the email which we write in the mail body, after sending email all the data i typed are becoming one paragraph sapces are no there after sending the emails

    • @technologiate
      @technologiate 5 днів тому

      Did you copy the text from another document into the body of the email?

  • @NicolaDambrosio-h9p
    @NicolaDambrosio-h9p 5 днів тому

    Hello I have the "empty_window_error" when I try to select the xls file to connect. How can I solve this issue ?

  • @football1mondial712
    @football1mondial712 6 днів тому

    Thank you very much I got this problem being resolved

  • @thebusinessanalystt
    @thebusinessanalystt 6 днів тому

    batter you create a google form so that any one can use from mobile as well

  • @romeowhiskey1146
    @romeowhiskey1146 7 днів тому

    Creating an AppScript just got SO EASY. What you NOW need to MASTER is clearly communicating WHAT YOU WANT to ChatGPT. The HARD part of writing the code...is a thing of the past. AI saves the day.

  • @azaharali281
    @azaharali281 7 днів тому

    sir no need this option(please ensure all input fields have data) how to remove?

  • @coloradoman11
    @coloradoman11 7 днів тому

    Can I save a measured distance and its path? And how do I change from measurement in miles to measurement in feet and inches?

    • @technologiate
      @technologiate 7 днів тому

      Please check this video: ua-cam.com/video/Ervlur1MqG4/v-deo.htmlsi=yvbcNeaQZ2pChvl9

  • @ariesdelrosario5076
    @ariesdelrosario5076 7 днів тому

    Great but if you wanted to cc your manager or your boss to the email how?

    • @technologiate
      @technologiate 7 днів тому

      Hi, You can watch this video for mail merge with CC, BCC, and Attachments using a third-party tool: ua-cam.com/video/pNDdKHuBYw8/v-deo.html Watch this video to mail merge with all the options using Power Automate: ua-cam.com/video/ItrVEQCwKW0/v-deo.html Thanks

  • @AG-Investment
    @AG-Investment 8 днів тому

    I have the Roll number in cell D5, Name on D7, Grade on D9, Gender on D11, Date of admission on D13, and Remarks on D15 on the' Input' sheet. I have the same columns on another sheet named 'Data' with the headers. I want a function that will enter these inputs into the next available row; when I click the button, I will assign the function to a button. Before sending the input, ensure all the mentioned cells have data. When the input has been entered, show a pop that says 'New data entered.' Additionally, the Input sheet has one more cell 'F3', where I have mentioned the operator name; this operator name should be entered after the Remarks column on the 'Data' sheet. After the Operator's name, there is one more column for the Date of entry; when the data is being entered the Date of entry column should record the present date. Make sure to check for the roll number does not exist on the Data sheet; if the roll number is already on the 'Data' sheet, it will show 'Roll number exists.' and it should bring all the data (Roll, Name, Gender, Date of admission, Remarks ) to the input fields accordingly.

  • @AG-Investment
    @AG-Investment 8 днів тому

    pls share above script

    • @technologiate
      @technologiate 8 днів тому

      Hi, You can copy the Google Sheet with the script; the link is in the video description. Thanks

  • @limitededition7924
    @limitededition7924 10 днів тому

    This is not working on Flipkart website 😢

    • @technologiate
      @technologiate 9 днів тому

      Hi, what are you trying to achieve on the Flipkart website?

    • @limitededition7924
      @limitededition7924 9 днів тому

      @@technologiate I am doing product listing

  • @hendkadry1995
    @hendkadry1995 10 днів тому

    I want to send 500 PDF files to 500 mail addresses, but each file is dedicated to an address and the file must be sent only to its owner and I have the list of addresses in Excel sheet arranged digitally and I have PDF files in a folder arranged digitally as well, please can this task be accomplished in this way knowing that I do not want to send any other details except a pdf files

    • @technologiate
      @technologiate 10 днів тому

      Hi, Please watch this video: ua-cam.com/video/pNDdKHuBYw8/v-deo.htmlsi=iAgcOxBqxC93aQw3 It lets you attach a single file for all the recipients; also, you can attach individual attachments for each of the recipients. Thanks.

    • @technologiate
      @technologiate 2 дні тому

      You can use Power Automate to send emails with Separate Attachments: ua-cam.com/video/WcNqe3hRZxk/v-deo.html

  • @alamsetiadi88
    @alamsetiadi88 10 днів тому

    why my merge to email not working? nothing email in outbox or sent item

  • @sripal.jain4
    @sripal.jain4 11 днів тому

    It is a very good video about create and use My Maps Pls tell me - How to navigate with My Maps

  • @mubashiriqbal3315
    @mubashiriqbal3315 12 днів тому

    How to add this signature in Gmail?

  • @shadow_night_097
    @shadow_night_097 12 днів тому

    Fake

  • @mindastiles1230
    @mindastiles1230 13 днів тому

    You might mention that you can't do an email merge if there is more than one email address in a field (even if separated by semicolons). I just tried. Apparently this has been a issue for 15 years or so, and MS never fixed it. What a mess. I just tried sending to 200 people -- many with two email addresses -- and now I have about half that didn't get sent, and I have to figure out a workaround.

    • @technologiate
      @technologiate 12 днів тому

      Thank you for your feedback! You’re right; Outlook Mail Merge does have limitations when it comes to handling multiple email addresses in a single field. A simple workaround is to create a separate row for each email address while keeping the other columns' data the same for those contacts who have two email addresses. This way, each email address gets processed individually, ensuring that all your recipients receive the email. I hope this helps, and thanks again for highlighting this issue!

  • @ANDRESBETANCURE1
    @ANDRESBETANCURE1 13 днів тому

    wow. great video. It helps me a lot!! Thank you!

  • @technologiate
    @technologiate 13 днів тому

    *Convert Addresses to Latitudes and Longitudes:* ua-cam.com/video/71k-sa1_dJI/v-deo.html

  • @technologiate
    @technologiate 13 днів тому

    *Convert Latitude and Longitude to Addresses (Reverse Geocoding):* ua-cam.com/video/wF0D0gKqeE8/v-deo.html

  • @skalim6081
    @skalim6081 13 днів тому

    "You do not have permissions to open this file in the browser." i am facing this issue while selecting the file while Adding the "importer" . Please help me get this clear

  • @JDen4
    @JDen4 14 днів тому

    Can i hyperlink google sheet to excel cell by cell not a table?

    • @technologiate
      @technologiate 14 днів тому

      When you import the Google Sheet data, it is imported as a table in the Excel file. Later, you can remove the table formatting, but I am not sure if the connection will still work. You can try it and let me know how it goes. Thanks.

  • @boopalanak8487
    @boopalanak8487 14 днів тому

    Thank you sir for you explanation to do this work I am really thankful to you to do my project in time

  • @rameesbakker8907
    @rameesbakker8907 15 днів тому

    can we add html image as a body?

    • @technologiate
      @technologiate 15 днів тому

      Hi, It doesn't support inserting custom HTML.

  • @WorkMail-bn9sm
    @WorkMail-bn9sm 15 днів тому

    Noy working

  • @informantunggal9749
    @informantunggal9749 16 днів тому

    Brother. Can we use google drive instead of one drive?

  • @Thapelot7
    @Thapelot7 16 днів тому

    Hi, it gives me an error that " could not invoke program" it further says %1 is not valid Win32 application (193) Any solution for the above error?

  • @murwa1012
    @murwa1012 16 днів тому

    AM USING WORK PC ,MY Roaming\Microsoft\Outlook PATH ONLY HAS 2 FILES AND ZERO FOLDERS

    • @technologiate
      @technologiate 16 днів тому

      Hi, do you see the file with the name of the signature you created on the Outlook application? You need to edit that file. Doesn't matter if there are folders or not. Thanks.

  • @owais.ahmed99
    @owais.ahmed99 17 днів тому

    Dear, links are not working mentioned in the description. I am trying this docs.google.com/spreadsheets/... but it's not working.

  • @azzanmuhtasumahmed7097
    @azzanmuhtasumahmed7097 17 днів тому

    it really helped thank you

  • @user-cf6wf6kn3v
    @user-cf6wf6kn3v 18 днів тому

    thanks so much this is amazing !

  • @SANTO-xg5ux
    @SANTO-xg5ux 18 днів тому

    I've been searching for so many videos. This one was extremely easy. Amazing!

  • @BrettHidgcock
    @BrettHidgcock 18 днів тому

    its a great video thank, but right at the end you skipped over where you got that whatsapp link from to create that final link. do we need to copy paste something from whatsapp? or can we simply write the same code as you do? thanks

    • @technologiate
      @technologiate 18 днів тому

      You do not need to copy anything from WhatsApp. You can copy the template in the video description to see what I have written in the cell.

    • @BrettHidgcock
      @BrettHidgcock 18 днів тому

      @@technologiate thanks for your help the link seems fine it’s just coming up with an error on the column I choose it’s highlighted in red, just trying to work out now why that might be? It’s the exact same template as yours just different column numbers

  • @BrettHidgcock
    @BrettHidgcock 18 днів тому

    i also want to add a link with my text link yours, how can i upload a clickable link without it linking to the whole text thanks. when i copy and past the link it isnt bluse and clickable like your’s its just normal text

    • @technologiate
      @technologiate 18 днів тому

      If the person does not have your contact saved, the link will not be blue and clickable.

    • @BrettHidgcock
      @BrettHidgcock 18 днів тому

      @@technologiate is there away to do this as the text is designed to send them to join a group page? Thanks

    • @BrettHidgcock
      @BrettHidgcock 18 днів тому

      @@technologiate it only allows me to turn the whole column of text into one big clickable link it seems

  • @Cloud0422
    @Cloud0422 18 днів тому

    how to schedule sending email? i want to send email by day and time?

  • @supportleevents162
    @supportleevents162 18 днів тому

    ONly recipent working in mail other thing i add but not working

  • @supportleevents162
    @supportleevents162 18 днів тому

    Not Working

  • @brcleaningcompany2566
    @brcleaningcompany2566 19 днів тому

    How do i add attachments

    • @technologiate
      @technologiate 18 днів тому

      Hi, You need to attach the file to the draft.