Re: Run a macro in PowerPoint with Action Settings
- From: "Mr . ." <deleteme@xxxxxxx>
- Date: Sun, 25 Jun 2006 13:26:50 GMT
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:
and aWhat is the difference between VB code for a macro that runs in a .ppt
thepowerpoint 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 inslide
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
theAction Settings options for Mouse Click, even after I have changed
butSecurity to Medium or Low. The macros do run from the Tools menu,
work,now
within the Slideshow. (The Run program, and Hyperlink to, etc.
but not
the macros). Please help. I need this soon. Thanks
-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
.
- Follow-Ups:
- Re: Run a macro in PowerPoint with Action Settings
- From: Steve Rindsberg
- Re: Run a macro in PowerPoint with Action Settings
- References:
- Re: Run a macro in PowerPoint with Action Settings
- From: Mr . .
- Re: Run a macro in PowerPoint with Action Settings
- From: Steve Rindsberg
- Re: Run a macro in PowerPoint with Action Settings
- Prev by Date: Re: Powerpoint slide and sound as desktop wallpaper
- Next by Date: Re: Very slow text entry in PowerPoint 2007 beta
- Previous by thread: Re: Run a macro in PowerPoint with Action Settings
- Next by thread: Re: Run a macro in PowerPoint with Action Settings
- Index(es):