Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
Yes that worked.
Thanks for bearing with me. A good result. Stephen |
#11
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
You are welcome
![]() -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Stephen Ford wrote: Yes that worked. Thanks for bearing with me. A good result. Stephen |
Reply |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Unable to obtain list of tables from the data source | Mailmerge | |||
Excel merge into Word:"unable to open data source" | Microsoft Word Help | |||
reversing "Last, first" in mail merge from one data source field | Mailmerge | |||
trouble with mail merge, word was unable to open data source | Mailmerge | |||
unable to obtain list of tables from data source | Mailmerge |