Hello All,
I was wondering if I can get some assistance?
Task: Modify an email that is in a subfolder (Financial) under Drafts
There should be one ore more of the EXACT same draft emails in this directory
- If one does not exist, throw a msgbox and exit sub
Need to Change the To line and add an attachment to ONLY ONE of the draft emails
in this directory
Environment: Microsoft® Outlook® for Microsoft 365 MSO (Version 2308 Build 16.0.16731.20542) 64-bit
Outlook Account: [username]@[company].com
Request: go straight to the [username]@[company].com\Drafts\Financials folder and modify ONE of the draft emails
I have been skewering the net for code to modify Only one Draft email in the directory
but coming up empty. Everything seems to loop through the entire drafts directory
and modify/send all draft emails.
I have located the following on this message board, but each has it pros and cons.
I've tried modifications, but being relativity new to VBA, i am striking out
Is it possible to loop through a folder in Outlook using VBA?
Cons: Loops through EVERY folder until it matches the "SingleFolderRequired" variable which i did set
Modifies EVERY file in the Drafts\Financials directory
Pro: Eventually finds the correct directory (Drafts\Financials)
How to send All Draft in outlook by vba
Cons: sends EVERY file in the Drafts
Pro: Starts in the Drafts Folder and does not search/compare every single directory
I think, the following would start in the directory I am looking for
Set myDraftsFolder = myFolders("Mailbox - Your Name").Folders("Drafts").Folders("Financials")
Any assistance on modifications would greatly be appreciated
I was wondering if I can get some assistance?
Task: Modify an email that is in a subfolder (Financial) under Drafts
There should be one ore more of the EXACT same draft emails in this directory
- If one does not exist, throw a msgbox and exit sub
Need to Change the To line and add an attachment to ONLY ONE of the draft emails
in this directory
Environment: Microsoft® Outlook® for Microsoft 365 MSO (Version 2308 Build 16.0.16731.20542) 64-bit
Outlook Account: [username]@[company].com
Request: go straight to the [username]@[company].com\Drafts\Financials folder and modify ONE of the draft emails
I have been skewering the net for code to modify Only one Draft email in the directory
but coming up empty. Everything seems to loop through the entire drafts directory
and modify/send all draft emails.
I have located the following on this message board, but each has it pros and cons.
I've tried modifications, but being relativity new to VBA, i am striking out
Is it possible to loop through a folder in Outlook using VBA?
Cons: Loops through EVERY folder until it matches the "SingleFolderRequired" variable which i did set
Modifies EVERY file in the Drafts\Financials directory
Pro: Eventually finds the correct directory (Drafts\Financials)
How to send All Draft in outlook by vba
Cons: sends EVERY file in the Drafts
Pro: Starts in the Drafts Folder and does not search/compare every single directory
I think, the following would start in the directory I am looking for
Set myDraftsFolder = myFolders("Mailbox - Your Name").Folders("Drafts").Folders("Financials")
Any assistance on modifications would greatly be appreciated
