Thanks Bill,

Does anyone have any VBA to save the values of radio buttons and a text box
then email it?


TIA,

Kurgan

"Bill Foley" wrote:

It certainly can be done any number of ways. However, with stricter
securities on Outlook it can be a pain to accomplish. Here are some ways
(some of which I have not tried because my coding knowledge is still
somewhat limited):

1. Save the entire presentation, and send it as an attachment (not preferred
because some of your files might be quite large).

2. Save just the specific slide as a new presentation and send that file as
an attachment (smaller file size but more coding required).

3. Save the data as variables and send those variables in the body of the
message (the method I prefer because it doesn't require any attachments).

However, keep in mind that when trying to use a system like this you must
consider the program these folks are using for e-mailing. For example, you
can't access the Object Model of Outlook Express to automate it like you can
Outlook. The code to use Outlook varies quite extensively from something
like Lotus Notes. You can also use more generic code (MAPI), but might be
limited on what you can do with it (not sure since I normally focus on
Outlook.

Of course, if this is something done within your own company (where all
folks have access to a common network server), you could also use the method
I prefer over e-mailing and that is to send the data to an Access database
automatically. That way you have records of all data acquired.

I do have a sample CBT download at the below site to see how I use VBA
within PowerPoint. Holler back with some more specifics and I'm sure one
(or more) of these VBA savvy folks will provide additional support.

http://www.pttinc.com/cbt_development.html

--
Bill Foley
www.pttinc.com
Microsoft PowerPoint MVP
Microsoft Office Specialist Master Instructor
"Kurgan" wrote in message
...
Hi,

I'm trying to create a feedback questionnaire in my presentation. I'm
using
a table with questions and radio buttons for responses.

Is there a way to have a comman button email the table to me once the user
clicks on it?

Thanks,

Kurgan.