[Graham Mayor]

You are welcome

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



L McDowell wrote:
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?