Mailmerging using a text file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Simple - 21 Jul 2004 20:14 GMT

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

Reply to this Message

Allan - 21 Jul 2004 21:30 GMT

are you printing envelopes or merging with another
document?

>-----Original Message-----
>Hi..I was going to try and import the following into Excel but is this
[quoted text clipped - 26 lines]
>
>.

Reply to this Message

Graham Mayor - 22 Jul 2004 05:51 GMT

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.

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> 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
[quoted text clipped - 24 lines]
> Thanks
> Si

Reply to this Message