Mail Merge Question

[exalex]

Hello,

I am doing an "advanced" mail merge which I am sending out letters to companies that own parcels of land across the entire state. I have 500 line items for some 80 companies. The excel is as follows:

	A	B	C
1​	Company Name	Usage	Address
2​	Johns	Rec	432 Cooling
3​	Bens	Hos	342 Runner
4​	Chris	Sch	948 hiking
5​	Johns	Bas	320 Brook
6​	Johns	Tee	3855 Abbey
7​	Bens	When	4209 Mac

The output I want on the mailmerge is 80 documents (80 companies) that shows each of their Usage/Address, example, i want Johns to show the below:

Johns	Rec	432 Cooling
Johns	Bas	320 Brook
Johns	Tee	3855 Abbey

Chris':

Chris

Sch

948 hiking

Bens:

Bens	Hos	342 Runner
Bens	When	4209 Mac

Is there an easy/clean way to do this?

 

[ekrause]

This might be overly simplistic for what you are looking for, but is there any reason a simple sort (in the Data ribbon) couldn't accomplish the task?

It will give you everything in alphabetical order as you have outlined, then you can either copy it manually or I can help with some code to copy and paste after that but I would need more info on how your mail merge is working.