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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 |