Prev: Copy file from one directory to a new directory, using excel spreadsheet as reference for items to be copied
Next: access denied getobject
From: dominic on 21 Dec 2009 08:01 Hello All, I have a client that would like a generic outlook signature throughout the company. I want to be able to do this with VBS. I have a VBS scirpt that grabs the users Name, title, phone, fax, address, and email. That part of the script is working fine. I then want to have 3 web sites linked in as well. Currently the two web sites that are standard http://www.whatever.com shows up fine. The third address is actually a hyperlink that I would like to insert, the text should read "Donate Online". What I have done for the hyperlink; I tried to create a macro in word to get the code for the hyperlink but VB code is different then VBS (but you knew that), and when I try to run the script with the code I get an unexpected error at the := symbols. Below is the macro. Selection.TypeText Text:="DONATE ONLINE" Selection.HomeKey Unit:=wdLine, Extend:=wdExtend ActiveDocument.Hyperlinks.Add Anchor:=Selection.Range, Address:= _ "http://members.esd.org/source/members/donate.cfm?section=unknown", _ SubAddress:="", ScreenTip:="", TextToDisplay:="DONATE ONLINE" If you could help me with the code that would be great. Let me know if you have any questions that I haven't answered. We are using Office 2007 with Exchange 2007 running on Server 2008. All workstations are running XP Let me know if you would like the entire script. Thank you, Dominic |