|
|
|
|
#1
12-22-2017, 09:07 AM
|
|||
|
|||
Excel Data to Word Form Field
Hi!
I have a word doc with about a dozen form fields that I fill out, save as PDF, and send out to some clients. I copy/paste data from an excel spreadsheet to do this, which is tedious. Is there any excel macro to help me go from my excel data direct to a PDF without having to C/V to Word? Sorry I am new to learning VBA and don't even know where to start! Thank you. 
|
|
#3
12-28-2017, 10:46 AM
|
|||
|
|||
|
Mailmerge can definitely work. I was just wondering if there is a way to do it all via excel to avoid the extra steps of the word process.
|
|
#4
12-31-2017, 02:44 PM
|
||||
|
||||
|
Yes, it can be done via a macro, but that hardly makes it less complicated than a mailmerge - especially for an end-user who is unable to maintain the code when anything in the workbook or document changes.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word]
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Outlook 2013 Forms (how to questions)- Quick opening of a form file & Linking form's data to Excel | gamin2407 | Outlook | 0 | 01-21-2017 10:14 PM |
| Exporting multiple data sets from a single Word Form into Excel | Tom Saylor | Word VBA | 6 | 09-11-2016 05:22 AM |
| Populate Word Drop-down list with Excel column then auto fill form fields with Excel data | Faldinio | Word VBA | 7 | 10-19-2014 06:03 AM |
| Word 2010 Field widths from linked Excel data. | DPB | Word | 1 | 06-25-2014 09:31 PM |
| Print word form using excel data sheet | LS1015 | Office | 1 | 07-16-2012 08:16 PM |
Windows 10 
Office 2016
Hybrid Mode