Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Working with Outlook
Resolved · Low Priority · Version 2003
Catrin has attended:
Excel VBA Advanced course
Is it possible to specify the sender of the email (i.e. if you have access to more than one mailbox in Outlook)?
It might be something like:
mailitem.from = ....
(To do this manually you would click on "Options" (within the message in Outlook) and select "From")
Thank you,
Catrin
Hi Catrin
Thank you for you question.
I have some code that will accomplish this, and I am in the process of testing it to ensure there are no issues with its use. I will post it here sometime in the next day or so
Regards
Stephen
|
Excel tip:Navigate with keyboard without losing your active cellIf you like using your keyboard to scroll through your excel document, but want to keep your active cell the same, use the scroll lock, and then use your arrow keys to navigate around the document. |
We'll call during UK business hours
Server loaded in 0.07 secs.