I'm needing to change the cursor in Outlook while a proc is running.

In Office x32 I use, and it works.

Private Declare Function LoadCursor Lib "user32" Alias "LoadCursorA" (ByVal hInstance As Long, ByVal lpCursorName As Long) As Long
Private Declare Function SetSystemCursor Lib "user32" (ByVal hcur As Long, ByVal id As Long) As Long
Private Declare Function DestroyCursor Lib "user32" (ByVal hCursor As Long) As Long
Private Const OCR_NORMAL = 32512
Private Const IDC_WAIT = 32514&

Sub CursorWait()
    Dim hCursor               As Long

    On Error GoTo Error_Handler

    hCursor = LoadCursor(ByVal 0&, IDC_WAIT)
    SetSystemCursor hCursor, OCR_NORMAL
    DestroyCursor hCursor

Error_Handler_Exit:
    On Error Resume Next
    Exit Sub

Error_Handler:
    MsgBox "The following error has occurred" & vbCrLf & vbCrLf & _
           "Error Number: " & Err.Number & vbCrLf & _
           "Error Source: CursorWait" & vbCrLf & _
           "Error Description: " & Err.Description & _
           Switch(Erl = 0, "", Erl <> 0, vbCrLf & "Line No: " & Erl) _
           , vbOKOnly + vbCritical, "An Error has Occurred!"
    Resume Error_Handler_Exit
End Sub

Sub CursorNormal()
    Dim hCursor               As Long

    On Error GoTo Error_Handler

    hCursor = LoadCursor(ByVal 0&, OCR_NORMAL)
    SetSystemCursor hCursor, IDC_WAIT
    DestroyCursor hCursor

Error_Handler_Exit:
    On Error Resume Next
    Exit Sub

Error_Handler:
    MsgBox "The following error has occurred" & 

Select all Open in new window

…

A client received this email, its spam.   I pulled the header from the email, and I was wondering if someone can assist in identifying which line shows a bogus inbound or outbound sending line? I went through it a couple times and this is my only source to identify where the sender came  from.

Received: from BN6PR2201MB1137.namprd22.prod.outlook.com
 (2603:10b6:404:8d::27) by BN6PR2201MB1746.namprd22.prod.outlook.com with
 HTTPS via BN6PR04CA0077.NAMPRD04.PROD.OUTLOOK.COM; Tue, 25 Feb 2020 19:51:11
 +0000
Received: from DM3PR14CA0133.namprd14.prod.outlook.com (2603:10b6:0:53::17) by
 BN6PR2201MB1137.namprd22.prod.outlook.com (2603:10b6:405:36::29) with
 Microsoft SMTP Server (version=TLS1_2,
 cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.2750.21; Tue, 25 Feb
 2020 19:51:09 +0000
Received: from DM3NAM05FT043.eop-nam05.prod.protection.outlook.com
 (2603:10b6:0:53:cafe::96) by DM3PR14CA0133.outlook.office365.com
 (2603:10b6:0:53::17) with Microsoft SMTP Server (version=TLS1_2,
 cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.2750.18 via Frontend
 Transport; Tue, 25 Feb 2020 19:51:08 +0000
Authentication-Results: spf=fail (sender IP is 65.170.60.123)
 smtp.mailfrom=birdair.com; superiorsiti.mail.onmicrosoft.com; dkim=pass
 (signature was verified)
 header.d=birdair.onmicrosoft.com;superiorsiti.mail.onmicrosoft.com;
 dmarc=none action=none header.from=birdair.com;
Received-SPF: Fail (protection.outlook.com: domain of birdair.com does not
 designate 

Select all Open in new window

…

Back in the day you could use apps like PocketMirror etc. that would keep folders in Outlook in sync with each other. Now with API's, Zapier, and the like you can use the "cloud" to keep databases in sync. Looking for a way to keep Icloud Contacts(Iphone) and Outlook Contacts (Office 365 Premium/Exchange) in sync

Setup:
DEVICE 1:
Windows 10 with Outlook 2019 and Office 365 Business Premium Mail setup and iCloud app installed to Sync Icloud Contacts in iCloud folder in Outlook

DEVICE 2:
iPhone 8 with phone contacts (synced with iCloud contacts) and Outlook App (Sync'd with Office 365 Business Premium/Exchange)

Need app that runs in Outlook on Windows machine or maybe some API service that will sync the Icloud Contacts to the Office 365 Business Premium/Exchange Contacts so that when either databases are updated the sync pushes through both ways.

Hello all

Below is a Sample that I have in multiple spreadsheets

AlarmID      Zone      Stime      Etime      StoreOpen      Comments
M1253      Bdoor      1:53      1:59      Y      
M5243      Bdoor      1:02      1:03      N                     Please research
M8696      Fdoor      1:04      1:06      N                     Second time this week
M4586      Roof      3:48      3:53      Y      


I would like to add a button to the spreadsheets that would generate 1 email with only the alarms there the StoreOpen column is N.  I think some sort of loop through a range in excel would work.


For example with the information above the email could contain 2 records in the body of the email and would look something like below  (the most should only be 5 so not too long):

To: anyperson@anyemail.com
Subject: Alarm Alert
Body:

Please review the following Alarms:

AlarmID: M5243
Zone: Bdoor
Stime:
ETime:
Comments: Please Research
--------------------------------------

AlarmID: M8696
FDoor
Stime: 1:04
ETime 1:06
Comments: Second Time this week

Hi,

Simple question. Is O365 uses TLS protocol to send email or we need to activate this function?

Thanks

Experts,

I need help with converting the attached link file worksheets Original Quote and RAW_DATA to a Table format with the ability to convert back to a range while having the code to still function correctly.

https://filedb.experts-exchange.com/incoming/2020/01_w03/1440849/29169174.xlsm

I'm looking for a way to move email I have in an Outlook *.pst file to Thunderbird that actually works.

I used to use Outlook for personal email, which I kept in a *.pst file.  The company policy has changed however and I cannot use Outlook for personal email any longer.

My personal email is Gmail and Thunderbird has been a long-time supplier of a solid email product so I installed that and it works fine, however I have thousands of email in a hierarchy of perhaps a hundred folders I need to move over.

I've tried uploading to gmail folders from Outlook on another computer, however that's a complete joke.  Files don't show up.  The equivalent of folders in email don't get created.  Just a disaster.

I've downloaded a thunderbird extension for import, however it fails while throwing windows errors.

I have yet to find a program that can move the email (and the folder hierarchy) into Thunderbird, so I'm writing to see if anyone can recommend one that will actually work.  Free or otherwise.

I have an Excel VBA module that sends an email that includes a hyperlink to a network drive location (that may have spaces). I have some code that sort of works but needs a bit of help...

  Dim OutApp As Object
    Dim OutMail As Object
    Dim strbody As String

    Set OutApp = CreateObject("Outlook.Application")
    Set OutMail = OutApp.CreateItem(0)

    strbody = managername & "," & vbNewLine & vbNewLine & _
              "Data has been dumped from the survey controller on project number " & newjob & ".  The name of the file is: " & vbNewLine & vbNewLine & _
              filefromname & vbNewLine & vbNewLine & _
              "and it is located in the following folder:" & vbNewLine & vbNewLine & _
            "<a href=""<file:///" & GetFolder & ">"">" & GetFolder & "</a>" & vbNewLine & vbNewLine & _
                "Comments:" & vbNewLine & surveynotes
    MsgBox strbody
    
    On Error Resume Next
    With OutMail
        .To = manageremail
        .Subject = "Some survey points have been downloaded on one of your projects"
        .Body = strbody
        'You can add a file like this
        '.Attachments.Add ("C:\test.txt")
        .Send   'or use .Display
    End With
    On Error GoTo 0

    Set OutMail = Nothing
    Set OutApp = Nothing

Select all Open in new window

The email sends no problem, and the extra chevrons in the string help me pick folders that have spaces in them.  But when the user gets the email, they see the hyperlink source code in the Outlook email like this: (PS - the link works no problem)


instead of seeing it neatly like this:


If I grab the "strbody" variable and paste it into dreamweaver or some other editor, it looks fine, but when the Outlook email is received, the HTML code for the link shows up.  What can I do so that the user doesn't see all the <a href> text that goes with the hyperlink?


Thanks very much!

Hi All,

Recently i delegated one user mailbox. It is showing under my mailbox in outlook. but i can see only inbox items.

is it possible to add delegated user sent items on my outlook.

I have an excel file with Name email address and html file location.
I need to automate this process.
i.e. Send email based on the email address and html content in the email.
GTMarketing.xlsx

I have a PDF file with a size of 175 MB that I am trying to send to a recipient from my Downloads folder using right click send to mail recipient and nothing happens when I do so. I tried a different file and it went through. after that I realized it could be the file size which in this case it was a lot larger than the file that got sent. I know Outlook had 25 MB file size but I was reading and I came a cross that there was an increase in limit to 150 MB using cloud based Outlook which I am not familiar with. See Google search hit""Microsoft has increased the maximum size of an e-mail message that can be sent by an organization using its cloud-based Office 365 services to 150MB. Previously, a single Office 365 e-mail message could be 25MB max. ... IT pros can change these settings for individual users via Office 365's Exchange Admin Center..
Can someone advise me on how to go about sending this file? hopefully an easy method if all possible.

Thank you,
Basem Khawaja

Has anyone seen or noticed iPhone users that run the Outlook app for their O365 account that have shared mailboxes simply disappear out of the clear blue?   One of my users just called in and states both of his shared mailboxes were gone out of his outlook but his primary account was still there.  He swears he didn't delete them manually because it would have meant he would have physically had to have removed both, however he claims they just disappeared.   I walked him through re-adding them both and they appeared.   Figured I'd ask.