Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Aug 2013
    Posts
    2
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Question Need help with Mail Merge with Variable data in Word 2007 ASAP

    I have a very large Excel (2007) file with 2,000 rows of data. I also have a Microsoft word doc that will display the merged information as follows:

    Top of page:
    Physician Number
    Physician Name

    Middle of page: (4-column Chart)
    Patient first name Patient Last Name Patient Acct. Number Date of service

    A new Physician name and number should appear once at the top of each page. However, each physician has a different number of patients that will appear in their chart. I need the merge to list each patient associated with each physician in the chart. Right now, the merge produces one record for each row of data. Therefore the Physician name appears multiple times and each chart contains only one line of information.

    Need your help. Thanks

  2. #2
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    La Jolla,CA
    Posts
    1,100
    Thanks
    13
    Thanked 37 Times in 36 Posts
    Could you post a sample of the Excel workbook?

  3. The Following User Says Thank You to kweaver For This Useful Post:

    BellaReed97 (2013-08-03)

  4. #3
    New Lounger
    Join Date
    Aug 2013
    Posts
    2
    Thanks
    1
    Thanked 0 Times in 0 Posts
    I can't add an attachment. I did type a sample with dummy data so you can get an idea of how the spreadsheet is formatted. The key field is the Physician number. I want the end result to look like this:

    Physician Number: 0123456
    Physician Name: Doctor C

    Patient Information for Doctor C
    Patient First Name Patient Last Name Patient Acct. Number Date of service
    Umi Zoomi 0007891010 1/1/2020
    Dora Explorer 0007891011 1/2/2020
    Sponge Bob 0007891012 1/3/2020
    ------------page break----------------

    Physician Number: 0123457
    Physician Name: Doctor C2

    Patient Information for Doctor C2:
    Patient First Name Patient Last Name Patient Acct. Number Date of service
    Square Pants 0007891013 1/4/2020
    ------------page break----------------
    -

    Sample Excel info with dummy data:
    Physician Number Physician Name Patient First Name Patient Last Name Patient Acct. Number Date of Service
    0123456 Doctor C Umi Zoomi 0007891010 1/1/2020
    0123456 Doctor C Dora Explorer 0007891011 1/2/2020
    0123456 Doctor C Sponge Bob 0007891012 1/3/2020
    0123457 Doctor C2 Square Pants 0007891013 1/4/2020
    0123460 Doctor DD Cyber Monday 0007891014 1/5/2020
    0123460 Doctor DD Eclipse Of Heart 0007891015 1/6/2020
    0123462 Doctor FF Toni Brax 0007891016 1/7/2020
    0123462 Doctor FF Tom Arnold 0007891017 1/8/2020
    0123464 Doctor LL Keri Washin 0007891018 1/9/2020
    0123464 Doctor LL Nona Ryder 0007891019 1/10/2020
    0123464 Doctor LL Mint Coin 0007891020 1/11/2020
    0123464 Doctor LL Red Dollar 0007891021 1/12/2020

  5. #4
    Super Moderator
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    3,540
    Thanks
    3
    Thanked 148 Times in 141 Posts
    You need to work through the tutorial created by Macropod. This tutorial contains all you will need to know to do this.

    http://windowssecrets.com/forums/sho...merge-Tutorial
    Andrew Lockton, Chrysalis Design, Melbourne Australia

Posting Permissions

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