I have an excel file full of customer data. I am having trouble finding a way to mail merge the information like my company wants to. They currently do it by identifying the company name and if the next row has the same name they append next to the first row where the company name showed up and naming it address_2, City_2, State_2 and so on.

After that they pull the information into word with mail merge (after the data sources are identified in their specific areas) to print them all out.

Is there any way that i could build a loop or array to append the data in the excel file? Some of the rows have 2600+ of the same company name, that has to appended next to the first one.
Also is there any there any help that i could get in setting the datasources in WORD? I am SUFFERING here. Please HELP!