Graham, I corrected the macro text and gave it a test run. It is miraculous
to me. Problems I'm having seem to do with how the users used the template
but the macro itself seems to work like a charm. I don't completely
understand it but I am very grateful. Thanks a million!
"Graham Mayor" wrote:
Which of the macros are you testing and what was the section in red? The
macros should paste directly from the web page into the macro editor without
unwanted line breaks.
--
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
L McDowell wrote:
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 wrote in
message ...
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?