Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / June 2006

Tip: Looking for answers? Try searching our database.

Can I mailmerge using a Word .doc file

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Neil - 19 Jun 2006 18:54 GMT
I'm a newbie. I've been trying to do a mailmerge using a Word .doc file which
has a list of addresses separated by hard returns (see example below). My
various attempts have failed.  Can I do a mailmerge with a Word .doc file and
if so, can someone give me step by step instructions. Thanks to anyone who
can help.

John Public
1111 Melody Lane
Silver Spring, MD

Jane Public
2222 Evans Drive
Bethesda, MD
Doug Robbins - Word MVP - 19 Jun 2006 19:44 GMT
If you select all of the addresses and then select Convert Text to Table
from the Tables menu selecting the Paragraphs as the separator and each
address ends up in a separate cell of the table, all you need to do then is
insert a row at the top of the table into which you insert a field name to
be used when you set up the mail merge.

See "Convert Labels into Mail Merge Data File" on fellow MVP Graham Mayor's
website at:

http://www.gmayor.com/convert_labels_into_mail_merge.htm

See the article "Mailmerge Labels with Word XP" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> I'm a newbie. I've been trying to do a mailmerge using a Word .doc file
> which
[quoted text clipped - 11 lines]
> 2222 Evans Drive
> Bethesda, MD
Neil - 19 Jun 2006 21:44 GMT
It still didn’t work. I converted the document so I now have a table with one
column and many rows. There are 3 rows for each address (name, street, city)
and a blank row between the each address. Here’s what happens when I  open a
blank document and run the mailmerge wizard:

Step 1: I bullet envelopes

Step 2: I OK size 10 envelope with return address in the upper     left hand
corner and move the cursor to where I want the addresses (I previously set up
the return address)

Step 3: I select the file with the table which now brings up a     “Mailmerge
Recipients” window with a table similar to the one I created (one column, 3
rows for each address and a blank row between addresses) with a check mark to
the left of each row including the blank ones.

Step 4: I choose “Address Block” which brings up an “Insert     Address Block”
window. I click OK and <<AddressBlock>> now pops up where I left the cursor
for the addresses.

Step 5: Nothing now appears on the envelope except for the return address.
The  <<AddressBlock>> code is now gone. As I click to preview each next
address, they are all blank as well (except for the return address).

Step 6: No change.

I apologize for being so green but the instructions in Word aren’t much help
and the link regarding labels just confused me more.  Thanks so much for your
time.

Neil

P.S. The reason my first message was posted 3 times was the first two times
I got an error message and assumed the post did not go through.  I am,
however, impatient. Thanks again.

> If you select all of the addresses and then select Convert Text to Table
> from the Tables menu selecting the Paragraphs as the separator and each
[quoted text clipped - 27 lines]
> > 2222 Evans Drive
> > Bethesda, MD
Doug Robbins - Word MVP - 20 Jun 2006 04:36 GMT
Then you will have to follow the method in the article:

"Convert Labels into Mail Merge Data File" on fellow MVP Graham Mayor's
website at:

http://www.gmayor.com/convert_labels_into_mail_merge.htm

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> It still didn't work. I converted the document so I now have a table with
> one
[quoted text clipped - 80 lines]
>> > 2222 Evans Drive
>> > Bethesda, MD
Graham Mayor - 20 Jun 2006 06:41 GMT
When you convert text to table indicate in the dialog that the table has 4
columns and not 1!

Signature

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

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

> It still didn't work. I converted the document so I now have a table
> with one column and many rows. There are 3 rows for each address
[quoted text clipped - 74 lines]
>>> 2222 Evans Drive
>>> Bethesda, MD
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.