working outlook

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Working with Outlook

Working with Outlook

resolvedResolved · Low Priority · Version 2003

Catrin has attended:
Excel VBA Advanced course

Working with Outlook

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

RE: Working with Outlook

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

RE: Working with Outlook

Thank you.

Catrin


 

Excel tip:

Navigate with keyboard without losing your active cell

If 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.

View all Excel hints and tips


Server loaded in 0.07 secs.