Data collection via email, via spreadsheets, not forms

K

kenjman

Hello,

I would like to collect responses via email to have them auto populate a table
but in the email that I send out, I want it to be in a spreadsheet form.
already know how to do this with the wizard in Access, but I do not want it t
have a separate box per customer and then sub fields to be filled out. I woul
rather have the customer name on the left side of a spreadsheet, and the th
fields that need to be filled out go across columns similar to an Exce
spreadsheet. Is this possible? The issue is that I will be sending out email
to employees where they will have 50+ customers, and 5 pieces of information t
fill out per customer. If that got sent out in the traditional "Collect an
Update data via E-mail" option, there would be a separate box for each of th
50+ customers, which would a pain to fill out. Having it in a spreadsheet t
scroll across would be much easier.

Everyone that I am working with will have InfoPath, Access, and Outlook, s
that will not be a problem.

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top