Function F4 in Excel for Mac OSX. If you are an avid Microsoft Excel user and need to use ‘Absolute Cell References’ functionality in MS Excel on a Mac computer, then you will find that Fn+F4 key combination doesn’t work on OSX like it worked on Windows. The keyboard shortcut equivalent for Excel Absolute Reference in Mac is ‘Command + t’ or ‘⌘+t’. F4 function in excel for mac.

Microsoft Outlook for the Mac is integrated with OS/X spotlight search so that AppleScript and Spotlight can be used to create Outlook Smart Mail folders. Smart Folders are more like views into mailboxes than actual mailboxes. They are virtual folders that are created from the results of a search. 1 These identifiers are used for Office 2019 for Mac, either a retail or a volume licensed version, and for Office for Mac (from an Office 365 plan) running on macOS version 10.12 (Sierra) or higher. 2 These identifiers are used for Office 2016 for Mac, either a retail or a volume licensed version, and for Office for Mac (from an Office 365 plan) running on macOS version 10.11 (El Capitan) or earlier.

Outlook for Mac Signatures.scpt is an AppleScript that helps Mac SysAdmins with automating deployment of an HTML Mail Signature to Outlook for Mac 2016.

Unfortunately we still can't perform a Central Push with this script, however using a Management tool to distribute the Mac Signature Tool, one can simplify the process significantly and hopefully get the end-user to do the work.

##Changing the HTMLThe Base HTML in the first version of this script is what is currently used in my environment. Soon to be generalised.When you modify the HTML in the script, you need to be aware of the variable hooks at the beginning of the script.

##Variable HookslogoSource should point to a public facing web resource for your signature logo file
logoHeight (optional) is an integer value for the pixel height of your logo. Used with inline CSS to format your logo
logoWidth (optional) as above is an integer value for inline CSS formatting of your logo
phonePrefix phone Number Prefix. Script places content of AD Attribute ipPhone in signature. This adds any Prefix strings so it looks like a normal phone Number. Can just be added to HTML
All other variable hooks are commented adequately within the script at this time.All hooks are optional but useful.When using these hooks to abstract your HTML (especially where there are multiple possible addresses/campuses) you will need to escape the HTML and insert the hooke.g.

<TD style='COLOR: #766a65; PADDING-LEFT: 12px'><FONT style='FONT-SIZE: 8pt' face=Arial>' & campusAddress & '</FONT></TD></TR>
The trick here is the ' & campusAddress & ' section

##Pulling Attributes from Active DirectoryThe script requires the device be bound to Active Directory to work. It leverages DSCL to pull the variables from relevant attributes in the Directory Service.Your Environment will likely be very different from mine, during development of the script, I found piping the output of dscl to a txt file very helpful for working out what attributes I needed.e.g. dscl '/Active Directory/<DOMAIN>/All Domains' -read /Users/<username> >> ~/Desktop/dscldump.txt'Where <DOMAIN> is your domain, and <username> is a valid username in your Directory Service.

Packaging

In my environment, This script gets exported from Script Editor as an Application Bundle and then packaged into an installer using JAMF Composer. The installer places the .app bundle into /Applications/Utilities/

The Microsoft Mac applications each have AppleScript scripting dictionary support that you can review from the Script Editor : File menu : Open Dictionary… (e.g. MS Word). This is the syntax that you have to adhere in order to make AppleScript work with these applications. Using a web search, you can specify AppleScript Word table, and the top return is how to duplicate a table in MS Word with AppleScript. This Google search will also provide many other links to programming Word with AppleScript.

The Microsoft Office applications also have additional Automator actions that give you the opportunity to build Automator workflows that might be tough to do with AppleScript alone.

MacScripter is a wellspring of AppleScript information from learning, to actual code in their Code exchange. You just need to understand that AppleScript is continuously evolving, and some MacScripter posts may be sufficiently dated that they may not work with current AppleScript frameworks — without some syntax updates.

I also use MacScripter (or AppleScript) interchangeably in a Safari browser search: MacScripter date time

Aug 2, 2016 3:28 PM