Manage Email Signatures Centrally - For All Users

elfidge · Just popping in Joined: 13 Oct 2007 Posts: 3

I'm looking to move my login script from a batch file to a VB script. After spending shed loads of time googling, I came up with the following, but it still doesn't appear to work. Any ideas??

Option Explicit
Dim objNetwork, objUser, CurrentUser
Dim strGroup
Dim wshShell
Dim ObjShell

' ** eMailSignature **

Set objShell = WScript.CreateObject("WScript.Shell")
ObjShell.run("\\srvdc01\netlogon\sign.exe" & "Provider=sqloledb;Data Source=SRVAPP03;Initial Catalog=eMailSignature;Integrated Security=SSPI")
Set ObjShell=Nothing

Bjarne Mess · Posted: Sat Oct 13, 2007 5:36 pm Post subject: VB Login Scripts

Have you tried this:

Set objShell = WScript.CreateObject("WScript.Shell")
ObjShell.run("\\srvdc01\netlogon\sign.exe Provider=sqloledb;Data Source=SRVAPP03;Initial Catalog=eMailSignature;Integrated Security=SSPI")
Set ObjShell=Nothing

Jesper Frier · Posted: Sun Oct 14, 2007 6:59 am Post subject: Include space after Sign.exe

elfidge · Just popping in Joined: 13 Oct 2007 Posts: 3

Tried both this morning - both throw the same error I've been getting using this method:

Script: \\SRVDC01\NETLOGON\logon.vbs
Line: 16
Char: 1
Error: The system cannot find the file specified
Code: 80070002
Source: (null)

Script is as below:

Option Explicit
Dim objNetwork, objUser, CurrentUser
Dim strGroup
Dim wshShell
Dim ObjShell

' ** eMailSignature **

Set objShell = WScript.CreateObject("WScript.Shell")
ObjShell.run("\\srvdc01\netlogon\sign.exeProvider=sqloledb;Data Source=SRVAPP03;Initial Catalog=eMailSignature;Integrated Security=SSPI")
Set ObjShell=Nothing

Any further ideas? I can get sign.exe to run on it's own, I just can't get all the switches after it to function properly...

Jesper Frier · Posted: Tue Oct 16, 2007 6:49 am Post subject: Add space

This is wrong - you need to add space after Sign.exe

elfidge · Just popping in Joined: 13 Oct 2007 Posts: 3

Thanks Jesper - appears to be working, good stuff.

:D

Bjarne Mess · Posted: Wed Oct 17, 2007 12:25 pm Post subject:

Great

kevinweiland · Posted: Mon Mar 10, 2008 7:29 pm Post subject:

Can you use a Microsoft access database with the VB script?

Bjarne Mess · Posted: Mon Mar 10, 2008 7:46 pm Post subject: VB Login Scripts

kevinweiland · Posted: Mon Mar 10, 2008 8:37 pm Post subject:

not a moment after i posted that i got it working...nifty!

Bjarne Mess · Posted: Mon Mar 10, 2008 11:36 pm Post subject: Acces DB

Well, that's the most important thing.

Cheers,
Bjarne