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 / September 2006

Tip: Looking for answers? Try searching our database.

mail merge cannot open

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
L. - 07 Sep 2006 23:19 GMT
Word(office) 2k, winxp.

Followed instructions @
http://www.gmayor.com/convert_labels_into_mail_merge.htm
and converted one of 7 pages as a test. It worked fine.
Went ahead and coverted other 6 pages and started to merge and now I get
following error msg.
"Word cannot open main labels.doc as a data or header source because it is a
mail merge main doc."

Saved table with 4 column headers, see below for example.

     First Name
    Last Name
    Address
    City, State, Zip

     xxxxxx
    xxxxxxxxxx
    232 xxxxxx Dr.
    xxxxxx, MO   xxxxx

     xxxxx
    xxxxxxxxxxxxx
    2400 xxxx Dr.
    xxxxxxxxxx, IL   xxxxx

     xxxxxxxxxxxx
    xxxxxxx
    60 xxxxxxxxxxxxx Dr.
    xxxxxx, CA  xxxxx

     xxxxxxxx
    xxxxxxxxx
    3 xxxxxxxxx Dr.
    xxxxxxxxxx, CA   xxxxxx

     Mr. & Mrs. xxxx
    xxxxxxxxxxxxx
    20 xxxxxxxxxxx Ave.
    xxxxxxxx, TX   xxxxxx

     xxxx
    xxxxxxxxx
    4021 xxxxxxxx Dr.
    xxxxxxx, MO  xxxxxx

Not sure what I have done wrong.

L.
Graham Mayor - 08 Sep 2006 07:30 GMT
Your data shown below is not in the format required as a data source. You
need a table with the headings in the first row and the appropriate data
below with one row per record - which is explained in the link you referred
to.

Signature

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

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

> Word(office) 2k, winxp.
>
[quoted text clipped - 46 lines]
>
> L.
L... - 08 Sep 2006 12:44 GMT
Sorry 'bout that, I copied/pasted the table and it didn't format here
correctly.
This is how it looks.

  First Name            Last Name              Address             City,
State, Zip
Mr. & Mrs.xxxx            Jenkins                20 Elm St        Anywhere,
Tx, 12345
   etc.                                etc.                         etc.
etc.

Strange thing is I copied and pasted the 4 columns into a Excel spread sheet
and then back to Word and it works.

L.

> Your data shown below is not in the format required as a data source. You
> need a table with the headings in the first row and the appropriate data
[quoted text clipped - 51 lines]
>>
>> L.
 
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.