Consulting

Results 1 to 5 of 5

Thread: Mail Merge Personalize Letter Bodies From Excel Column

  1. #1
    Moderator VBAX Sage SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,814
    Location

    Mail Merge Personalize Letter Bodies From Excel Column

    First I volunteered to be on the Board of Directors of a Volunteer Fire Department.

    Then I volunteered to update the Members list.

    And the By-Laws.

    And create an Accounting system.

    Gotter done.

    Now I am writing the Annual Notice. They will be commercially printed and the printer needs the Merge document as one file. no problem.

    The problem is that I am running out of time.

    I've got the notice written and have the addresses placed on Page 1, but I need to add a field in the body of each notice that pulls individual data for each addressee from the Excel table that holds their names and addresses.

    The Table headers are Number_ Properties, Name, Address, City, etc.

    In the letter body, I need to say
    Blah blah blah [Number_Properties] blah blah blah.
    If you can give me a quick pointer, I can figure it out
    I expect the student to do their homework and find all the errrors I leeve in.


    Please take the time to read the Forum FAQ

  2. #2
    Knowledge Base Approver VBAX Guru macropod's Avatar
    Joined
    Jul 2008
    Posts
    4,435
    Location
    Cheers
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    The Table headers are Number_ Properties, Name, Address, City, etc.
    add another column to table, put new header as mergefield in body

  4. #4
    Moderator VBAX Sage SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,814
    Location
    Thanks guys. with that, I'm off to the mines.
    I expect the student to do their homework and find all the errrors I leeve in.


    Please take the time to read the Forum FAQ

  5. #5
    Knowledge Base Approver VBAX Guru macropod's Avatar
    Joined
    Jul 2008
    Posts
    4,435
    Location
    Quote Originally Posted by westconn1 View Post
    add another column to table, put new header as mergefield in body
    What would that achieve? The only variable (Number_Properties) is already in the table. All that's needed is for the «Number_Properties» mergefield to be added to the document body.
    Cheers
    Paul Edstein
    [Fmr MS MVP - Word]

Posting Permissions

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