Do you know how I can set up a macro using visual basic that will allow me to save a word merge into seperate word files and use one of the merged fields as the name of the saved file?
Our company outsources a chemical company hotline to provide customers with 24 hour information on our products. This company requires a seperate Material Safety Data Sheet with all of the product specs pertaining to the product stored in a seperate word documint. Our lab has an excel file with all of the data and we have set up a merge with word to bring the data into the correct places on the MSDA form but we can't figure out how to save each individual record of the merge without highlighting each one manually and then saving it. There just has to be a better way.
Please Help.