Outlook for Mac inserts signatures at the very end of an email chain
Hi community, This seems to be a new issue caused by an Outlook for Mac update in recent months. When reply to an email, the default signature is inserted to the very end of an email chain instead of the end of the reply one is about to draft (in other words, above the attribution "On <data>, <name> wrote ..."). I can currently work around this issue by enabling "when replying or forwarding, use the format of the original message" (under Settings -> Email -> Composing). This seems to be a bug.Rack of Lambda
There’s been a lot of content shared recently to commemorate the upcoming 40th anniversary of Microsoft Excel. Personally, I’ve only been using Excel for around half that time, but October also marks my 2-year anniversary since "joining the conversation" on this forum. As a gift from me to you (anyone interested), I’ve spent some time over the past few weeks revisiting old posts, updating methods I shared previously and packaging them into a collection of generalized Lambda functions to assist with a variety of common array manipulation and transformation scenarios. The attached file contains some 35+ Lambda functions, ranging from very simple concepts to much more advanced techniques. You can also import them directly from my gist, if desired. While they were all compiled and composed of my own accord, I would be remiss if I failed to credit the community and its members as a major resource in my own development. The amount of knowledge, tips and tricks gained through community collaboration is simply invaluable. You may notice some recurring themes in the way I’ve written many of the functions. For example, I like to keep the optional arguments as simple as possible, using either Boolean values passed to IF, or numeric options from 0 to 3 passed to CHOOSE. Also, many of the array transformation functions use TOCOL-IF-SEQUENCE in one way or another, with MOD-QUOTIENT-SEQUENCE used only a few times in the more complex algorithms (e.g. HWRAP and VWRAP). The collection also includes a few examples of Lambda recursion, the most notable being PF (Prime Factorization). CROSSJOINM was written as a "how-to" demonstration for filtering multiple optional arguments using LAMBDA and NOT-ISOMITTED. There’re also some powerful scanning functions like SCAN3, which can handle multiple input arrays, as well as EVALS with VALS2 to VALS7, which can store and recall multiple variables at each iteration (useful for corkscrew calculations). What you won’t find, however, are methods that use INDEX in an iterative manner with functions like MAKEARRAY, SCAN, etc. as these are only efficient when iterating over a range reference (they will bog down considerably and become practically unusable after just a few thousand iterations when looping over an array object). As such, I don’t recommend them as "generalized" solutions, although they can be very effective on a case-by-case basis. Similarly, you will only find 2 examples in this collection that use REDUCE-STACK in a limited capacity, with fewer than 10 iterations, as I also consider this to be a method of last resort due to its problems with efficiency when the number of iterations cannot be controlled. Hopefully one or two of them proves useful. If not, no big deal. Many of the examples in the attached file are interactive, so you can see how the different options affect the output. For those brave enough, please feel free to share your own custom functions too. I’d love to see what you got. Cheers! REV_2025-10-16: updated function definitions for SCANBYROW and SCANBYCOL to be able to handle TYPE 16 and TYPE 128 values.
Support for auto-filing sent emails
I am looking for a solution to this scenario in the New Outlook: I send tens of emails per day The sent emails are stored in the Sent Items folder I need to manually move each of them into the sub-folders in my Archive folder - e.g. one for support cases Is there any way to automate the step (3) - i.e. to automatically file the sent emails into the folders they belong to? The Classic Outlook had "When replying to a message that is not in the Inbox, save the reply in the same folder" which is not present in the New Outlook. Maybe the New Outlook should have something even more powerful? In addition to this feature, a button suggesting into which folder each message should be filed? Finally, the Outlook Rules are very powerful but they do not apply to the sent emails. Maybe time to generalize these?
Why would a hacker/scammer put a domain INTO my exchange online admin?
OK so this is a weird one. I've been doing this a fairly long time but I'm not a full time exchange admin. I help my clients with exchange online often, but I'm a local IT pro, doing all sorts of screwdriver and software work, not just exchange. So maybe this isn't as bizarre as I think it is, but let's see. My client stopped receiving email 2 days ago. Alerted me to it yesterday. They don't know their password but no devices are asking for passwords, so I suspect it's not a password issue. I get logged into my admin and reset their password so we can get into their account. Suddenly they start getting asked for PW on phone and outlook, so we know that the password hadn't been changed prior. I get into account and see new rules sending all emails into archive and trash. So that explains that. So someone broke into the account with the correct password. Easily enough explained. Though weird that it would happen if the user didn't know their own password. So, one question is how did the scammer get into the account. I have looked at the login logs but I don't know what to sort/filter by to really find out anything helpful. Any ideas? So I got into the account and upon resetting his password he is forced to enable MFA. So that's done. I'm in the admin and what do I find? Two NEW domains in the settings. They are set up for exchange online. No users though. Not only that but I can't REMOVE the domains that aren't mine. I get this error when trying to remove it: "The domain coburnsfleetservices.com can't be removed at this time because it was purchased from Microsoft 365. It can only be used with your current Microsoft 365 account. You can remove it from the account once the subscription expires or is canceled." Also, in the emails missed in the past 48 hours we got one that said this: "A verified domain was added to your Avenue A Realty Advisors LLC account If this domain wasn't added by an admin in your organization, credentials might have been compromised and we suggest reviewing your password and multifactor authentication settings." I searched online and found contact info for one of the stolen/given domains. Called them and they said they had been hijacked 2 weeks ago, and their email used to send out payment requests to thousands of email addresses. Thought they had it solved a few days ago and it had been silent. Now this. So a second thing I'd like to find out is when exactly those domains were put into my exchange online account. Can I find that info from the logs? Additionally, WHY would someone move unrelated domains into my account? Maybe is the assumption that that happened before 2 weeks ago when that company's domain had been used to send out mass mail? Doesn't seem possible, because that company would have figured out that they no longer controlled their own domain and they couldn't have gotten control of the account again. Or...? I don't know. But while I've seen users tricked into giving out their passwords dozens of times, and their email used to try to solicit money from vendors, I've never seen another domain slipped in. Any ideas? And suggestions how to search the logs to get to the bottom of the missing puzzle pieces? Thanks for any leads!Excel desktop application crashes when trying to share or copy link
For the last couple of weeks when I've attempted to share an Excel file from the desktop app (multiple different files) the application crashed and closes out. The file are all saved to my personal OneDrive. It only seems to affect the files from my SharePoint, and only when trying to share through the desktop app. I can open it on the web version and share. I tried sharing a file that was opened through a SharePoint site and it seemed to work.
How to stop MS Word from saving doc and pdf files to the cloud
I'm on Windows 10 and Office 365. When I hit F12 on an MS Word file and save it as a .docx file or a .pdf file in a OneDrive folder: (1) the file does not immediately appear in the folder. (2) when it does appear, after more than 5 minutes later, it's on the cloud and it has be downloaded. (3) saving has become a lot slower. I'm not sure when I first noticed this but it has been a while. I've gone to File > Options > Save > Unchecked "Show additional places for saving, even if sign-in may be required". How do I prevent that? It slows everything down.
