Hi,

I have a query about how to collate data from all my mail merge emails. Situation is thus;

.csv file generated with company name, address, material1, material1price, material2, material2price etc. Some have one or two materials, some have up to 15. Prices are linked back to a prices.xlsx worksheet where they are changed based on market price rises/falls.

This is then used to generate a mail merge in word that sends all of the monthly quote emails.

I want a simple way to separately move all of the price data into a word document, or similar. This would be in a 3 column table with the headings; Company, Material, Price.

So for example, my list may read;

Company 1, Material 1, Material 1 Price
Company 1, Material 2, Material 2 Price
Company 1, Material 3, Material 3 Price
Company 2, Material 1, Material 1 Price
Company 3, Material 1, Material 1 Price
Company 3, Material 2, Material 2 Price

and so on for the 500 odd companies that we email.

I could get this from the price.xlsx file though everything ive thought to try so far is hugely time consuming or simply doesnt work.

I guess it could be imported in to Access somehow, which may be a possibility?

Thanks in advance,
Steve