Results 1 to 7 of 7

Thread: Mail Merge

  1. #1
    bltomlinson
    Guest

    Mail Merge

    Hi,
    Have Office 97 running on NT4. Please can anyone answer this really trivial question. I've just been handed a query re Word and Access and being new to the Word Application I'm totally stumped even after looking in all the obvious places. There is an Access application developed by a person who needless to say has left. Within this users could create an Output file, open Word and import this file into mail merge by specifying the same Database - note only the one instance of Access remained open. A new version of the Access Database has been developed and users naturally assume the same procedure can be followed. Unfortunately when they try to link to this Database another version of Access is opened. There must be a simple explanation and any guidance would be gratefully received.
    Thanks
    Brian

  2. #2
    bltomlinson
    Guest

    Re: Mail Merge

    Hi,
    I'm replying to my own post because after finding the solution it might help others. Whether it dates back to, dare I mention it , DOS I don't know but if the Database is in a folder with a name greater than 8 characters long two applications are generated. If less than 8 only one appears - don't you just love it when it all comes together <g>
    Brian

  3. #3
    BAM
    Guest

    Re: Mail Merge

    Hi Brian,

    It could also be due to Word looking for a window titled Microsoft Access. If the database has an Application Title then a new instance of Access will be started.

    For a workaround, see this article on Access MVP Dev Ashish's Web site:
    <A target="_blank" HREF=http://www.mvps.org/access/bugs/bugs0011.htm>http://www.mvps.org/access/bugs/bugs0011.htm</A>
    ~~~~~~~~~~~~~~~~
    Cheers!

  4. #4
    bltomlinson
    Guest

    Re: Mail Merge

    Hi,
    The reason I came to my conclusion was I tried copying the offending Database to various folders only those folders that had a name less than 8 characters returned just the one application all others generated a second.
    Brian

  5. #5
    BAM
    Guest

    Re: Mail Merge

    Hi Brian,

    This is all interesting since I haven't ran into what you described before. Do you mind that I ask a few questions on this?

    Does the titlebar of the database reflect a title other than "Microsoft Access - [Database Name: Database]"?

    Does the folder name contain 8 characters or less or are folder names over 8 characters without spaces still be acceptable?

    If you go to Start/Run and re-register Access by running the following command, does the problem still exist if the database is placed in a folder that contains more than 8 characters?

    MSAccess /regserver

    Note that there is a space before the forward slash.
    ~~~~~~~~~~~~
    Cheers! <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  6. #6
    bltomlinson
    Guest

    Re: Mail Merge

    Hi,
    If it helps the answers are as follows
    1.Does the titlebar of the database reflect a title other than "Microsoft Access - [Database Name: Database]"? - No (and no Application Title set)
    2.Does the folder name contain 8 characters or less or are folder names over 8 characters without spaces still be acceptable? - 8 character and under ok over 8 not (see later)
    3.If you go to Start/Run and re-register Access by running the following command, does the problem still exist if the database is placed in a folder that contains more than 8 characters - This works OK as does opening Access and then opening the Database.

    I've also actioned a small test of my own, namely creating two folders "Mailings - 8 characters" & "Mailingss - 9 characters) inside each I've copied a database (totally different from the original) and tried the same thing. Sure enough the one in "Mailings" left only one app open, the one in "Mailingss" left two.
    I'd be interested in any further thoughts you may have - do we get a commission from Bill G?
    Brian

  7. #7
    BAM
    Guest

    Re: Mail Merge

    Hi Brian,

    Thanks for taking the time to look into this further. I am unable to reproduce the problem that you describe.

    I've tried this on both Word 97 and Word 2000, Win95, Win98, Win2000, and WinNT, and in all scenarios the number of characters of the folder name is irrelevant. I was thinking that perhaps you had a broken file type, and the ability of long file names was removed. However Re-registering Access with the /regserver switch should have taken care of that.

    So... although you have found something that works, I believe it's more of a band-aid fix for an underlying problem.

    If you want to find what the real problem is then perhaps you can describe the exact steps you are taking so I can possibly reproduce the problem.

    Now, as for a commission - I highly doubt it! <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15> But isn't the knowledge you obtain payment enough? <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    ~~~~~~~~~~~~~
    Cheers!

Posting Permissions

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