+ Reply to Thread
Results 1 to 2 of 2

Excel Spreadsheet used to autofill Word Document?

  1. #1
    Registered User
    Join Date
    09-19-2017
    Location
    Beverly Hills, CA
    MS-Off Ver
    excel 2016
    Posts
    2

    Excel Spreadsheet used to autofill Word Document?

    Hi Guys,

    Hoping there's an easy way to do this. I want to create a basic word document that will act as a template. I'm familiar with how to insert form fields and tie them to bookmarks which I assume is the easiest way to populate the data?

    In an excel spreadsheet, I'd like to go in, fill in the various data that will populate the word document, and then create a new word document with a unique file name based on the original word document that I'll use as my template.

    A simple example where I have something like the following would be very helpful as I've been struggling with this for a while:

    Word Document: MyTemplate.doc
    Form Text Input: No initial value w/ bookmark named clientCompany

    Excel Document: CreateWordDocument.xlsx
    Field A1: "Name of Word Document to be Created"
    Field A2: input name of word document to be created

    Field B1: "Company Name"
    Field B2: input the data to fill in the form field bookmarked by "clientCompany" in MyTemplate.doc

    Once all the various data has been populated in CreateWordDocument.xlsx - I assume I'd have to create a macro to run to populate the document and then save the file w/ a new file name reference in cell A2 of CreateWordDocument.xlsx. I could then tie the macro to a button added to the end of CreateWordDocument.xlsx to populate all fields w/ values other than NULL and name the document appropriately.

    Thanks for any help, this one's been a dozy for me to try to fix as I'm no VBA expert.

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,359

    Re: Excel Spreadsheet used to autofill Word Document?

    maybe this way:
    a workbook with two shheets data and form, you can save forms with needed data as pdf.
    all needed data can be put in form with just a VLOOKUP
    Attached Files Attached 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. [SOLVED] I am trying to print a word document from a Excel spreadsheet.
    By starlev in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-20-2015, 09:45 AM
  2. Can I link a word document and an excel spreadsheet
    By citadel-maritime in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 02-20-2013, 08:43 AM
  3. [SOLVED] How to convert Excel spreadsheet into a Word document!
    By Finnysgranny in forum Excel General
    Replies: 4
    Last Post: 05-31-2006, 06:35 PM
  4. [SOLVED] how do i add a word document into an excel spreadsheet?
    By G-Man in forum Excel General
    Replies: 1
    Last Post: 05-28-2006, 12:45 PM
  5. Changing a word document into an excel spreadsheet
    By aganchingco in forum Excel General
    Replies: 3
    Last Post: 01-04-2006, 08:14 PM
  6. can i convert a word document into an excel spreadsheet?
    By jodibaldwin in forum Excel General
    Replies: 1
    Last Post: 08-01-2005, 11:05 AM
  7. Replies: 0
    Last Post: 07-10-2005, 05:30 PM

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