A Microsoft Word forum. Microsoft Office Word Forum - WordBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Microsoft Office Word Forum - WordBanter forum » Microsoft Word Newsgroups » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Word mail merge "Unable to Obtain List of Tables from Data Source"



 
 
Thread Tools Display Modes
  #1  
Old December 31st 07, 11:48 AM posted to microsoft.public.word.mailmerge.fields
Stephen Ford
external usenet poster
 
Posts: 6
Default Word mail merge "Unable to Obtain List of Tables from Data Source"

Office 2003
XP SP2 (up to date with MS Update)

In mail merge I get "Unable to Obtain List of Tables from Data Source"

Use Tools Letters and MailingsMail Merge and get to Select from Outlook
contacts and the above error occurs.

I am new to Word mail merge.

I think my office installation is pretty standard. I don't go in for unusual
setup.

Outlook has many contacts and I want to select contact info to unclude in a
merge document. The document being displayed is blank. I was thinking of
selecting recipients and then figuring out how to insert fields and so on.
--
Regards
Stephen Ford


Ads
  #2  
Old December 31st 07, 01:22 PM posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
external usenet poster
 
Posts: 4,583
Default Word mail merge "Unable to Obtain List of Tables from Data Source"

Typically when working with Outlook contacts it is more reliable and more
flexible to initiate the merge from Outlook - i.e. go into Outlook, select
some contacts, then open Outlook Tools|Mail merge..., study the options, and
go for it.

If you prefer to do it the other way,
a. be aware that the field names of Outlook contact fields differ depending
on how you get the contacts,
b. someone recently posted the following suggestion which seems to me to be
a good thing to try first:

Here's a resolution which has worked for me. I HOPE it helps in your
particular case.

Two steps:

1) Go to Tools / Email Accounts
a. Select "View or change existing directories or address
books", then Next.
b. There SHOULD be an "Outlook Address Book" type MAPI
directory there--but it's most likely missing.
If it's missing, click Add / Additional Address
Books / Outlook Address Book
c. Close and re-open Outlook.

2) In Outlook, right-click on the main Contact folder and go to the
"Outlook Address Book" tab. It's likely the checkbox is de-selected.
Select the checkbox, click Apply, and OK. *Do this for EACH Contact
sub-folder is they exist.

That's it. This has consistently resolved the "Unable to obtain list
of tables from the data source" error.



--
Peter Jamieson
http://tips.pjmsn.me.uk

"Stephen Ford" wrote in message
...
Office 2003
XP SP2 (up to date with MS Update)

In mail merge I get "Unable to Obtain List of Tables from Data Source"

Use Tools Letters and MailingsMail Merge and get to Select from Outlook
contacts and the above error occurs.

I am new to Word mail merge.

I think my office installation is pretty standard. I don't go in for
unusual setup.

Outlook has many contacts and I want to select contact info to unclude in
a merge document. The document being displayed is blank. I was thinking of
selecting recipients and then figuring out how to insert fields and so on.
--
Regards
Stephen Ford



  #3  
Old December 31st 07, 02:50 PM posted to microsoft.public.word.mailmerge.fields
Stephen Ford
external usenet poster
 
Posts: 6
Default Word mail merge "Unable to Obtain List of Tables from Data Source"

Ok Peter, Thx
I will have a play around, see what happens and report back.
Happy New Year.
--
Regards
Stephen

"Peter Jamieson" wrote in message
...
Typically when working with Outlook contacts it is more reliable and more
flexible to initiate the merge from Outlook - i.e. go into Outlook, select
some contacts, then open Outlook Tools|Mail merge..., study the options,
and go for it.

If you prefer to do it the other way,
a. be aware that the field names of Outlook contact fields differ
depending on how you get the contacts,
b. someone recently posted the following suggestion which seems to me to
be a good thing to try first:

Here's a resolution which has worked for me. I HOPE it helps in your
particular case.

Two steps:

1) Go to Tools / Email Accounts
a. Select "View or change existing directories or address
books", then Next.
b. There SHOULD be an "Outlook Address Book" type MAPI
directory there--but it's most likely missing.
If it's missing, click Add / Additional Address
Books / Outlook Address Book
c. Close and re-open Outlook.

2) In Outlook, right-click on the main Contact folder and go to the
"Outlook Address Book" tab. It's likely the checkbox is de-selected.
Select the checkbox, click Apply, and OK. *Do this for EACH Contact
sub-folder is they exist.

That's it. This has consistently resolved the "Unable to obtain list
of tables from the data source" error.



--
Peter Jamieson
http://tips.pjmsn.me.uk

"Stephen Ford" wrote in message
...
Office 2003
XP SP2 (up to date with MS Update)

In mail merge I get "Unable to Obtain List of Tables from Data Source"

Use Tools Letters and MailingsMail Merge and get to Select from Outlook
contacts and the above error occurs.

I am new to Word mail merge.

I think my office installation is pretty standard. I don't go in for
unusual setup.

Outlook has many contacts and I want to select contact info to unclude in
a merge document. The document being displayed is blank. I was thinking
of selecting recipients and then figuring out how to insert fields and so
on.
--
Regards
Stephen Ford





  #4  
Old January 28th 08, 08:57 AM posted to microsoft.public.word.mailmerge.fields
Stephen Ford
external usenet poster
 
Posts: 6
Default Word mail merge "Unable to Obtain List of Tables from Data Source"

I followed the given process but the address book was already available and
the check-box ticked. The error message remains. If you have any other ideas
they would be welcome.

In the meantime I am going through the Word merge tutorial. Maybe I will
pick up ideas along the way...

Stephen Ford


  #5  
Old January 28th 08, 09:57 AM posted to microsoft.public.word.mailmerge.fields
Graham Mayor
external usenet poster
 
Posts: 19,312
Default Word mail merge "Unable to Obtain List of Tables from Data Source"

Instead of just checking to see if it is present (which you confirm it is)
delete the address book (this will not delete the contacts list) then add it
again. This will rebuild the address book from the contacts list.

--

Graham Mayor - Word MVP

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


Stephen Ford wrote:
I followed the given process but the address book was already
available and the check-box ticked. The error message remains. If you
have any other ideas they would be welcome.

In the meantime I am going through the Word merge tutorial. Maybe I
will pick up ideas along the way...

Stephen Ford



  #6  
Old February 7th 08, 07:52 AM posted to microsoft.public.word.mailmerge.fields
Stephen Ford
external usenet poster
 
Posts: 6
Default Word mail merge "Unable to Obtain List of Tables from Data Source"

I've completely lost my way with this. I noted some time ago that the
instruction

1) Go to Tools / Email Accounts
a. Select "View or change existing directories or address
books", then Next.


is not exact. I happened to find the various dialogues by by accident. I
can't find them now. Tools / Email Accounts doesn't exist. Any ideas?


  #7  
Old February 7th 08, 08:16 AM posted to microsoft.public.word.mailmerge.fields
Graham Mayor
external usenet poster
 
Posts: 19,312
Default Word mail merge "Unable to Obtain List of Tables from Data Source"

Tools E-mail accounts is in Outlook 2003. In Outlook 2007 it is at File
Data File Management Address Books.

--

Graham Mayor - Word MVP

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


Stephen Ford wrote:
I've completely lost my way with this. I noted some time ago that the
instruction

1) Go to Tools / Email Accounts
a. Select "View or change existing directories or address
books", then Next.


is not exact. I happened to find the various dialogues by by
accident. I can't find them now. Tools / Email Accounts doesn't
exist. Any ideas?



  #8  
Old February 10th 08, 11:13 AM posted to microsoft.public.word.mailmerge.fields
Stephen Ford
external usenet poster
 
Posts: 6
Default Word mail merge "Unable to Obtain List of Tables from Data Source"

Yes of course. Got my head burried in Word...
I'm not too sure about the implications of removing the address book. Will
that delete my contact list? What is the relationship between the contact
list and the address book please? They sound as if they are
one-and-the-same-thing which is why I wonder if deleting one deletes the
other.

Stephen

"Graham Mayor" wrote in message
...
Tools E-mail accounts is in Outlook 2003. In Outlook 2007 it is at File
Data File Management Address Books.


--

Graham Mayor - Word MVP

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


Stephen Ford wrote:
I've completely lost my way with this. I noted some time ago that the
instruction

1) Go to Tools / Email Accounts
a. Select "View or change existing directories or address
books", then Next.


is not exact. I happened to find the various dialogues by by
accident. I can't find them now. Tools / Email Accounts doesn't
exist. Any ideas?





  #9  
Old February 10th 08, 11:49 AM posted to microsoft.public.word.mailmerge.fields
Graham Mayor
external usenet poster
 
Posts: 19,312
Default Word mail merge "Unable to Obtain List of Tables from Data Source"

Deleting the address book will not delete the contacts list, but if you
don't want to take my word for it take a backup of your PST file that
contains the contacts first. The address book is merely a view into the
contacts list that other applications can use. Adding it again will recreate
the link to the contacts list that hopefully is at the root of your problem.

--

Graham Mayor - Word MVP

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


Stephen Ford wrote:
Yes of course. Got my head burried in Word...
I'm not too sure about the implications of removing the address book.
Will that delete my contact list? What is the relationship between
the contact list and the address book please? They sound as if they
are one-and-the-same-thing which is why I wonder if deleting one
deletes the other.

Stephen

"Graham Mayor" wrote in message
...
Tools E-mail accounts is in Outlook 2003. In Outlook 2007 it is at
File Data File Management Address Books.

--

Graham Mayor - Word MVP

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


Stephen Ford wrote:
I've completely lost my way with this. I noted some time ago that
the instruction

1) Go to Tools / Email Accounts
a. Select "View or change existing directories or address
books", then Next.

is not exact. I happened to find the various dialogues by by
accident. I can't find them now. Tools / Email Accounts doesn't
exist. Any ideas?



  #10  
Old February 10th 08, 10:19 PM posted to microsoft.public.word.mailmerge.fields
Stephen Ford
external usenet poster
 
Posts: 6
Default Word mail merge "Unable to Obtain List of Tables from Data Source"

Yes that worked.
Thanks for bearing with me. A good result.

Stephen


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Unable to obtain list of tables from the data source MKG Mailmerge 3 December 20th 07 09:50 PM
Excel merge into Word:"unable to open data source" STEVE Microsoft Word Help 3 September 21st 07 02:58 PM
reversing "Last, first" in mail merge from one data source field Plum3pc Mailmerge 2 August 27th 06 06:51 AM
trouble with mail merge, word was unable to open data source edie Mailmerge 2 May 10th 06 04:46 PM
unable to obtain list of tables from data source Mail merger Mailmerge 1 February 28th 06 04:54 AM


All times are GMT +1. The time now is 09:34 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2004-2014 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.