Results 1 to 8 of 8
  1. #1
    5 Star Lounger
    Join Date
    May 2001
    Location
    Patterson Lakes, Melbourne, Victoria, Australia
    Posts
    637
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Mail merge no longer merging (Access SP3)

    Help. Code that I have been using for years to open and print a Word merge doc, no longer works. Part of the code that opens and populates a Word doc that is used as the data source still works. When the merge doc is opened by Access it is no longer a merge doc! If I open the merge doc in Word. it
    Regards,
    Peter

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Mail merge no longer merging (Access SP3)

    First question is what version of Access are you working with - 2000 or 2002? The second question is what is the output? If you were mergeing to email, SP3 of either may have done you in. Also, how are you initiating the merge from Access - using Automation, or clicking on the merge to Word button?
    Wendell

  3. #3
    5 Star Lounger
    Join Date
    May 2001
    Location
    Patterson Lakes, Melbourne, Victoria, Australia
    Posts
    637
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail merge no longer merging (Access SP3)

    I
    Regards,
    Peter

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Mail merge no longer merging (Access SP3)

    I'm not aware of anything that would have messed with Word merges in SP3 for 2002. I assume this was working just fine with 2002 SP2, and you didn't just upgrade from 2000 to 2002 SP3 directly. (There were significant changes in the Word Mail Merge from 2000 to 2002.) Have you tried building a sample set of merge data in Word and mergeing with that?
    Wendell

  5. #5
    5 Star Lounger
    Join Date
    May 2001
    Location
    Patterson Lakes, Melbourne, Victoria, Australia
    Posts
    637
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail merge no longer merging (Access SP3)

    Sorry for the delay, I
    Regards,
    Peter

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

    Re: Mail merge no longer merging (Access SP3)

    According to the current issue of Woody's Office Watch, Office XP SP-3 breaks mail merge. The <!mskb=825765>Microsoft Knowledge Base Article 825765<!/mskb> referred to has now been corrected; it may contain the solution to your problem.

  7. #7
    5 Star Lounger
    Join Date
    May 2001
    Location
    Patterson Lakes, Melbourne, Victoria, Australia
    Posts
    637
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail merge no longer merging (Access SP3)

    Thanks Wendell. That fixed the problem.
    I hadn't read that issue of WOW as I was away on hols.
    Sorta makes one rather angry with microsoft (they don't deserve a capital) doesn't it?
    Once again the font of all knowledge (you) has come to the rescue.
    Regards,
    Peter

  8. #8
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Mail merge no longer merging (Access SP3)

    Hans deserves the credit - not me! I hadn't seen the WOW article either, so well done Hans <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30>
    Wendell

Posting Permissions

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