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 / December 2003

Tip: Looking for answers? Try searching our database.

Data Link Box Appears in Mail Merge Process

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Dale - 14 Dec 2003 19:05 GMT
I have Word and Outlook 2002 and in the process of trying
to create labels, after I have select my contact/personal
folders and before the mail merge screen, the procees is
interupted by a Data Link Property Box that prevents me
from completing.
Peter Jamieson - 15 Dec 2003 10:50 GMT
It sounds as if you are connecting to Outlook using the method in the Mail
Merge Wizard. Instead, try starting from Outlook - select your contacts
folder and try Outlook Tools|Mail Merge...

[Problems have been reported with the other approach, particularly with
"Invalid database function" or some such. Just out of interest, do you also
use Access and do you have an Access workgroup/security database set up? If
so, if you log in as Admin, do you have to provide a password?)
--
Peter Jamieson - Word MVP

> I have Word and Outlook 2002 and in the process of trying
> to create labels, after I have select my contact/personal
> folders and before the mail merge screen, the procees is
> interupted by a Data Link Property Box that prevents me
> from completing.
Dale - 15 Dec 2003 15:17 GMT
You're correct, I'm trying to use the word e-mail merger
process and can get it to work going through the outlook
merge process instead, but don't understand why I get
this Data Link Property Box.  I do not use Access.
>-----Original Message-----
>It sounds as if you are connecting to Outlook using the method in the Mail
[quoted text clipped - 15 lines]
>
>.
Peter Jamieson - 15 Dec 2003 15:58 GMT
I don't know /exactly/ why, but...

When you connect to Outlook from the Mail Merge Wizard, Word uses what I
think is quite a tortuous method. It gets the data using OLEDB (a database
access method) via the Jet database engine provider. Jet is the database
engine that Access uses when it opens .mdb files, which is why I was asking
about Access. Jet can read/write .mdb files, but it can also get data from a
number of other sources using things called Installable ISAMs (IISAMs). One
of these IISAMs is an "Exchange/Outlook provider", and Word uses that to get
the data from Outlook. During that process, a Jet (.mdb type) database is
created, typically in your user Temp directory. The process also creates
SCHEMA.INI file that tells the IISAM which fields to get from Outlook and
what to call them inside the Jet database.

Although that's about as much as I know about this process, there are so
many components and steps involved that I don't find it in the least
surprising that it goes wrong rather easily. However, most people who have
trouble with this report a different error. The reason I asked about the
security database etc. is because when you try to open a .mdb directly as a
data source (forgetting about Outlook altogether for the moment), Word may
show the Datalink dialog boxes if the .mdb has been secured.

I'm not sure you wanted to know that but it's the nearest I can get to an
answer to your question :-)

--
Peter Jamieson - Word MVP

> You're correct, I'm trying to use the word e-mail merger
> process and can get it to work going through the outlook
[quoted text clipped - 31 lines]
> >
> >.
 
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.