A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Powerpoint, Publisher and Visio » Powerpoint
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Commabd button to email



 
 
Thread Tools Display Modes
  #1  
Old November 8th, 2005, 11:54 AM
Kurgan
external usenet poster
 
Posts: n/a
Default Commabd button to email

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.
  #2  
Old November 8th, 2005, 01:26 PM
Bill Foley
external usenet poster
 
Posts: n/a
Default Commabd button to email

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.



  #3  
Old November 8th, 2005, 04:31 PM
Kurgan
external usenet poster
 
Posts: n/a
Default Command button to email

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.




  #4  
Old November 8th, 2005, 05: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.






 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
SendTo creates an email but the SEND button does not work. Julian General Discussion 0 October 12th, 2005 01:50 AM
Email button does not appear in Word standard toolbar pd General Discussion 0 September 21st, 2005 08:36 PM
There is no "send", forward, or reply button on my email. Why? mbone Installation & Setup 2 June 24th, 2005 05:23 PM
How do I limit email to clicking send/receive button in Outlook Judelle Installation & Setup 1 June 23rd, 2005 11:58 AM
Canon LiDE 30 Flatbed Scanner email button... R. Beers Installation & Setup 2 May 30th, 2004 02:36 AM


All times are GMT +1. The time now is 10:02 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.