View Single Post
 
Old 05-11-2011, 02:49 AM
Mark J Rees Mark J Rees is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: May 2011
Posts: 4
Mark J Rees is on a distinguished road
Question Merge from Access linked to a SQL View

Hello all,

I'm new to this forum but hopeing you can help me.

Our receptionists merge in word xp from access (merge.mdb) which is linked to an SQL view and everything works perfectly.....

The only issue we have is when sending a merged document to a client, via email, cd, memory stick etc etc the client opens the word document and word displays cannot find data source c:\merge.mdb and then the client is asked to locate a datasource.

i was under the impression when merging to a new document this removes the datasource link and just inserts the data as text. so why does it still think its linked to a datasource?

Hope someone can help me, thanks
Reply With Quote