+ Reply to Thread
Results 1 to 1 of 1

Is this possible: Mail Merge/VBA to merge PDFs into one document based on cell values

  1. #1
    Forum Contributor
    Join Date
    07-30-2012
    Location
    Leeds
    MS-Off Ver
    Excel 2013
    Posts
    177

    Is this possible: Mail Merge/VBA to merge PDFs into one document based on cell values

    Hi all,
    This is a speculative idea for a project I am working on for staff at three local schools.

    I have a set of data from a google form about staff understanding of different ICT tools/skills. E.g. Saving documents as a PDF, with the answer rated:
    Very Confident
    Confident
    Unconfident - would like training
    Very unconfident - training priority

    I have written a page in word (have a .docx and .pdf copy) to support staff for each of the 50 tools/skills I surveyed.

    I would like to create custom 'packs' for staff based on their responses in the survey. i.e. if they entered unconfident for 20 of the tools/skills they will receive a pack that has the sheets only for those tools/skills.

    There's 800 staff in total so manually creating these packs is unlikely to be possible, so I'm interested to know if this is at all possible, or if it is a crazy idea.

    Your advice is much appreciated.

    Luke

    Cross posted: http://www.mrexcel.com/forum/excel-q...ml#post4194438
    Last edited by lukestkd; 06-24-2015 at 11:04 AM. Reason: added cross posting

+ 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. Running Word Mail Merge from Excel 2010 - Mail Merge workbook fails
    By pl05.lau@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-05-2015, 07:35 AM
  2. Mail merge to Word Document
    By Banaticus in forum Excel General
    Replies: 8
    Last Post: 08-08-2013, 04:28 AM
  3. [SOLVED] Mail Merge issue when using VBA to go from Word document to PDF
    By Max_Taylor in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-31-2012, 02:53 PM
  4. Replies: 2
    Last Post: 07-12-2012, 08:11 PM
  5. Print mail merge document
    By LisaPatch in forum Excel Programming / VBA / Macros
    Replies: 31
    Last Post: 10-31-2011, 09:54 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