Having complete control of your papers at any moment is crucial to relieve your daily tasks and enhance your efficiency. Accomplish any objective with DocHub features for document management and practical PDF editing. Access, adjust and save and integrate your workflows along with other secure cloud storage.
DocHub provides you with lossless editing, the chance to use any format, and safely eSign documents without searching for a third-party eSignature option. Obtain the most of your file management solutions in one place. Consider all DocHub functions right now with your free of charge account.
In todays tutorial, Ill show you how you can do a mail merge with attachments. So, were going to be sending personalized emails to multiple people with their own attachments, and were going to do this from Excel. Were not going to be using any VBA or macros or any external add-ins. Guess what were using? Did you guess it? Power Automate. Okay, so let me take you through what were going to be doing here. I have an Excel file called FilesMaster. In this file, I have a table with each persons first name, last name, email, and the file name that I want to send them. So, in this case, its just the name, not the address of the file. Now notice each person needs to get their own customized PDF document. These PDFs happen to be in the same folder where I have my Excel file, but they dont have to be. They can be on SharePoint. They can be in another folder on your OneDrive. So notice all of these, in my case, are saved in my OneDrive for Business for n