I do not think this should be difficult but I can not figure it out... I have my excel sheet completed.
I want to do two separate things - ( 1 ) merge data from my spreadsheet to a word doc utilizing labels.
( 2 ) merge data from my spreadsheet to a word document utilizing a word two column table. Mostly I can get the labels set up and the table (separate documents). I get the fields inserted but not always correctly.
I guess my real questions are: do I need to insert the "address" field - I think not as it sometimes causes me to have duplicate information that I have to edit. Additionally, my real issue is that I can not figure out or find a solution to - how do I get my excel data to populate my word docs? I either get a single field populated and can scroll through one at a time or I get a word doc populated with multiple label or table boxes populated with the same excel data. Desired out comes: populate a word doc w/labels having a different set of data in each label and separately - have an excel spreadsheet populate a word doc utilizing a table format (two columns) with a different set of data in each table box.
My spreadsheet has 75 lines of different data, 10 columns. Same data used for both word doc merges.
Not trying to combine these things into a single merge or anything like that. Two completely separate merges. Any help, suggestions greatly appreciated. Very novice at excel. Have attempted to research solution on my own prior to posting. My brain works best utilizing a simple 1, 2, 3, format. Thank you.
I want to do two separate things - ( 1 ) merge data from my spreadsheet to a word doc utilizing labels.
( 2 ) merge data from my spreadsheet to a word document utilizing a word two column table. Mostly I can get the labels set up and the table (separate documents). I get the fields inserted but not always correctly.
I guess my real questions are: do I need to insert the "address" field - I think not as it sometimes causes me to have duplicate information that I have to edit. Additionally, my real issue is that I can not figure out or find a solution to - how do I get my excel data to populate my word docs? I either get a single field populated and can scroll through one at a time or I get a word doc populated with multiple label or table boxes populated with the same excel data. Desired out comes: populate a word doc w/labels having a different set of data in each label and separately - have an excel spreadsheet populate a word doc utilizing a table format (two columns) with a different set of data in each table box.
My spreadsheet has 75 lines of different data, 10 columns. Same data used for both word doc merges.
Not trying to combine these things into a single merge or anything like that. Two completely separate merges. Any help, suggestions greatly appreciated. Very novice at excel. Have attempted to research solution on my own prior to posting. My brain works best utilizing a simple 1, 2, 3, format. Thank you.