Creating fields in a document that can be imported by Excel

[brucemc777]

I'm glad the board stresses that a long title is preferred as I was anguishing over how to say that...

I have a document that I created some time ago and I used after-line spacing to make it appear correctly, expecting it to simply be printed out and filled in on paper.

Now they want it to be able to be filled in on a computer. Further, they want it to be able to be able to have it's fill-in fields - exportable into / importable by - Excel. Because of the way I created the spacing I believe I almost have to treat the "form" as a graphic and overlay fields or textboxes. Either that or re-create the dang form, which I would rather avoid.

Can anyone steer me to an example of how best to accomplish this? I am fairly good with Excel and write VBA, but when it comes to Word I am fairly lame!

Thank-you-

[macropod]

If you want to fill in a form from an Excel data source, the simplest way would be to set it up for a mailmerge, with mergefields for the data. See:
https://support.office.com/en-us/art...D-E3C7D30C954A
https://support.office.com/en-us/art...F-932C49474705
http://word.mvps.org/FAQs/MailMerge/...AMailMerge.htm

[Charles Kenyon]

First, I might well recommend recreating the dang form. In the long run it will probably save you time. If you use a legacy form (Word 2003 and earlier controls) you can use the information here:

• Introduction to Importing Form Field Data from Word to Excel
• Extracting Word Form Data
• How to Automatically Export Form Data from Word to Excel

[brucemc777]

Thank-you folks, I'll get to hammering on this.

Afraid a new install of Outlook transported the message to the junk folder and I just caught it!

[gmayor]

See also http://www.gmayor.com/ExtractDataFromForms.htm