+ Reply to Thread
Results 1 to 10 of 10

Merge files for 65 individual reports

  1. #1
    Forum Contributor
    Join Date
    03-08-2007
    Location
    St. Augustine, Fl
    MS-Off Ver
    Excel 2021 for Mac
    Posts
    374

    Merge files for 65 individual reports

    I have 65 reports on individual persons. I need to update each of them from an Excel file. How can I use merge do that without having to bring up each individual file?
    Thanks.
    Last edited by Wskip49; 12-27-2013 at 01:21 PM. Reason: not solved

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

    Re: Merge files for 65 individual reports

    You can't. Indeed, it would probably be a waste of time trying to use mailmerge that way. I'd suggest using an Excel macro to automate the opening & updating of these files, provided you can programmatically identify where & how each file is to be updated.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Forum Contributor
    Join Date
    03-08-2007
    Location
    St. Augustine, Fl
    MS-Off Ver
    Excel 2021 for Mac
    Posts
    374

    Re: Merge files for 65 individual reports

    Thank you so much. I have no idea how to even start a macro to do this project.

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

    Re: Merge files for 65 individual reports

    Without know a whole lot more about your Excel workbook and the documents to be modified, the following skeleton Excel macro is the most I can provide:
    Please Login or Register  to view this content.
    The macro includes its own folder browser, so all you need do is to point it to the folder containing the Word documents, all of which will then be processed. Of course, there's no "processing" code yet...

  5. #5
    Forum Contributor
    Join Date
    03-08-2007
    Location
    St. Augustine, Fl
    MS-Off Ver
    Excel 2021 for Mac
    Posts
    374

    Re: Merge files for 65 individual reports

    Here is an example of the file.
    Last edited by Wskip49; 12-23-2013 at 09:10 PM.

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

    Re: Merge files for 65 individual reports

    Although you've provided a sample data file, I have no idea where any of those data should go in your existing 60+ report documents or how one might programmatically identify which document goes with which record or how to identify the update locations in those documents. Both are essential to making this work.

  7. #7
    Forum Contributor
    Join Date
    03-08-2007
    Location
    St. Augustine, Fl
    MS-Off Ver
    Excel 2021 for Mac
    Posts
    374

    Re: Merge files for 65 individual reports

    Thank you so much for looking at it. I really have no idea how to help you help me. I'm so sorry.

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

    Re: Merge files for 65 individual reports

    Can you attach a couple of sample Word documents to a post with some representative content (delete anything sensitive), highlighting which elements need to be updated, with a comment as to which column from the Excel workbook the data should be sourced?

  9. #9
    Forum Contributor
    Join Date
    03-08-2007
    Location
    St. Augustine, Fl
    MS-Off Ver
    Excel 2021 for Mac
    Posts
    374

    Re: Merge files for 65 individual reports

    Here are the two sample files.
    Attached Files Attached Files

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

    Re: Merge files for 65 individual reports

    OK, your attached document is a standard 'letter' mailmerge main document. If you were to 'Finish' the merge using that, you would end up with 60+ reports in a single output document. I can't see that you're actually 'adding' anything to what's already there, though. If all of your documents are like that, the implication is that someone has done a mailmerge setup and then, instead of finishing the mailmerge, has simply saved the 60+ report previews - all as 'letter' mailmerge main documents in their own right. That's really not how a mailmerge is supposed to be done.

    Your main options are:
    1. 'Finish' the merge using any one of the mailmerge main documents, so as to generate the 60+ updated reports in a single output document and -
    (a) keep them that way; or
    (b) use a macro to split the updated output document into separate files; or
    2. Use the Many-to-One Mail Merge add-in from Doug Robbins at https://skydrive.live.com/?cid=5aedc...615E886B%21566 to directly generate the 60+ updated reports as separate files.

+ 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. Outputting individual cells to individual text files
    By db9429 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-17-2013, 03:39 PM
  2. Macro to create individual reports off of a Master Workbook
    By DotWFM in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-21-2012, 01:10 PM
  3. Replies: 0
    Last Post: 06-12-2012, 09:23 AM
  4. Creating individual student reports
    By c1987 in forum Excel General
    Replies: 5
    Last Post: 05-15-2012, 12:47 PM
  5. [SOLVED] How can I get individual reports from excell gradebook?
    By KaKa in forum Excel General
    Replies: 1
    Last Post: 03-26-2005, 12:06 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