Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Warrington, Cheshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Field Order in Mail Merge (Acces2003/Word2003)

    Don't know if this should be here or in the Word forum but here goes.
    I have created a query on an Access 2003 DB; all data is returned OK and the fields are displayed in the order I want i.e the order they are shown in the query design.
    The query is used in a Mail Merge using Word 2003. All the data is returned OK but the fields are not in the required order (e.g. the first four query fields 'Duty Type', 'Title', 'First Name', 'Last Name' are displayed 'Last Name', 'First Name', 'Title', 'Address 1' . . . . .'Duty Type') in the Mail Merge recipients dialogue box.
    The query gets data from two tables, Volunteers and Volunteers Duty. Fields Title, First Name, Last Name, Address 1 etc all come from the Volunteers table. Duty Type comes from table Volunteers Duty.
    Does any lounger know how this can be rectified, please?
    TIA
    Silverback
    Silverback

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

    Re: Field Order in Mail Merge (Acces2003/Word2003)

    I think Microsoft is trying to be user-friendly, and placing the fields it thinks will be the most used (those from the "Address Block") at the front. There doesn't seem to be a solution that will last longer than the current session...

Posting Permissions

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