Re: Run a macro in PowerPoint with Action Settings

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



That makes sense. I'll need to modify the code abit. How about getting the
app to close after the email marco runs? That way the user can click the
'yes' to allow outlook to send the email.

any suggestions on code?

Jo

Public Sub SendMail(ByVal mail_to As String, Optional ByVal _
mail_cc As String = "", Optional ByVal mail_bcc As _
String = "", Optional ByVal mail_subject As String, _
Optional ByVal mail_body As String = "")
Dim strParameters As String
Dim strCommand As String

' Compose the parameters.
If Len(mail_cc) Then strParameters = strParameters & _
"&CC=" & ReplaceSpecialCharacters(mail_cc)
If Len(mail_bcc) Then strParameters = strParameters & _
"&BCC=" & ReplaceSpecialCharacters(mail_bcc)
If Len(mail_subject) Then strParameters = strParameters _
& "&Subject=" & _
ReplaceSpecialCharacters(mail_subject)
If Len(mail_body) Then strParameters = strParameters & _
"&Body=" & ReplaceSpecialCharacters(mail_body)

' If the parameters aren't blank,
' replace the initial & with ?.
If Len(strParameters) Then Mid(strParameters, 1, 1) = _
"?"

' Add the basic mailto command.
strCommand = "mailto:"; & mail_to & strParameters

' Send this to ShellExecute.
ShellExecute Me.hwnd, "open", strCommand, _
vbNullString, vbNullString, SW_SHOWNORMAL
End Sub

"Steve Rindsberg" <abuse@xxxxxxxxxxxxx> wrote in message
news:VA.00002815.56e4a896@xxxxxxxxxxxxxxxx
In article <S9ing.56209$Lm5.14310@xxxxxxxxxxxxxxxxxxxxxxxxxx>, Mr . .
wrote:
What is the difference between VB code for a macro that runs in a .ppt
and a
powerpoint show?

Macros I record in Normal/Slide view don't work in Slide Show
http://www.rdpslides.com/pptfaq/FAQ00159.htm



I have similar issue with action setttings not triggering the macro.
Jo
"John Wilson" <codepeople AT aol DOT com> wrote in message
news:1B3F149F-83EC-4690-875A-EDDEEEFDDB4B@xxxxxxxxxxxxxxxx
Almost certainly you have written / recorded a macro that wont run in
slide
show mode (The object model is quite different)

Either post up your macro code or what you want to achieve.
--
-----------------------------------------
Did that answer the question / help?
_____________________________
John Wilson
Microsoft Certified Office Specialist



"JohnTeacher" wrote:

I cannot get the macros to run in a PowerPoint 2002 slideshow using
the
Action Settings options for Mouse Click, even after I have changed
the
Security to Medium or Low. The macros do run from the Tools menu,
but
now
within the Slideshow. (The Run program, and Hyperlink to, etc.
work,
but not
the macros). Please help. I need this soon. Thanks


-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================




.