I have a customer database for a business which I would like to use for a mail merge.
I have managed to write a macro script which will do a mail merge for every single customer in the database, when a button is clicked on the excel document. I am wanting to set the script so that when the button is clicked, I can choose a single row so that the info on that single row is merged, ignoring all others. I don't mind how this is done, whether it be with a dialog box or by selecting the row and then clicking the merge button (or any other way possible).
Below is the script i currently have for the full mail merge:
What do I need to add to the script to allow me to single out rows for the merge, so that I don't get hundreds of merged letters every time I click the button?
Bookmarks