Outlook Email Signature Automation with AD Attributes

[vampielgod]

Hi QwertyMash,

 

Could you render some help on the syling portion as i am noob on this.

What i want to achive is the below style.

 

But the best i can do is the below.

 

there is 3 main style.

1. the logo and the address are far apartment.

2. the EmpName | Title, want to shift.

3. the verticle line can be longer?

 

Thanks in advance.

[QwertyMash]

Hello,

 

Sorry for the delayed reply I never got an alert for this - If you DM me if you still need help with this I can try assist.

 

Thanks.

[NetworkBoss]

Hello!!

 

Has anyone managed to get this working with no local AD? We are fully intune & m365 and need a script like this to manage email signatures.

 

Thank you

[garymagee]

Hi!

 

Just wondering if there's an update on when the next project will be released?

 

We as a school are super keen to get Outlook on the web signatures up and running but unfortunately the current script isn't working for us

 

Thanks

Gary

[r4tty72]

Hi QwertyMash

 

Firstly, thank you for this script, its helping me look semi-competent at my new job!

 

I have the script working but I do struggle with formatting the output and need this to look as close to our current signature as possible, if you had time do you think you could take a look at the formatting we need and assist with this?

 

This is what we are looking for:

 

Thanks in advance

[QwertyMash]

Hello!!

 

Has anyone managed to get this working with no local AD? We are fully intune & m365 and need a script like this to manage email signatures.

 

Thank you

Hello,

 

Sorry I have been so busy recently. I am going to branch off my original project to make a new one for users Office 365 (rather than office 2019) as the Outlook signature sync seems to be breaking this script

I can investigate the no local AD while I am at it but I have no ETA sorry.

 

Thank you.

 

- - - Updated - - -

 

Hi!

 

Just wondering if there's an update on when the next project will be released?

 

We as a school are super keen to get Outlook on the web signatures up and running but unfortunately the current script isn't working for us

 

Thanks

Gary

 

As mentioned in my previous post, I am going to start a new branch of the project and start again due to how much the new Office 365 outlook signature syncing breaks it - this will potentially give you what you need.

 

Thank you

 

- - - Updated - - -

 

Hi QwertyMash

 

Firstly, thank you for this script, its helping me look semi-competent at my new job!

 

I have the script working but I do struggle with formatting the output and need this to look as close to our current signature as possible, if you had time do you think you could take a look at the formatting we need and assist with this?

 

This is what we are looking for:

[ATTACH=CONFIG]70352[/ATTACH]

 

Thanks in advance

 

If you could DM me with the desired fonts/sizes etc. I can quickly knock up the HTML for you for this.

 

thank you.

[CCI_IT_Dept]

Hi @QwertyMash,

 

I see that your powershell script has had great success for some. We have had a VBS script in place that used to work for our Outlook desktop clients, that was created by a former employee. Lately it has been very hit and miss in applying, and has also stopped running silently, and we can't figure out why. So that lead me to seek out better alternatives, and finding yours. I like the idea of getting ours to work like yours and if it could work on OWA. Let me know if ours could easily be converted to work in your .ps1 script format? Attached is what our completed signature looks like, but we also have it grab and display a 2nd address for user's that manage 2 locations.

SignatureScriptv14.vbs

[SmithR]

Is there anyway of pulling the AD Description field for a user to pull into the Signature?

[QwertyMash]

Hi @QwertyMash,

 

I see that your powershell script has had great success for some. We have had a VBS script in place that used to work for our Outlook desktop clients, that was created by a former employee. Lately it has been very hit and miss in applying, and has also stopped running silently, and we can't figure out why. So that lead me to seek out better alternatives, and finding yours. I like the idea of getting ours to work like yours and if it could work on OWA. Let me know if ours could easily be converted to work in your .ps1 script format? Attached is what our completed signature looks like, but we also have it grab and display a 2nd address for user's that manage 2 locations.

 

Hello,

 

There are a few options for it working with OWA but it would require modification, currently the new Outlook and its ability to sync signatures is actually making the script be a little strange at times so I am just looking at that to see if it's fixable or if the script needs to be totally rethinked.

As for the lay out of the signature you should be able to achieve that pretty easily as long as all the data is in Active Directory.

[QwertyMash]

Hi @QwertyMash,

 

I see that your powershell script has had great success for some. We have had a VBS script in place that used to work for our Outlook desktop clients, that was created by a former employee. Lately it has been very hit and miss in applying, and has also stopped running silently, and we can't figure out why. So that lead me to seek out better alternatives, and finding yours. I like the idea of getting ours to work like yours and if it could work on OWA. Let me know if ours could easily be converted to work in your .ps1 script format? Attached is what our completed signature looks like, but we also have it grab and display a 2nd address for user's that manage 2 locations.

 

Yeah, $user.description is the user's description.

 

Cheers.

[CCI_IT_Dept]

Hello,

 

There are a few options for it working with OWA but it would require modification, currently the new Outlook and its ability to sync signatures is actually making the script be a little strange at times so I am just looking at that to see if it's fixable or if the script needs to be totally rethinked.

As for the lay out of the signature you should be able to achieve that pretty easily as long as all the data is in Active Directory.

Do you have time to possibly assist? Much appreciated ...

[piokrz]

I have a problem with generating the signature, I changed it to UTF8, when I download data from AD everything is OK, but when I add content to the file, "bushes" appear in the file, example: $(if($phone){"Tel: $($phone),"}) $(if($mobileNumber){"mobile phone $($mobileNumber),"}) $(if($email){"e-mail : $($email),"}) https://zp.pn.pl/'>www.zp.pn.pl< /a>

 

and then adds the following content:

message including threats... content...

e.t.c..

[piokrz]

Hello Kevin.

 

Of course - Can you try using ü for the ü

 

Mit freundlichen Grüen - Best Regards

 

Let me know how that goes

 

Thank you.

same problem, signature.html file displays correctly in Edge but not in outlook. Outlook still has the HTML entity

[piokrz]

ok, I found the solution. I edited in PowerShell PE and after pasting the correct content, it saved correctly.

[Footshop_AB]

If it helps, I've found a ghetto/undocumented solution for uploading locally created signatures if you're using the new Roaming Signature feature. This does require the Outlook 365 Desktop application and roaming signatures needs to be enabled in the registry (just in case it's disabled).

 

 

1. Browse to %APPDATA%/Microsoft/Signatures (alternatively, open Options in Outlook and Ctrl-click the Signatures option in the Mail section).
   
2. Copy and Paste any of the local signatures you want synchronised to the web.
   
3. Rename the copies and append your 365 email address in brackets to the end of the file.
   
4. Close & Re-open the Outlook desktop client.
   
5. Navigate to the Signature manager via Options or New Mail > Signature > Signatures...
   
6. The web signatures should now appear in the appropriate account section (i.e. not in the 'Signatures on this device' section). They should also now be synchronised to Exchange Online - this can be checked by visiting https://outlook.office.com.
   

I have written a quick PS script to do batch copying and renaming:

# Exchange Online Signature Duplicator
$RoamingSignatures = $env:APPDATA + "\Microsoft\Signatures"
$username = $env:USERNAME
$domain = "YOUR DOMAIN HERE"
$exclude = "*$username@$domain*"

Set-Location -Path $RoamingSignatures
$include = @("*.htm","*.txt","*.rtf")
$files = Get-ChildItem -Path $RoamingSignatures -File -recurse -Include $include -Exclude $exclude

foreach ($file in $files)
{
#echo $file
$oldfile = $file.Name
$newfile = $file.BaseName + " ("+$username+"@"+$domain+")" + $file.Extension
Copy-Item $oldfile $newfile
}

Edited April 10, 2024 by Footshop_AB

[QwertyMash]

If it helps, I've found a ghetto/undocumented solution for uploading locally created signatures if you're using the new Roaming Signature feature. This does require the Outlook 365 Desktop application and roaming signatures needs to be enabled in the registry (just in case it's disabled).

 

 

1. Browse to %APPDATA%/Microsoft/Signatures (alternatively, open Options in Outlook and Ctrl-click the Signatures option in the Mail section).
   
2. Copy and Paste any of the local signatures you want synchronised to the web.
   
3. Rename the copies and append your 365 email address in brackets to the end of the file.
   
4. Close & Re-open the Outlook desktop client.
   
5. Navigate to the Signature manager via Options or New Mail > Signature > Signatures...
   
6. The web signatures should now appear in the appropriate account section (i.e. not in the 'Signatures on this device' section). They should also now be synchronised to Exchange Online - this can be checked by visiting https://outlook.office.com.
   

I have written a quick PS script to do batch copying and renaming:

# Exchange Online Signature Duplicator
$RoamingSignatures = $env:APPDATA + "\Microsoft\Signatures"
$username = $env:USERNAME
$domain = "YOUR DOMAIN HERE"
$exclude = "*$username@$domain*"

Set-Location -Path $RoamingSignatures
$include = @("*.htm","*.txt","*.rtf")
$files = Get-ChildItem -Path $RoamingSignatures -File -recurse -Include $include -Exclude $exclude

foreach ($file in $files)
{
#echo $file
$oldfile = $file.Name
$newfile = $file.BaseName + " ("+$username+"@"+$domain+")" + $file.Extension
Copy-Item $oldfile $newfile
}

 

I am currently working on a big rewrite of the original script to add a bit more readability and a few more features. I will take this hugely into consideration! Thank you.

 

- - - Updated - - -

 

Do you have time to possibly assist? Much appreciated ...

 

I am very sorry I never got back to you on this - the first few months of this year have been ridiculous for me.

 

I am able to assist if you want - DM me if you have Discord and we can directly message on their for ease.

[QwertyMash]

Hello everyone.

 

Ready for people to give ago is a rather large rewrite of the script: https://github.com/captainqwerty/AutomatedOutlookSignature

 

Version 5.0.0 is a bit of a huge rewrite but very much achieving a similar end. This is essentially the foundations for further work with many other ideas I have had to improve and adapt this project.

 

Thank you everyone.

[QwertyMash]

@dblight have you tried using Exclaimer for their automatic reply template, when i stumbled upon their software i was honestly so relaxed and at ease.

Just a side note that Exclaimer isn't free.

Edited July 23, 2024 by Dos_Box

[Dos_Box]

Just a side note that Exclaimer isn't free.

 

They are also very banned now for spamming!

[Napoleon]

Hello everyone.

 

Ready for people to give ago is a rather large rewrite of the script: https://github.com/captainqwerty/AutomatedOutlookSignature

 

Version 5.0.0 is a bit of a huge rewrite but very much achieving a similar end. This is essentially the foundations for further work with many other ideas I have had to improve and adapt this project.

 

Thank you everyone.

 

Hi @QwertyMash,

thanks for this script, its great! Just having some issues formatting (and it also doesnt seem to be picking up the company name too for some reason, but i can probably work tha tout myself).

If youre still active in this thread, any chance you could help us out with the formatting for the sig if i DM you an exmaple?

Edited October 10, 2024 by Dos_Box

[thimon]

They are also very banned now for spamming!

 

Their sales people are VERY persistent!

[QwertyMash]

Hello @Napoleon!

 

Feel free to DM me an example and what your issue is. I will glad help in my spare time.

 

Can I just ask if you are running the latest branch or the development branch? There is a couple of fixes in the development branch.

 

Cheers.

 

Hi @QwertyMash,

thanks for this script, its great! Just having some issues formatting (and it also doesnt seem to be picking up the company name too for some reason, but i can probably work tha tout myself).

If youre still active in this thread, any chance you could help us out with the formatting for the sig if i DM you an exmaple?

[Napoleon]

Hello @Napoleon!

 

Feel free to DM me an example and what your issue is. I will glad help in my spare time.

 

Can I just ask if you are running the latest branch or the development branch? There is a couple of fixes in the development branch.

 

Cheers.

 

Thanks man! Much appreciated. I’m running 5.0.0 latest branch. I actually managed to fix a few of the issues I was having in that it wasn’t pulling the website or company name from AD, so it’s really just formatting now. I’ll DM when I’m back in the office tomorrow!

[QwertyMash]

Yeah DM me the formatting issue I can try assist.

 

Thanks man! Much appreciated. I’m running 5.0.0 latest branch. I actually managed to fix a few of the issues I was having in that it wasn’t pulling the website or company name from AD, so it’s really just formatting now. I’ll DM when I’m back in the office tomorrow!

[Napoleon]

Also, FWIW, if anyone els eis having an issue where the sig wont pull the company name / website from AD, i changed these lines

 

$userAccount.Company = if ($null -eq $CompanyName) { $user['company'] } else { $CompanyName }

 

$userAccount.WebPage = if ($null -eq $Website) { $user['wWWHomePage'] } else { $Website }

 

to this

 

$userAccount.Company = $user['Company'] -join ''

 

$userAccount.WebPage = $user['wWWHomePage'] -join ''

 

and it worked for me