Rum*

Morning all....

Technophobe Rum* here...

I have some data that has been passed to me in Excel....now I need to get this transferred to word so that we can fully understand it...

Basically its all client info (names, addresses, DOB's, car details etc etc etc)...and I need to get it into a format that I can use easily...i.e. Word...

Can anyone help???

If so please can you give me a shout to discuss - 0113 202 1227

Cheers

Tom

chiark

Tom - yes.

Diablo

Tom,

Either cut and paste into a work document, or set up fields on a word document and merge the info from the spreadsheet

Personally, I'd just manipulate it in Excel as its more user friendly for data.

Second option is to get a good WP operator on your staff and ask them to do it

D

mattstant

agree with diablo you can improve the clarity just by dragging the columns about .
exporting to word as data is fraught with pitfalls and you'll spend much longer trying to put things right get it looking ok then cut and paste to word if you have to

MattN

do a mail merge - there's a wizard to take you through it step by step. It's quite easy.

You need to start in word tho!

If the data isn't to sensitive email it to me and I'll sort it for you.

Cheers,

Matt

chiark

The data was in eight separate CSVs with cross references. Pulled into Access and done from there. Access really is damn good nowadays.

MattN

couple of lookups and you's have been sorted.

8 CSV's - fun.

chiark

True, yep, forgot about excel's lookup stuff. D'oh. Still, it's easier to get nice pretty reports out of access. Far too often overlooked part of the office suite IMHO.

I wrote something using Access 2 in 1996 that is *still* being used in production. I moved away from that part of the company shortly after and have just moved back into working with them, and the fappin' thing is still being used in anger daily... Like all good "legacy" systems, no-one dares touch it.