Re: How do I save data from a Word 2007 form with non-legacy contr
- From: L McDowell <LMcDowell@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 7 Oct 2009 07:09:02 -0700
Hi Graham,
Thank you for sticking with me on this. I have gone through the steps for
installing your macro in Word, including adding the module in Normal. One of
the problems I encountered was pasting the code into the module. There was a
section in red with a misplaced line break from the way it was pasted. When I
place the cursor in front of it and backspace, I get this error:
Compile error: Expected: end of statement
I haven't yet gotten to the point of trying the macro. Do you have
suggestions for how to deal with this error? Thanks again,
Laurie
"Graham Mayor" wrote:
The macro that I posted on the 10th, with further explanation how to both.
install it and use it should allow you to recover the data from your forms.
However if it does not work for you (and as all the returned forms will
probably have the same file name that may prove a problem) , send me a
completed form (with sample data) to the link on the home page of my web
site and I will see where the problem lies.
Though much of it may be over your head, see Processing Forms Received by
E-Mail at http://www.gmayor.com/ExtractDataFromForms.htm . That version is
aimed at legacy forms, but it can be altered to work with content controls,
if it interests you. It simply reads the attachments from the e-mail
messages in an Outlook folder and adds the field data to a comma delimited
file or Word table.
--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
L McDowell wrote:
Beth, thanks much for your suggestion. That is what I should have
done from the beginning. However, I already created my form in Word
and have been getting back completed forms. It never occurred to me
that I would not be able to retrieve the information entered into the
controls. I'm afraid I'm still stumped.
"Beth Melton" wrote:
This isn't a Word solution but if you have Access 2007 you can use
Collect via E-mail to generate an HTML form and send by e-mail and
collect your data directly in an Access table. The wizard will step
you through the process, send the e-mails, and you can elect to
update your Access table automatically upon receipt of the returned
emailed form. Note you need to use Outlook 2007 to send the and
receive the emailed forms but the recipients don't need to use
Outlook 2007.
~Beth Melton
Microsoft Office MVP
"L McDowell" <L McDowell@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C0D63670-C385-46DF-8013-A294F356EBD2@xxxxxxxxxxxxxxxx
I have tried checking the 'save form data as delimited text file'
box under
'preserve fidelity when sharing this document' but it doesn't work.
I gather
from web browsing that it only works for data collected with legacy
controls.
I am not a developer, so how else can I get the form input data
into a text
delimited file for use in Access or Excel?
- Follow-Ups:
- Re: How do I save data from a Word 2007 form with non-legacy contr
- From: Graham Mayor
- Re: How do I save data from a Word 2007 form with non-legacy contr
- Prev by Date: Unprotected Word Document is Changed?
- Next by Date: where do I find the reveal codes on the menu bar?
- Previous by thread: Unprotected Word Document is Changed?
- Next by thread: Re: How do I save data from a Word 2007 form with non-legacy contr
- Index(es):
Relevant Pages
|
Loading
