Newbie question....

[Steven O.]

Hi, I'm fairly new to Excel, hope someone can help me out.

I just purchased a technology directory for my local region, which was
provided in the form of an Excel spreadsheet. Figured out for myself
how to sort the directory by cities. The next step is to get the data
into MS Word.

1. At a minimum, I want each adjacent cell of each record on a
separate line, so I wind up with something like:

Company A
Address Line1 A
Address Line2 A
City A
State A
etc...

Company B
Address Line1 B
Address Line2 B
City B
State B
etc...

where A and B do not refer to the A and B columns in the spreadsheet,
but rather to companies. Each of the items on a separate line above
is currently in a separate column in the spreadsheet, and companies A,
B, C, etc are in separate rows.

2. Ideally, I'd like to print it to MS Word as a formatted document:

Company A
Address Line1 A, Address Line2 A
City A, State A Zip A
Phone A,
etc...

If someone can tell me how to do this, or even give some general
hints, that would be a big help. I know how to program computers, but
I'm hoping that this is not going to involved writing some fancy VB
code or something. Does Excel have some kind of Visual Report
Generator or something similar I can use to do this?

Thanks in advance for all replies.

Steve O.

Standard Antiflame Disclaimer: Please don't flame me. I may actually *be* an idiot, but even idiots have feelings.

 

[Debra Dalgleish]

You can use the Mail Merge feature in Word to print the data, using
Excel as the data source. There's lots of information on the Word MVP site:

http://www.mvps.org/word/FAQs/MailMerge/CreateAMailMerge.htm

And David McRitchie has instructions on his web site:

http://www.mvps.org/dmcritchie/excel/mailmerg.htm