A2010: Data Collection makes and Ugly Email Form!

[BrianDP]

I think that pretty well sums up my thoughts..

I've been asked to do an Email data collection, and low and behold
Access has just the Wizard to do it! Whoopie! Just with most of the
Microsoft Wizards, one size fits all, and, if it does what you want
great! If not, tough luck.

That being said, I've looked at editing the email once it gets into
Outlook, but it seems like if I make very many changes at all- It
comes up with a message like "The form is corrupt, or has been
edited." Well heck yeah it was edited! Most people don't type City,
State, and Zip into three lines that are the width of the screen!
Lines where there is only one field, that is pretty straight forward.
It looks like it's just a table, with a tag, and some data. Tag,
data, tag, data, and so fourth. When I did monkey with the form a
little bit, and indeed put City State and Zip on line line, it
crammed
all the data into the first field, City, and left state and zip
blank. I suppose that might be a key to doing this, just go ahead
and
have it stuff all the "Multi-field" lines into one field, and parse
the data out of that field after the data gets back in my database.
But, in practice when I try to do that for other lines, it just gets
corrupted.

Does anyone know the ins and outs of this data collection thing? Can
I bend it to make a half way decent looking form collecton page?
Maybe someone knows of a better idea or way to collect this data.
Using the web isn't really an option here - that is a web page proper
with a SQL back end, blah blah.. All I want is just the one form with
maybe 15 fields on it. Just contact information + shoe size and hat
size..

Thanks in advance.

-Brian