#1
|
|||
|
|||
Collation of mail merge data
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 |
#2
|
|||
|
|||
Hi Steve
Not sure why you would want to move the price data from Excel to Word. How will you then update the price data as it changes? If you want to move the price data to a Word table you could just copy and paste. Unless I am missing the point of your query. Tony |
#3
|
|||
|
|||
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? |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail Merge / DSN / Data Link / MySQL | Bob Young | Mail Merge | 5 | 05-18-2012 03:44 PM |
Mail Merge - If a field is black, take the data from the row below? | mikeprent | Mail Merge | 5 | 01-05-2012 04:52 AM |
Mail Merge data source on network drive | Brandi | Mail Merge | 0 | 06-13-2010 11:26 AM |
How do I set up the fields in mail merge word 07 from my data base | mbcrabber | Mail Merge | 4 | 06-06-2010 01:25 PM |
Need help creating a data base for mail merge. | acedking90 | Mail Merge | 0 | 07-27-2009 11:04 AM |