Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-16-2013, 12:40 AM
Nibbles Nibbles is offline Collation of mail merge data Windows 7 64bit Collation of mail merge data Office 2010 64bit
Novice
Collation of mail merge data
 
Join Date: Nov 2012
Posts: 9
Nibbles is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 04-16-2013, 03:14 AM
OTPM OTPM is offline Collation of mail merge data Windows 7 32bit Collation of mail merge data Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

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
Reply With Quote
  #3  
Old 04-16-2013, 07:59 AM
Nibbles Nibbles is offline Collation of mail merge data Windows 7 64bit Collation of mail merge data Office 2010 64bit
Novice
Collation of mail merge data
 
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
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Collation of mail merge data Mail Merge / DSN / Data Link / MySQL Bob Young Mail Merge 5 05-18-2012 03:44 PM
Collation of mail merge data 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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:49 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft