Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    york, Yorkshire, England
    Posts
    30
    Thanks
    0
    Thanked 1 Time in 1 Post

    mail merge using access db

    we're using word97 & access97 ...
    when we try to Mail Merge in Word, using Access database with 44 records, only the initial 3 records are processed ...
    Check For Errors says that nothing is wrong ...
    any ideas what might be happening?

    all relevant suggestions gratefully recieved.
    thanks
    john

  2. #2
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Levin, Manawatu-Wanganui, New Zealand
    Posts
    324
    Thanks
    9
    Thanked 28 Times in 26 Posts

    Re: mail merge using access db

    Hi John
    Have you checked to ensure that there are no criteria in either word or Access that are limiting the dataset ...
    Word MailMerge Query Options ...
    An Access query.
    After that I would need more info on the datasource.
    Is it a table, a query, if related tables are the relationships correct etc ...

    Cheers
    Geof

  3. #3
    Lounger
    Join Date
    Jan 2001
    Location
    york, Yorkshire, England
    Posts
    30
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: mail merge using access db

    geof
    thanks for the reply.
    it's a (simple) table. we think there is something odd in *some* of the records; if we remove record 4, then it merges further. altogether, from the 44 (apparently) similar records, 6 won't load.
    all the records include substantial blocks of text (from medical abstracts), so it may take us a while to pin down any offending characters/combinations.
    sigh.

  4. #4
    BAM
    Guest

    Re: mail merge using access db

    Hi John,

    Is the offending character combination is a field that contains more than 255 characters?

    That is a limitation for Word. BUT I have heard if the first record in this field contains more than 255 characters then Word will accept the larger chunks of data.
    ~~~~~~~~~~~~
    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
  •