Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-10-2021, 06:58 AM
gmayor's Avatar
gmayor gmayor is offline VBA to change 'From' on drafts Windows 10 VBA to change 'From' on drafts Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,144
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 ofgmayor has much to be proud of
Default


You should delete it and the rest of the condition i.e.
Code:
                Else
                    xSelection.Item(i).Save
                End If
if you want it to process all the items. At present it just processes one item and saves all the rest. I suspect I would also want to remove the line
Code:
xSelection.Item(i).Delete
so that if the code does not do what you require, you won't lose the messages.
__________________
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
  #2  
Old 02-10-2021, 07:01 AM
JamesWood JamesWood is offline VBA to change 'From' on drafts Windows 10 VBA to change 'From' on drafts Office 2019
Advanced Beginner
VBA to change 'From' on drafts
 
Join Date: Nov 2020
Posts: 37
JamesWood is on a distinguished road
Smile

What a legend!!!! That's worked, incredible. I've left the Delete bit so that it removes the original draft file. But yes, that's perfect! Thank you sooooo much, you're a life saver. Have a wonderful week!
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Outlook rule to move emails from drafts into a draft subfolder gazmoz17 Outlook 0 10-03-2019 06:34 AM
word 2016 won't change to drafts for default view infonutt Word 0 07-21-2017 10:31 AM
VBA to change 'From' on drafts My draft message gets deleted from drafts when I send it? Bansaw Outlook 2 07-28-2011 08:45 AM
autosaving drafts with digital signature in outlook 2010 lvovich Outlook 0 04-11-2011 12:40 AM
Sent Items in Saved in Drafts trish@25by7.com Outlook 1 11-05-2010 02:33 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:25 PM.


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