+ Reply to Thread
Results 1 to 4 of 4

Wanted: VBA Script to use for Outlook signatures

  1. #1
    Registered User
    Join Date
    11-04-2013
    Location
    Lenexa, Kansas
    MS-Off Ver
    Excel 2010
    Posts
    2

    Thumbs up Wanted: VBA Script to use for Outlook signatures

    I'll preface this by saying I have a spreadsheet with (name/address/phone/email) for a small group of employees in a group that I have been asked to support.

    There is also 2 images (the top image has an embedded url) the bottom image has nothing


    I would like a script that I can give to each person to use to input their information from that spreadsheet (I have the template in a word document) as well as the aforementioned excel spreadsheet that will need to be referenced

    Hope someone can help




    (Also, there is a way to do this via a Group Policy and matching AD I guess the AD is horrible and time consuming to fix) hence going through Excel.


    Thanks again

  2. #2
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Wanted: VBA Script to use for Outlook signatures

    I would include the template on a sheet in the workbook instead of a word document. Then you can use a function to convert the sheet to HTML and use it as the body of the email.

    If you're talking about a Network group policy then it will depend on your schema but I would have to guess not without involving your server group.
    Thanks,
    Solus


    Please remember the following:

    1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    Highlight the code in your post and press the # button in the toolbar.
    2. Show appreciation to those who have helped you by clicking below their posts.
    3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

    "Slow is smooth, smooth is fast."

  3. #3
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,747

    Re: Wanted: VBA Script to use for Outlook signatures

    Hi JDLM

    You don't really describe what you wish to do but from your Thread Title, here's a link to generic Code to insert an Outlook Signature into an Excel generated Outlook Email

    http://www.rondebruin.nl/win/s1/outlook/signature.htm
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  4. #4
    Registered User
    Join Date
    11-04-2013
    Location
    Lenexa, Kansas
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Wanted: VBA Script to use for Outlook signatures

    So here's what I have (this is the "format" that they want to use. The top image has the embdedded url in it


    2n22ooz.png

    Then I have a separate excel spreadsheet with the information that is needed to fill in the information in the format above. The manager wants a script for everyone in the excel spreadsheet so all they have to do is click the vbs and it will insert the format for them.

    ie: name John smith email J.smith@xx.com Address: 123 s 123 st,

    I apologize about mentioning the policy (it was already suggested and not an option) wanted to clear that up before someone else mentioned it.


    Thanks in advance
    Last edited by JDLM66062; 11-04-2013 at 05:38 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Can I trigger a VBA script without pausing Outlook for the duration?
    By baldmosher in forum Outlook Programming / VBA / Macros
    Replies: 5
    Last Post: 08-05-2013, 07:19 AM
  2. VB Script to Pull Outlook Properties for List of IDs or Names
    By navs8603 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-24-2013, 02:18 AM
  3. Sending the Excel file to multiple recipient in outlook application using macro script
    By vigneshwaran in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-19-2012, 03:55 AM
  4. Script to fetch PDF file from Outlook and process it to Excel.
    By neaz1st in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-14-2012, 01:31 PM
  5. Reply to outlook email from excel script
    By theerdman@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-21-2006, 12:00 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1