I have a workbook that I am separating the data from the first sheet based on job number and creating multiple sheet with the job number as the sheet name. I want to run mail merge on these sheets. My first thought was to save them each as a workbook in a folder and run mail merge on each workbook. Since these are based on the job number the name will always be different.
Any suggestions on how to do a mail merge with either one workbook with multiple sheets, or multiple workbooks?
Any suggestions on how to do a mail merge with either one workbook with multiple sheets, or multiple workbooks?