Email appending Puns

I have some code that has worked fine for years but has recently started working different in a few different scenarios. First the code (which I will post below): It creates an email, saves the initial HTMLBody to a string file to save the signature to append later. Updates the body with a string field, attachs the a table from the file into the body and then appends the initial HTMLBody back on.

This has worked fine for years on a shared network drive, but we are migrating to Sharepoint. When this file is run from Sharepoint, everything works as expected except that any pictures in the signature (like company logo) don't come through. When I run from My Documents it does the same thing (My Documents now syncs with OneDrive after migration to Office365). When I save the file to an unsynced folder like c:\macro_test it works just as expected; so I know the issue is around the Sharepoint/OneDrive syncing. I also noticed that when it works as expected the attached file is "Macro Test.xlsm" but from Sharepoint or My Documents the attached file is "Macro%20Test.xlsm" if that helps.

edit: after I assigned HTMLBody to SavedSig I output to a text file and compared. The only difference is a section in the img tag where src="cid:image002.png@01D7BF76.97AB96D0"; but this changes every time the macro is run regardless of where the file is saved. I believe that it is a reference to an image list that is generated when the email is initially created.

edit2: if I didn't need the chart in the body and change the following line ( .HTMLBody = "<p>" & Body & "</p>") to ( .HTMLBody = "<p>" & Body & "</p>" & SavedSig) Then it works as expected. This is leading me back to the "cid" reference above, perhaps the image list is no longer valid once the reference to it is no longer in HTMLBody. Though I don't know why it would only show up when the file is run from a synced location.

solution: what worked for me, and again I do not know why it is working now, is to move the file attachment to after everything was done with the body.

• removed " .Attachments.Add ThisWorkbook.FullName" from With statement.
• add EmailItem.Attachments.Add ThisWorkbook.FullName after SavedSig was appended back to body of email.

Again I don't know why this allowed it to start working, but it appears to have resolved the problem.

Sub SendFile()
    Dim EmailItem As outlook.MailItem
    Dim SendTo As String
    Dim S

Hello,

So I have this form.

https://preview.redd.it/phrns86px0e51.png?width=1224&format=png&auto=webp&s=bc72cc186b11a63b85adcf7c2b2b09ac7862f1ca

The email is working great. I want the "Urgency" value to be appended in the Email subject though.

I am not sure of the syntax though.

Basically, when the email is sent it should have whatever the user typed into "Summary of Issue" but it should also have " - Urgency: Value of Urgency drop-down"

I am not too sure how to do this.

My OnSelect is set to:

>Microsoft365Outlook.SendEmail("email@here.com", Summary & " - Urgency:", Description,{Attachments: AddColumns( RenameColumns
>
>(AttachmentControl.Attachments, "Value", "ContentBytes"), "@odata.type", "") })

I just need help with what comes after "Urgency:" above. Thank you. The values would be either Low, Medium, or High from the drop down.

0

I have setup SSO with Azure but my Azure users are coming thru with .com at the end of the email address: peter@mydomain.co.uk.COM

I cant find a reason for this on the Azure side

Is there a setting on SF that could be causing this?

M

So what my dream scenario would be:

I´ll take emails from a certain sender, copy the text of the mail into any other location, say, a note, and then have that email removed from my inbox. The reason is, I get a lot of emails that just contain a single link, no rich preview, no other info, because somebody thinks that it would be interesting reading material. Is that possible, even if I have to subscribe to an extra service like Zapier?