Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #16  
Old 01-24-2016, 04:25 AM
gmayor's Avatar
gmayor gmayor is offline Auto-forward HTML emails with added suffix to subject line Windows 10 Auto-forward HTML emails with added suffix to subject line Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

The existing code is
Code:
With olOutMail
  .Subject = .Subject & strSubject
  .To = strAddr
  .Send
End With
Add the CC line as follows:
Code:
With olOutMail
  .Subject = .Subject & strSubject
  .To = strAddr
  .CC = "someone@somewhere.com" 'The address of the CC recipient
  .Send
End With
It will not need re-signing. It is the project that is signed, not the macros it contains.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #17  
Old 01-24-2016, 04:34 AM
paulkaye paulkaye is offline Auto-forward HTML emails with added suffix to subject line Windows 7 64bit Auto-forward HTML emails with added suffix to subject line Office 2007
Advanced Beginner
Auto-forward HTML emails with added suffix to subject line
 
Join Date: Nov 2011
Posts: 84
paulkaye is on a distinguished road
Default

Thank you - works perfectly!
(I'd thought to try that, but was put off because for the "TO" field you used strAddr, and defined the actual email address elsewhere. If you have a minute, and feel like explaining, is there a reason that you did that originally and didn't do that for the CC field just now?)
Reply With Quote
  #18  
Old 01-24-2016, 10:21 PM
gmayor's Avatar
gmayor gmayor is offline Auto-forward HTML emails with added suffix to subject line Windows 10 Auto-forward HTML emails with added suffix to subject line Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

You can do it either way. You could equally have created another string Constant e.g.
Const strCC as String = "someone@somewhere.com"
and used .CC = strCC
The result would be the same.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #19  
Old 01-24-2016, 11:42 PM
paulkaye paulkaye is offline Auto-forward HTML emails with added suffix to subject line Windows 7 64bit Auto-forward HTML emails with added suffix to subject line Office 2007
Advanced Beginner
Auto-forward HTML emails with added suffix to subject line
 
Join Date: Nov 2011
Posts: 84
paulkaye is on a distinguished road
Default

Thanks, Graham!
Reply With Quote
Reply

Tags
autoforward, edit subject

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto-forward HTML emails with added suffix to subject line Outlook 2013 Auto Forward / Auto Redirect emails not working katm3 Outlook 4 08-07-2015 01:50 AM
Need to forward subject alone of mails abhikulsh Outlook 1 08-28-2013 10:47 AM
Forward emails not opening, why? alexb123 Outlook 0 10-19-2012 02:22 PM
Auto Subject Line hollwall Outlook 0 04-19-2012 08:49 AM
Auto Forward Emails - Specific Time Periods Only Dav Outlook 0 06-22-2011 12:03 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:41 PM.


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