View Single Post
  #4  
Old November 8th, 2005, 04:28 PM
Bill Foley
external usenet poster
 
Posts: n/a
Default Command button to email

As I said before, it depends on the e-mail program these folks are going to
be using! The following link has a snippet of code that sends a message
using Outlook. It obviously would need to be modified to get rid of the
attachment stuff and have variables added to capture the information you
want to send in the body of the message. At least it will give you a
starting place.

http://www.exceltip.com/st/Control_O...Excel/464.html

--
Bill Foley
www.pttinc.com
Microsoft PowerPoint MVP
Microsoft Office Specialist Master Instructor
"Kurgan" wrote in message
...
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.