Thread: [Solved] Collation of mail merge data
View Single Post
 
Old 04-16-2013, 07:59 AM
Nibbles Nibbles is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Nov 2012
Posts: 9
Nibbles is on a distinguished road
Default

Doesnt necessarily have to be to word, excel could do it i guess.

The problem is that at the moment it it on the form;

company1, material1, price1, material2, price2
company2, material1, price1
company3, material1, price1, material2, price2, material3, price3
etc
etc

I could print that out but that'll quickly go horizontally off the page, even in landscape, so the easiest way to list it would be;

Company1, Material1, Price1
Company1, Material2, Price2
Company2, Material1, Price1
Company3, Material1, Price1
Company3, Material2, Price2
Company3, Material2, Price3

which could then go in to 2 columns and be printed on the minimum of paper (the last one was 16 pages. I want it for quick reference of monthly prices when out of the office, rather than having to hunt through an excel document on my phone.

I could manually link everything in excel but that leaves another problem, every month a load more get added and sorted into alphabetical order, but linking them fixes the cells so i would have to redo it every time.

I assumed there could be a way to set it all up using a csv file?
Reply With Quote