Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Need Software to convert MS Word file into mailing list data

Mar 4, 2011 2:35AM PST

I have a long list of addresses in Word (192 pages) that I need to convert into a database (or Excel) file. Addresses are typically formatted:

COMPANY
Address 1
Address 2
Name

Sometimes no name, sometimes 3 address lines, sometimes an email address. There is always 1 blank line between entrys.

Any suggestions for software (preferably free)?

Discussion is locked

- Collapse -
Is there not a way to export that to Excel?
Mar 4, 2011 5:52AM PST

I can't tell at the moment because I'm not on my machine that has Office, but doesn't Word and Excel export and import to each other?

What happens if you copy/paste the data into an Excel spreadsheet?

Mark

- Collapse -
Re: convert
Mar 4, 2011 6:12AM PST

If you already have Word, it includes the tool needed to do that. It's called VBA and you can use it to program a macro that does what you want. So, while it isn't really free, it's free for you, since you already paid for MS Office.
Hiring a programmer isn't free, but doing it yourself can be considered free also.

An alternative is to prepare for a rather long session to copy/paste all lines to Excel. Let me see: 192 pages times 50 lines a page = 9600 copy/pastes. That's a lot.

It's faster to replace all paragraph marks in one address in a tab (just a few keys, always the same, so it's one recorded macro for each line, using a shortcut. That's some 10.000 lines. A good optimization is to record different macro's for addresses of 2,3,4,5 and 6 lines. Then it's one shortcut per address. That's some 2000 keypresses.
Might be faster than learning to program VBA. But it's certainly cheaper than hiring a programmer. And it's an excellent lesson about not using MS Word as a database (might not be something you did yourself, then it's not a very effective lesson).

You can save the file with all that lines with tabs as a text file and import in Excel to use as the mailing list. It might need some manual cleaning up.

Kees