If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
creating a word table that can be filled in on email
I want to create a small table of about 10 items then send it out in email so
that the responders could type in their information on the table and send back to me. Any ideas how to format the table so that would work? Also, I would like the information that is received back to be able to be exported into an Access database that I will create with the same fields. Hope someone can help; thanks! |
#2
|
|||
|
|||
creating a word table that can be filled in on email
Insert formfields into the cells of the table where you want the recipient
to enter their information, protect the document for forms and then email it as an attachment. On receipt, open the attachment and use the Save Data Only for Forms option in Word. The process of getting the data into Access can be automated with VBA. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "detobias" wrote in message ... I want to create a small table of about 10 items then send it out in email so that the responders could type in their information on the table and send back to me. Any ideas how to format the table so that would work? Also, I would like the information that is received back to be able to be exported into an Access database that I will create with the same fields. Hope someone can help; thanks! |
#3
|
|||
|
|||
creating a word table that can be filled in on email
Thanks Doug, but I was hoping NOT to have to use an attachment. I am
reluctant because many of the folks who I hope will respond may have difficulties with an attachment. Any way to have it NOT be an attachment? I will try your method to see if it would work not as an attachment. Dianne "Doug Robbins - Word MVP" wrote: Insert formfields into the cells of the table where you want the recipient to enter their information, protect the document for forms and then email it as an attachment. On receipt, open the attachment and use the Save Data Only for Forms option in Word. The process of getting the data into Access can be automated with VBA. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "detobias" wrote in message ... I want to create a small table of about 10 items then send it out in email so that the responders could type in their information on the table and send back to me. Any ideas how to format the table so that would work? Also, I would like the information that is received back to be able to be exported into an Access database that I will create with the same fields. Hope someone can help; thanks! |
#4
|
|||
|
|||
creating a word table that can be filled in on email
You have no control over how a recipient views e-mail messages. If the
recipient has e-mail view set to plain text then any formatting in the document would be lost. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org detobias wrote: Thanks Doug, but I was hoping NOT to have to use an attachment. I am reluctant because many of the folks who I hope will respond may have difficulties with an attachment. Any way to have it NOT be an attachment? I will try your method to see if it would work not as an attachment. Dianne "Doug Robbins - Word MVP" wrote: Insert formfields into the cells of the table where you want the recipient to enter their information, protect the document for forms and then email it as an attachment. On receipt, open the attachment and use the Save Data Only for Forms option in Word. The process of getting the data into Access can be automated with VBA. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "detobias" wrote in message ... I want to create a small table of about 10 items then send it out in email so that the responders could type in their information on the table and send back to me. Any ideas how to format the table so that would work? Also, I would like the information that is received back to be able to be exported into an Access database that I will create with the same fields. Hope someone can help; thanks! |
Thread Tools | |
Display Modes | |
|
|