Results 1 to 13 of 13
  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

    Merge fields dont update (2003 SP2)

    I am having trouble with mail merge. In Access VBA, I set up a Word data doc and open the merged doc that refers to it. One of the last lines of code updates the fields in the doc. But now, out of the blue, the fields don
    Regards,
    Peter

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

    Re: Merge fields dont update (2003 SP2)

    Does this happen in all merge documents or just this specific one? If it's only this one, perhaps the merge fields have been locked. See if the following helps:
    - Press Ctrl+A to select the entire document.
    - Press Ctrl+Shift+F11 to unlock the fields.
    - Save the document.

  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: Merge fields dont update (2003 SP2)

    Thanks for the suggestion Hans.
    But unlocking made no diff at all.
    I didn
    Regards,
    Peter

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

    Re: Merge fields dont update (2003 SP2)

    Is that a permanent solution, or do you have to repeat it each time you want to perform the mail merge?

  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: Merge fields dont update (2003 SP2)

    I have to re-do it every time!
    Regards,
    Peter

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

    Re: Merge fields dont update (2003 SP2)

    I'm afraid we'd have to see (a stripped down copy of) the database and the merge document if you want more help.

  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: Merge fields dont update (2003 SP2)

    I have reduced it from 9+ MB to a 120K zip file, but that is 20 K over Woodys limit. What is the correct procedure,? Should I split it into 2 posts?
    Regards,
    Peter

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

    Re: Merge fields dont update (2003 SP2)

    That's a possibility.

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

    Re: Merge fields dont update (2003 SP2)

    I managed to cut it down.
    These 3 files need to go into C:Temp
    Attached Files Attached Files
    Regards,
    Peter

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

    Re: Merge fields dont update (2003 SP2)

    The problem appears to be the line

    .ActiveDocument.Fields.Update

    near the end of PrintLetter. If I comment out that line, the data are displayed correctly.

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

    Re: Merge fields dont update (2003 SP2)

    Well I'll be stuffed!
    So the line that updates fields actually stops the updating. Go figure!
    Beats me how you worked that one out. then again I can say that with all you solutions.
    Hans you're a whizz.
    Attached Images Attached Images
    Regards,
    Peter

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

    Re: Merge fields dont update (2003 SP2)

    I placed a breakpoint at the beginning of PrintLetter and single-stepped through it. I noticed that the data were displayed correctly when Label.doc was opened, but the first label was repeated throughout the page when the fields were updated...

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

    Re: Merge fields dont update (2003 SP2)

    Which of course is pretty darned logical, but never occurred to me..
    As we say in Australia, 'you bewdy mate!'
    Regards,
    Peter

Posting Permissions

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