If you stop the cited process at the point where the file is a comma
delimited text file you can import the file into Outlook or simply open it
in Excel, but for the purpose of mail merge, as Jay says, it is easier to
use the Word document as a data source.
--
Graham Mayor - Word MVP
My web site
www.gmayor.com
Word MVP web site
http://word.mvps.org
Jay Freedman wrote:
Please read the article I cited befo
http://www.gmayor.com/convert_labels...mail_merge.htm
The result of that process is a Word file containing the names and
addresses in a format that can be used by the mail merge feature.
Once you have that document (and you can later add to it, remove
names, update addresses, and so forth), you can then print labels,
envelopes, form letters, and several other kinds of documents from
the same data.
You could transfer the information to Excel -- simply by copying the
table from Word and pasting it into a blank worksheet -- but there's
no particular advantage in doing so.
Whatever you do, don't waste your time manually typing everything
over again.
Jay & Suzanne - thanks for responding so quickly and with good
solutions. But you have made me realize I may be focusing on one
task instead of the "big picture". The list of addresses I have now
in a word doc is a list of people for a community fund raising
project. In other words, we'll prob be contacting some of these
people again with letters, tracking pledges, etc. So I'll be sending
out envelopes & letters on an ongoing basis for a while. Should I
just manually type these names into an address book? I've not used
Outlook but I have it....... Or should I set up the names in Excel?
.....Suggestions please!!
"Suzanne S. Barnhill" wrote:
If this is a one-time job, the simplest approach is to create a
single-column data source with the entire address in a single cell.
If each address is a single paragraph, that's a very simple Convert
Text to Table operation, separating at paragraphs.
If each line is a paragraph but there is an empty paragraph between
addresses, then that's almost as simple. It just requires replacing
paragraph breaks (^p) with line breaks (^l) and then replacing two
line breaks (^l^l) with a paragraph break, then converting the text
to a table, separating at paragraphs.
--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"Jay Freedman" wrote in message
...
You're going to have to do some work to rearrange the data into a
mail merge source document. See
http://www.gmayor.com/convert_labels...mail_merge.htm for
instructions.
After that's ready, you can run mail merges to envelopes just as
easilly as to labels.
--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.
Blue Bunny wrote:
I have Office 2003. I have been given a list of addresses in a
word document. The names and addresses are not in a
table....format looks like this:
Mr and Mrs John Jones
123 Somewhere Lane
Little City, VA 12345
Jane Smith
456 Main Street
Big Town, NC 67890
I have probably 150+ names.
I need to print envelopes for each address and I need to put a
return address on the envelope. My boss would like a logo
included in the return address. She does not want to use labels.
I need help. And since I'm not overly familiar with anything
except printing one envelope for a single letter I need detailed
directions!!!
Can anyone help me? I have to have this completed by mid-day
tomorrow, Thur. 7/24/08!!