Hi, all this is my first time posting. I regularly use the mail merge function to make labels, but the problem that I'm having is each label corresponds to one excel file, and sometimes I have to go through many files at a time. I'm trying to see if there is a way to have a macro look into a folder and make a pdf of each excel file in said folder. Just need it to open the file make the pdf of it and then move on to the next file in the folder. If anyone has some insight into this it would be much appreciated! Thank you!