Mail merging Data from Excel to Word

%3CLINGO-SUB%20id%3D%22lingo-sub-3201744%22%20slang%3D%22en-US%22%3EMail%20merging%20Data%20from%20Excel%20to%20Word%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3201744%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20so%20close%20to%20figuring%20this%20out%20but%20I%20don't%20know%20what%20the%20right%20%22rule%22%20to%20imply%20here%20to%20get%20what%20I%20want%20so%20hopefully%20someone%20can%20help%20me%20because%20I%20am%20running%20out%20of%20time.%20I%20have%20an%20online%20form%20that%20holds%20registrations%20that%20include%20data%20that%20I%20want%20to%20merge%20into%20a%20word%20document%20for%20easier%20data%20sorting.%20BUT%2C%20one%20person%20can%20have%201-4%20lines%20of%20data%20so%20I%20need%20it%20to%20merge%20into%20word%20with%20the%20field%20names%20that%20are%20the%20first%20row%20of%20info%20and%20then%20merge%20the%20next%20rows%20of%20data%20without%20the%20name%2C%20phone%20number%20and%20mailing%20address...I%20only%20want%20the%20data%20each%20person%20lists%20and%20then%20all%20the%20data%20per%20person%20merged%20together%20and%20then%20move%20on%20to%20the%20next%20person%20and%20their%20info%3F%20I%20hope%20I%20am%20making%20sense%3F%20I%20have%20uploaded%20some%20photos%20of%20record%20sample%201%20and%20sample%202...it%20is%20the%20same%20person%20but%20each%20record%20comes%20out%20separate%20including%20the%20same%20name%2C%20phone%2C%20and%20address%20but%20really%20I%20want%20it%20to%20come%20out%20under%20the%20one%20pet%20owner%20name%20and%20all%20pet%20info%20below%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Mail%20Merge%20Sample%201.png%22%20style%3D%22width%3A%20794px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F350530iB454F92F42E58F0E%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Mail%20Merge%20Sample%201.png%22%20alt%3D%22Mail%20Merge%20Sample%201.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Mail%20Merge%20Sample%202.png%22%20style%3D%22width%3A%20873px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F350531iC5C3EAA2148DBF44%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Mail%20Merge%20Sample%202.png%22%20alt%3D%22Mail%20Merge%20Sample%202.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3201744%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I am so close to figuring this out but I don't know what the right "rule" to imply here to get what I want so hopefully someone can help me because I am running out of time. I have an online form that holds registrations that include data that I want to merge into a word document for easier data sorting. BUT, one person can have 1-4 lines of data so I need it to merge into word with the field names that are the first row of info and then merge the next rows of data without the name, phone number and mailing address...I only want the data each person lists and then all the data per person merged together and then move on to the next person and their info? I hope I am making sense? I have uploaded some photos of record sample 1 and sample 2...it is the same person but each record comes out separate including the same name, phone, and address but really I want it to come out under the one pet owner name and all pet info below

 

Mail Merge Sample 1.pngMail Merge Sample 2.png

0 Replies