Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-01-2016, 10:35 AM
HyperEscape HyperEscape is offline Email Selected Slides - VBA or Macro Windows 7 32bit Email Selected Slides - VBA or Macro Office 2016
Novice
Email Selected Slides - VBA or Macro
 
Join Date: Nov 2016
Posts: 1
HyperEscape is on a distinguished road
Default Email Selected Slides - VBA or Macro

Hello,

I need to often email selected slides to different stakeholders for their review. My current crude method is to copy the selected slides to a new file (and save it by a different name) and then attach it to the email.

Would appreciate if any experts over here share their wiz for making a feature which can support the following use case

1. Select multiple (non consecutive) slides by Ctrl+Click.


2. Via Right Click menu (or by invoking a macro), be able to choose the option or run the function to send the selected slides via email.
3. Once the option is chosen a smaller ppt file with only the selected slides (possibly with an automatic name <<original name+suffix>>) is created in the folder of the original file .
4. When the file is created it is automatically sent to Outlook, with a new email opened with the attachment.

I saw a semi-working VBA code somewhere, which I am not able to find anymore, hence I thought of asking the community members here.

Pretty sure a solution like this would be for the larger benefit of anyone having similar requirements.

Thanks for your support.
Reply With Quote
  #2  
Old 12-01-2016, 01:00 PM
JohnWilson JohnWilson is offline Email Selected Slides - VBA or Macro Windows 7 64bit Email Selected Slides - VBA or Macro Office 2010 32bit
Programmer
 
Join Date: Nov 2008
Location: UK
Posts: 1,912
JohnWilson has a spectacular aura aboutJohnWilson has a spectacular aura about
Default

You might be able to adapt my code here to send all selected slides
http://www.vbaexpress.com/forum/show...ook-attachment
__________________
Microsoft PowerPoint MVP 2007-2023
Free Advanced PowerPoint Tips and Tutorials
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Email Selected Slides - VBA or Macro Macro to run when a checkbox is selected cryder Word VBA 9 01-10-2016 09:29 AM
Outlook VBA to move selected email to a public folder aaroncrt Outlook 2 10-21-2013 05:11 PM
Email Selected Slides - VBA or Macro Email Selected Slides purplelily PowerPoint 1 08-28-2011 12:55 AM
Selected text and logo in one macro marijke Word VBA 0 08-24-2009 07:01 AM
Help with a macro to shade a selected pie chart hzrvkt Excel 0 02-24-2006 01:25 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:15 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft