- XLOOKUP function - Microsoft Support
For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID With XLOOKUP, you can look in one column for a search term, and return a result from the same row in another column, regardless of which side the return column is on
- Turn on automatic forwarding in Outlook - Microsoft Support
For classic Outlook, on the ribbon, select the Home tab, then in the More commands section, select Rules > Manage Rules Alerts If you have more than one email account set up, on the Email Rules tab, ensure that Apply changes to this folder is set to the email address you want to start from Otherwise, go to the next step Select New Rule Under Start from a blank rule, select Apply rule on
- Add or manage an iCloud email account in Outlook
On Sync your iCloud account, select Continue If prompted, enter your password However, if you have two-factor authentication set up, you might see a window asking you to Create an app-specific password To obtain an app-password, do the following: Go to the Apple ID website in a web browser and enter your Apple ID and password
- Schedule an out of office status in Microsoft Teams
Set up an out of office status and message to let your teammates know you're not working or on vacation When teammates send you a chat message, they'll see your out of office reply and know you're unavailable Your out of office status will also sync with automatic replies in your Outlook calendar There are two ways to schedule your out of office status and message in Teams Schedule an out
- Create an email message template - Microsoft Support
Use email templates to send messages that include information that infrequently changes from message to message Compose and save a message as a template and then reuse it when you want it New information can be added before the template is sent as an email message
- Send automatic replies (out of office) from Outlook
Otherwise, you'll need to turn off automatic replies manually Note: If you don't see Automatic Replies, use Rules and Alerts to set up your out-of-office message On the Inside My Organization tab, type the response that you want to send to teammates or colleagues while you are out of the office
- Change the default font or text color for email messages in Outlook . . .
Change the default font for email messages that you send, or use a different font for messages that you forward or reply to
- Delay or schedule sending email messages in Outlook
Note: If the steps under this New Outlook tab don't work, you may not be using new Outlook for Windows yet Select the Classic Outlook tab and follow those steps instead
|