Mailmerging using a text file

[Simple]

Hi..I was going to try and import the following into Excel but is this
easier from Word? I also have this posted in the Excel newsgroup so excuse
the crosss posting...
Is it possible to import a text file into Excel? I have a text file with
thousands of company names and address on (all formatted as below) that I
would like to import into Excel...problem is that I want to import them into
rows with each address detail falling under the correct column heading i.e.
Column for Company name, column for Address1 column for address 2 etc.

Company Name
Address
Address2
City
Postal Code

Company Name
Address
Address2
City
Postal Code
etc etc

Ultimately I need to use these address's to mail merge, otherwise if
somebody has a better suggestion for using a text file to mail merge with MS
Word I'm more than happy to listen.
Thanks
Si

 

[Allan]

are you printing envelopes or merging with another
document?

 

[Graham Mayor]

At some point your document will resemble one of the stages at
http://www.gmayor.com/convert_labels_into_mail_merge.htm. The end result
will be a table that you can import into Excel if you wish (though Excel
will read a comma delimited file and translate this into columns). To get
that table to produce a layout with the addresses in the format

Company Name
Address
Address2
City
Postal Code

You need to do use the data file to create a catalog/directory merge to a
new document.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>