+ Reply to Thread
Results 1 to 4 of 4

Mail Merge & Automatic Table Length

  1. #1
    Registered User
    Join Date
    02-10-2013
    Location
    athens
    MS-Off Ver
    Excel 2003
    Posts
    9

    Mail Merge & Automatic Table Length

    Good evening everyone,

    I have the following problem. I have created a group of data in an excel file that has 300 lines and I want to use it for mail merge.

    I have prepared the word document and I want a specific table to be repeated at the beginning of each page and have a secondary table underneath it that will get the data from the Mail Merge.

    My problem is that if the table won't expand automatically unless I have the table rows length the exact size as the data rows in the excel, in which case the constant table on the top of each page won't repeat itself.

    Is there a way to work around it?


    Thank you in advance for all your help.

    Kind Regards,
    Attached Images Attached Images
    Last edited by Bill tznt; 07-19-2022 at 06:07 AM.

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Mail Merge & Automatic Table Length

    Simple: Put the 'repeating' tables in the page header.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Registered User
    Join Date
    02-10-2013
    Location
    athens
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Mail Merge & Automatic Table Length

    Thank you for your response.

    That would only solve the repeating table issue. How about the table that I want to automatically create new rows as long as it finds data in the excel that mail merge will read?

  4. #4
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Mail Merge & Automatic Table Length

    See, for example: https://www.msofficeforums.com/mail-...-tutorial.html. My personal preference would be to use a DATABASE field to build the table, with a mailmerge-driven macro to reformat the tables (especially the headers) post-merge.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Mail Merge - Create separate Mail merge pdf for each sheets of an excel file
    By sureshbvs in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-13-2021, 12:38 PM
  2. Help pivot table? Merge? Mail Merge?
    By egarza123 in forum Excel General
    Replies: 11
    Last Post: 05-28-2019, 03:07 PM
  3. Replies: 0
    Last Post: 01-05-2015, 07:35 AM
  4. Automatic mail merge with PDF template and excel data source
    By Manish_Gupta in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-12-2014, 01:13 AM
  5. Replies: 2
    Last Post: 07-12-2012, 08:11 PM
  6. Mail Merge from Pivot Table
    By scrubdubbins in forum Excel General
    Replies: 0
    Last Post: 03-31-2011, 10:06 AM
  7. Pivot Table / Mail Merge
    By nmicon in forum Access Tables & Databases
    Replies: 1
    Last Post: 03-25-2009, 12:19 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1