Results 1 to 9 of 9
  1. #1
    2 Star Lounger
    Join Date
    Mar 2004
    Location
    Portland, Oregon
    Posts
    173
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Using OBDC in Mail Merge (2003)

    I am using a document generation program to merge information into a word document. The program (Ghostfill) uses OBDC to connect to the Access database (where the information is stored). My problem is since we upgraded to Windows XP and Office XP, everytime I merge I'm asked to locate the *.mdb. This is new, never use to happen. Is there a way to tell Word to look in a certain place for the merge sorce?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Using OBDC in Mail Merge (2003)

    Mail merge has been changed profoundly in Word 2002 and 2003. There is a way to avoid the prompt to locate the database, but it requires a small modification to the source code of the Ghostfill program. You could ask the manufacturer if they have an updated version for Word 2002/2003 - you will not be the only customer with this problem. Or if you can edit the source code yourself (and have permission to do so!), we can help you with that.

  3. #3
    2 Star Lounger
    Join Date
    Mar 2004
    Location
    Portland, Oregon
    Posts
    173
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Using OBDC in Mail Merge (2003)

    I don't have access to the sorce code, but do have access to Ghostfill Tech support... I'll forward your message to them. Have you ever used GF?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Using OBDC in Mail Merge (2003)

    No, I haven't, but I can make a guess at how they initiate the mail merge. In the OpenDataSource method of the MailMerge object, they need to add SubType:=wdMergeSubTypeWord2000 to make the merge work as in Word 2000 and before. But I bet they already know this.

  5. #5
    2 Star Lounger
    Join Date
    Mar 2004
    Location
    Portland, Oregon
    Posts
    173
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Using OBDC in Mail Merge (2003)

    I'll bring this to their attention... perhaps they have not thought of it... In the meantime, is there anyway I can change the register or something to automatically look in a certain place for data sources?

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Using OBDC in Mail Merge (2003)

    I'm afraid not. Sorry.

  7. #7
    2 Star Lounger
    Join Date
    Mar 2004
    Location
    Portland, Oregon
    Posts
    173
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Using OBDC in Mail Merge (2003)

    pooy
    Thanks for your help. <img src=/S/blackteeth.gif border=0 alt=blackteeth width=20 height=20>

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Using OBDC in Mail Merge (2003)

    A couple of months ago, you asked a similar question; I posted a reply in <post#=451893>post 451893</post#>, but my experience with that suggestion is not positive; changing that registry key has flaky results,

  9. #9
    2 Star Lounger
    Join Date
    Mar 2004
    Location
    Portland, Oregon
    Posts
    173
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Using OBDC in Mail Merge (2003)

    You're right, I did. Unfortunatly I could not find it when I went looking for it, so that's why I reposted it. However, now I'm glad I did. I did send an e-mail to the developers of GF, they are always very quick to respond, so we'll see what happens.

    Thanks for your help in this.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •