Outlook/VBA/VSTO: How can I set the folder to store e-mail after being sent?
I created an automation script that's creating e-mails from a template e-mail file (.oft) and saving them to the Drafts folder for me to eventually send them manually.
In Outlook I set an option to store files in the same folder on reply/forward:
Apparently, when I originally created the template e-mail file from an e-mail stored in a folder, that folder location was stored along with the template. This is very nifty, because now, after sending the e-mails I created from the template, these are stored in that original folder location.
This brings the following question to my mind:
Can I set this folder location in VBA when creating an e-mail message from the template, so I can programatically determine where to store an e-mail after it has been manually sent?
Of course - set MailItem.SaveSentMessageFolder property. See https://learn.microsoft.com/en-us/office/vba/api/outlook.mailitem.savesentmessagefolder
- Insert a new record into an Access 2007 database
- Return To property of item declared as Object
- Send email to newly assigned resource
- VBA + Excel + Try Catch
- Deleting named objects in a Powerpoint presentation
- Detect when a change occurs on in an MS project file and log the change in an Excel file
- How to remove everything EXCEPT first color/size out of list of attributes?
- Why would application.reminder stop working after a restart?
- Incorrect value from expression result variable declared as Long
- Problems in VBA with Bloomberg function on a LOOP
- Class not registered VBA excel
- Change a macro to use late bindings - Excel vba to create Word Table
- Runtime error -2147467259 during PDF generation
- Excel VBA function to print an array to the workbook
- How do I copy/paste Interior Colors only in Excel?
- Any way to get the real last row not affected by autofilter? Without altering current autofilter status, using UsedRange nor looping cells from bottom
- Auto align data of an Excel table
- How to set MailItem.SendUsingAccount when sending an email?
- How to know which CATIA component is in the current edit mode
- In Catia Moving Parts or Products with Macro
- Excel macro to highlight all cells that match value in current cell
- How do I apply conditional formatting in vba?
- Can you display a SQL Server Image datatype column in Excel?
- Pass a MS Access form date to Oracle via a Pass-Through Query
- Excel: macro to export worksheet as CSV file without leaving my current Excel sheet
- Workbook.UpdateFromFile stops runtime
- Append to Text File VBA
- Application.OnTime Delays When There Is No User Interaction (Even if Excel Is Active)
- Using Excel VBA (Name statement) to change file extension from .txt to .csv, getting Run-time error '75': Path/File access error
- Put a user form directly on the excel sheet