If I am replying to an email in Folder "TEST", how do I get a reply to automatically go to the Folder "TEST" as opposed to the Sent folder? This helps with productivity so that I don't have to move the responses to the folders they are in. If the message responding to resides in the inbox, the response will go to the Sent folder and can be moved to another folder at another time.

I'm looking for suggestions as to the cause / solution to a spinning beachball every time I try and copy/paste in Excel. This happens more on some spreadsheets, but is happening in one I use frequently which is only 700 KB. I am using **Office 365**, and my MBP (Mac Book Pro) is 2018 (2.6 GHz i7, 32 GB RAM), running Catalina. It does however seem independent of device, as I recreated it on my partners MacBook Air (2011, 2.0 GHz i7, 8 GB RAM) running High Sierra. The desired file is stored locally but mirrored in iCloud). I am aware that was a problem in Office 2011 for Mac, but my online search hasn't found posts with this problem recently. I have tried an older suggested workaround of copy/pasting a blank cell in a blank spreadsheet before opening the desired file as suggested at https://apple.stackexchange.com/questions/249326/excel-2011-copy-and-paste-beachball-hang-freeze-issue I have also tested with desired file mirrored on a different cloud, and also just saved locally without any cloud mirroring, - all have similar problems. Thanks @pion for the specific detailed advice to capture what my system is doing when it happens. This is available on Github, spindump.txt .

Does someone have a script to merge or delete Outlook 2011 duplicate calendar entries?

Windows Excel allows me to paste a body of text and in the bottom right corner of the pasted content, a menu prompt will pop up that can initiate the "Text Import Wizard" to import delimited text into columns (text separated by commas or spaces, for example). In Numbers, such an option doesn't exist that I know of. Second, how can I import text (including numbers) as text? With windows I can do both of these functions with the Text Import Wizard and with Numbers I can't do either. The only solution I've found to the first problem is to download a custom workflow that I found in this Apple Community thread: https://discussions.apple.com/thread/8293955 And a less elegant solution is also discussed here but it's much more clunky: https://apple.stackexchange.com/questions/111512/how-can-i-do-text-to-columns-in-numbers?rq=1 Regardless, I still haven't found a way to import numbers as text.

Just reiterating a few locked threads that I found reporting the same issue but without any solution/conclusion: - [Calendar reminders - noticeable delay]( https://answers.microsoft.com/en-us/msoffice/forum/all/calendar-reminders-noticeable-delay/697b23f2-bb8d-44b1-91b3-03bf05dd5ffe) - [Calendar reminders in Outlook for Mac v15.3 show up late](https://answers.microsoft.com/en-us/msoffice/forum/msoffice_outlook-mso_mac-mso_365hp/calendar-reminders-in-outlook-for-mac-v153-show-up/06c4e868-9862-4373-8fb0-a56c03267d3b) - [Calendar Reminders late on desktop](https://answers.microsoft.com/en-us/msoffice/forum/all/calendar-reminders-late-on-desktop/1fbde91f-0f0d-41e6-915d-f7eb546aee4d) - [Calendar/Reminder Notifications Late](https://discussions.apple.com/thread/8174496) And *hopefully* some day somebody can have an answer. For my case, MBP desktop, - reminders for first pop up (say 15 mins) and then when snoozed to (say) 5 mins before are normally on time (when pop up shows, the time on the URH corner is still the same, say 9:45, 9:55) - however, it is the the final reminder at the time of the event that constantly show up late, range from 50 seconds to 1.5 minutes (when pop up shows, the time on the URH corner is almost always at least a minute late, say 10:01+) - and today, the final reminder show up one hour late My OS: Mac Catalina $ sw_vers ProductName: Mac OS X ProductVersion: 10.15.7 BuildVersion: 19H524

Is there any way to access chats after a meeting in Microsoft Teams? I have some kind of MS Teams app on my Macbook. I use it to join a MS Teams meeting when I'm invited to one. However, it is not the 'complete' Teams app which also has chat, filesharing and other stuff. I am not part of some company team with a Active Directory account, so I cannot 'log in' to Teams. The app just opens when I click 'Join Meeting' from an invite. So after I wave goodbye and exit the meeting, where to the chats go?

At my job, I organize large meetings (100+). At the end, I need a list of the email addresses of the people who accepted the invite. How do you export this list from Outlook on a Mac? I know it's possible on a Windows machine. What I really want is some sort of **Meeting > Right Click > Attendees > Accepted > Export** I'd even settle for **Meeting > Right Click > Attendees > Accepted > Reply All**

I have been creating an Apple Script that duplicates calendar items from our shared Family iCloud calendar to a work-related Outlook calendar with the same name (different email address). The following script has been iteratively generated with ChatGPT but it has at least 1 syntax error that I can't fix, relating to the apparently non-existent occurrence property of a Calendar.app event in the following line:

-- NOTE: the following line yields a syntax error "Expected class name but found identifier."
set occurrencesList to every occurrence of thisEvent

Can somebody help me out with this script?

-- Path to a file where we store the event UIDs
set uidFilePath to "~/Documents/icloud_event_uids.txt"

-- Create or read the list of already processed event UIDs
set uidFile to open for access (POSIX path of uidFilePath) with write permission
try
    set processedUIDs to read uidFile as text
on error
    -- If file does not exist, create an empty list
    set processedUIDs to ""
end try

tell application "Calendar"
    -- Select the iCloud calendar
    set sourceCalendar to calendar "Family" -- Replace "iCloud" with the actual calendar name if needed
    set eventList to every event of sourceCalendar
    
    -- Access Outlook application
    tell application "Microsoft Outlook"
        -- Select the Outlook calendar (replace with the name of your desired calendar)
        set targetCalendar to calendar "Calendar" -- Replace "Calendar" with the name of your Outlook calendar
        
        -- Get the current date for comparison
        set currentDate to current date
        set thirtyDaysAgo to currentDate - (30 * days)
        
        -- Normalize currentDate and thirtyDaysAgo to UTC
        set currentDateUTC to convertToUTC(currentDate)
        set thirtyDaysAgoUTC to convertToUTC(thirtyDaysAgo)
        
        -- Check for events older than 30 days in Outlook and remove them
        set outlookEventList to every calendar event of targetCalendar
        repeat with outlookEvent in outlookEventList
            set eventEnd to end time of outlookEvent
            set eventEndUTC to convertToUTC(eventEnd)
            if eventEndUTC < thirtyDaysAgoUTC then
                -- Remove event if its end time is older than 30 days
                delete outlookEvent
                -- Remove the UID of the deleted event from the processed list
                set eventUID to subject of outlookEvent -- Use the subject or another unique property to track this
                set processedUIDs to removeUID(eventUID, processedUIDs)
            end if
        end repeat
        
        repeat with thisEvent in eventList
            -- Get the start time, end time, summary, and UID of the iCloud event
            set eventStart to start date of thisEvent
            set eventEnd to end date of thisEvent
            set eventSummary to summary of thisEvent
            set eventLocation to location of thisEvent
            set eventDescription to description of thisEvent
            set eventUID to id of thisEvent -- iCloud unique identifier (UID)
            
            -- Normalize event start and end times to UTC
            set eventStartUTC to convertToUTC(eventStart)
            set eventEndUTC to convertToUTC(eventEnd)
            
            -- Check if the event UID has already been processed
            if eventUID is not in processedUIDs then
                -- Process this event (e.g., duplicate it into Outlook)
                
                -- Check if it's a recurring event
                if recurrence of thisEvent is not missing value then
                    -- Handle recurring event by extracting all occurrences
                    set recurrenceRule to recurrence of thisEvent
					-- NOTE: the following line yields a syntax error "Expected class name but found identifier."
                    set occurrencesList to every occurrence of thisEvent
                    
                    repeat with occurrence in occurrencesList
                        -- Get start and end time for each occurrence
                        set occurrenceStart to start date of occurrence
                        set occurrenceEnd to end date of occurrence
                        
                        -- Normalize occurrence start and end times to UTC
                        set occurrenceStartUTC to convertToUTC(occurrenceStart)
                        set occurrenceEndUTC to convertToUTC(occurrenceEnd)
                        
                        -- Check if the occurrence already exists in Outlook
                        set eventExists to false
                        set outlookEventList to every calendar event of targetCalendar
                        repeat with outlookEvent in outlookEventList
                            set outlookEventStart to start time of outlookEvent
                            set outlookEventStartUTC to convertToUTC(outlookEventStart)
                            if (outlookEventStartUTC is occurrenceStartUTC) and (subject of outlookEvent is eventSummary) then
                                set eventExists to true
                                exit repeat
                            end if
                        end repeat
                        
                        -- If the occurrence does not exist, create it
                        if eventExists is false then
                            make new calendar event at targetCalendar with properties {subject:eventSummary, start time:occurrenceStart, end time:occurrenceEnd, location:eventLocation, content:eventDescription}
                        end if
                    end repeat
                else
                    -- If it's a single (non-recurring) event, process as usual
                    set eventExists to false
                    set outlookEventList to every calendar event of targetCalendar
                    repeat with outlookEvent in outlookEventList
                        set outlookEventStart to start time of outlookEvent
                        set outlookEventStartUTC to convertToUTC(outlookEventStart)
                        if (outlookEventStartUTC is eventStartUTC) and (subject of outlookEvent is eventSummary) then
                            set eventExists to true
                            exit repeat
                        end if
                    end repeat
                    
                    -- If the event does not exist, create it
                    if eventExists is false then
                        make new calendar event at targetCalendar with properties {subject:eventSummary, start time:eventStart, end time:eventEnd, location:eventLocation, content:eventDescription}
                    end if
                end if
                
                -- Append this event UID to the list of processed UIDs
                set processedUIDs to processedUIDs & eventUID & linefeed
                write processedUIDs to uidFile
            end if
        end repeat
    end tell
end tell

-- Close the file after processing
close access uidFile

-- Function to remove UID from the processed list
on removeUID(thisUID, uidList)
    set textItemDelimiters to linefeed
    set uidListItems to every text item of uidList
    set newUIDList to {}
    
    repeat with currentUID in uidListItems
        if currentUID is not thisUID then
            set end of newUIDList to currentUID
        end if
    end repeat
    
    return (newUIDList as text)
end removeUID

-- Function to convert date to UTC
on convertToUTC(inputDate)
    set timeZoneOffset to (time zone of (current date)) -- Get the current time zone offset
    set utcDate to inputDate - timeZoneOffset -- Convert to UTC by subtracting the offset
    return utcDate
end convertToUTC

I'm using macOS 14.6.1 and Outlook 16.89.3. I can't quite find an answer to this question on the forum. I'm trying to create a folder actions service/script to monitor a particular folder for any new excel files (only excel files would be added to this folder anyway) and, when a file is added, send that file, via Outlook, to the user whose email address is found in cell B2 of the spreadsheet. I've tried using chatgpt for this. It gives me a script that works when using Apple Mail, but not Outlook. Here is one example of what chatgpt says I should use...which keeps failing. When I drop a file in the folder, I see the little gear icon turning in the menu bar, but there are no dialog boxes that appear, no error messages, and no created/sent emails in Outlook.

on adding folder items to this_folder after receiving added_items
    repeat with added_item in added_items
        set filePath to POSIX path of added_item
        -- Check if the file is an Excel file
        if filePath ends with ".xlsx" then
            display dialog "File added: " & (name of added_item) -- Debugging message
            try
                -- Open the Excel file to read the email address
                tell application "Microsoft Excel"
                    open filePath
                    delay 1 -- Wait for Excel to open
                    set recipientEmail to value of cell "B2" of active sheet
                    close active workbook saving no -- Close the workbook without saving
                end tell
                
                -- Ensure recipientEmail is valid
                if recipientEmail is not missing value then
                    -- Prepare the email
                    tell application "Microsoft Outlook"
                        set newMessage to make new outgoing message with properties {subject:"Your Requested Excel File", content:"Hello,\n\nPlease find the requested Excel file attached.\n\nBest regards,\nYour Name"}
                        make new recipient at newMessage with properties {email address:{address:recipientEmail}}
                        make new attachment at newMessage with properties {file:added_item}
                        send newMessage
                    end tell
                else
                    display dialog "No email address found in cell B2 of " & (name of added_item)
                end if
            on error errMsg
                display dialog "Error processing file: " & errMsg
            end try
        end if
    end repeat
end adding folder items to

Thanks for your time.

I have a word document with comments. I wanna print it with the comments, but when I try, the document and the comments pane are shrunk, and do not fill the A4 paper properly (check photo). Tried changing the paper size from word, it went horribly. Is there any solution for this problem? No need for it to be in Word.
If not, is there a way to present the comments inline, just pushed by a level (like in reply messages?)
Thanks in advance!

It seems there are suggestions for how to replace a character or a string with a newline in Excel for Mac, such as In Mac Excel, how can I replace with newline? . But trying to reverse the process does not work; e.g., to type Ctrl+J or Opt+0+0+1+0 etc. Any advice on how to replace newlines in cells with, for example, space?

I am using a Mac Sonoma but the feature to drag the icon sitting in the center of the title bar of a window it's gone. The icon still shows and I can still click on the icon button. I can't drag it to drop the file out to a different location or an email. The display title in the settings and tried to line people suggested by it still doesn't work. Does anyone know how to reactivate this feature? Additionally doesn't even show the icon in the title bar at all. Any solutions ? Thank you!

For inserting a tab in a cell, I have tried the instructions from a few resources but none work. Here is one from Microsoft Learn has options but they do not work: How do I indent in Excel 2011 for Mac? Also this one does not work: How to include a tab in an Excel for Mac cell - Mac equivalent of char(9) Note: I'd far prefer to have a shortcut way to do this operation instead of needing to hit ribbon, or menubar, or click on something else.

In recent versions of Word and Excel, when I press cmd-O or select Open from the dropdown, it gives me an annoying cluttered screen full of options I don't care about instead of actually letting me open my files. To get the latter I have to click "On My Mac", down under "Other Locations". Is there any way to make it just open the files from my filesystem by default, the way it used to until recently? I saw a related question that recommended deleting the OneDrive app to make My Mac be the default for saving. I do edit shared files in SharePoint/O365 at work, so I'm worried about that getting screwed up. Is there any other option? If deleting OneDrive is the only option, what will it do to my SharePoint workflow? If I have to live with this dialogue box, I guess it's not the end of the world, but it *is* really annoying so I thought I'd at least check if anyone had ideas.

Is it possible to open or convert a Mac Office 98 PowerPoint file (.pp)? I don't need to edit it, just either convert it to a more recent version or save as a pdf. I don't have access to anything before OS X, but I still have a PowerPC laptop. Recent versions of PowerPoint refuse to open it, and I haven't been successful finding a converter. Alternatively, is there a service that would do something like this?

I have a conflict between Finder and Microsoft Word with the key combination Shift + Command + D. Finder uses it to open the Desktop window and this prevents me from using this shortcut to toggle Dark mode in Word. To clarify: if I use this key combination, Word will not toggle Dark Mode even if it has focus. If you return to Finder, it can open the Desktop window as usual. Therefore, the problem is not the keyboard. I am running macOS Sonoma at work and macOS Sequoia at home. I only find this problem in the computer at home and **none of the old solutions work**, including: 1. Edit the Finder shortcut in Apple Menu -> Settings -> Keyboard -> Keyboard Shortcuts system control panel. Although the conflict disappears then the new shortcut I chose for Finder works the first time but it won't work later (a bug?); consequence: I needed to reverse this setting. 2. Tried to use many apps to edit this **pre-existing** command in Finder that are able to edit keyboard shortcuts but due to the changes how this is achieved on Sonoma and later editing the com.apple.symbolichotkeys.plist does not work anymore and none of the apps in the market are able to edit these **pre-existing** key combinations. (I am aware that these apps are able to add new key combinations but they are not able to **override** pre-existing Finder key combinations, though). The only app able to **override** any Finder keyboard shortcut is the System Preferences panel I referred to in 1. Moreover, some of the apps even require privileged helpers and I do not want that. *What do I have to do to solve this conflict?*

How do I make the "MultiSelect" option work in the Application.GetOpenFilename() method? Despite Microsoft's help page, setting this argument to True doesn't allow me to select multiple files in the dialog. Answers like this do not help since FileDialog isn't available on the Mac version of Excel. What I really want is to prompt the user for a folder instead of a file, but I can't find out how. So, I'm using subs like this to have the user pick files but as you can see in my screen recording, MultiSelect doesn't work. I know I can use the file selected to determine the folder Sub getFolder() Dim path As Variant path = Application.GetOpenFilename(FileFilter:="txt", _ MultiSelect:=True) If path = "False" Then End 'user hit Cancel End Sub Ironically, the first time a file is chosen a "Grant Access" dialog appears, which is itself a folder picker -- exactly what I want. And yet I can't figure out how to make a "Grant Access" dialog appear with VBA.

I have iMac 27 (10,1 late 2009) with High Sierra. I got new SSD and installed High Sierra. After installing MS Office it asked me to sign in. And it seems impossible. After I enter my email address nothing happens, just blank window. I entered my MS account and changed authorization method from Authenticator to Login-Password, but it didn’t work. Is there any solution? Please, help. :)

Clicking on Microsoft Teams icon in the Dock on macOS opens a control screen rather than returning to the active session. All other applications and especially Microsoft Office products go to the active/open file. Is there something that I can do to change the behavior so that clicking on the Microsoft Teams icon in the MacOS Dock returns to the currently active Teams session? I called it a control screen. It defaults to the calendar and has some other controls on it. Attached is the picture of the upper left corner of the screen.

Same question has been asked before on how to fix this in the default Mail app on Mac, but I'm wondering if there is a solution also to the Microsoft Outlook app on Mac? This is the link I found before and can confirm the the answer provided worked for the Mac Mail App: https://apple.stackexchange.com/questions/79604/how-to-save-sent-messages-in-same-folder-as-message-being-replied-to