Reverse Mail Merge? Word to Excel? Is there a Way?

[SSJpn]

I have a word document that was sent to me via email. The document is in a label format (3 columns and a number of rows) and is filled with addresses. I would like to put these addresses into Excel. Is there a 'reverse' mail merge that will take the addresses from the Word document and properly output them into Excel?

When i say properly output to Excel I mean put the 'Address Name' in the 'Name' column of Excel, put the address in the address column of Excel, city to city column, zip to zip column, etc.

Kevin

 

[SF0751]

If you copy the table info from the Word doc, and paste in to the Excel spread sheet, will that give you what you need? Or will you need to manipulate the data further?
Susan
Under certain circumstances, profanity provides a relief denied even to prayer. - Mark Twain

 

[SSJpn]

Each cell in the Word document contains an address such as:

Mr X
11111 blah street
blah, VA XXXXX

I belive there are 30 cells per page and there are numerous pages in this Word document. I have the Excel setup so Column A contains recipient names, B contains street address, C contains city, etc etc.

I basically want a reverse mail merge so that each piece of information (name, addres, city, zip, etc)from each cell in the word document is put into its respective column in the excel spreadsheet.

I really need a 'reverse' mailmerge procedure.

Kevin.

 

[cheerio]

First, this is a task that could only be tackled by VBA.

Assuming the data is in the form of a Word table, it's not too difficult to write code that would visit each cell in the table and grab the contents.

The difficulty in coding, is recognising which column each row of an address belongs in. For example, consider:

Mr X
11111 blah street
blah, VA XXXXX

Mr Y
PQR Inc
22222 blah blah street
new blah, VA XXXXX

Microsoft Ltd
Microsoft Campus
Thames Valley Park
Reading
RG6 1WG
UNITED KINGDOM

How does code recognise that PQR Inc, Microsoft Ltd are companies,
that
blah, new blah, Reading are towns/cities etc

Handling of this logic is non-trivial and may need tuning to the data.

Ken

 

[SSJpn]

Thats too bad. They really should have a reverse mail merge function. Thanks anyways all.

Kevin.