I am trying to figure out how to create a macro that can create address labels from a spreadsheet. I have to create address labels for postcards from excel lists. The list changes but the fields and field names, ie "First name, Last name, Address 1, Address 2..." stay the same. I currently have to go through the whole mail merge process for each last. Is there a way to create a macro that will allow me to either:

1) open the spreadsheet and automatically trigger a macro in microsoft word to create mailing labels from that open spreadsheet

2) run a macro that opens a dialog box to select the spreadsheet as a data source and automatically create address labels from that file?

Any help would be appreciated.

Thank you,

Justin