Results 1 to 4 of 4

Thread: Excel and Outlook Integration For email sending with signature file

  1. #1
    Junior Member
    Join Date
    Oct 2011
    Posts
    2
    Rep Power
    0

    Excel and Outlook Integration For email sending with signature file

    Hello,

    Every time I send an email through outlook, I have it designed so a signature appears at the bottom stating my name, department, etc...

    I wanted to integrate outlook and excel for easier email sending.

    I used the following thread to create my email application...

    http://www.excelfox.com/forum/f2/exc...u-outlook-142/

    The only issue now is the signature does not appear at the bottom.

    Is there a way I can use the html signature file at the bottom of my email?

    Thanks!

  2. #2
    Junior Member
    Join Date
    Oct 2011
    Posts
    2
    Rep Power
    0
    I figured it out...

    Instead of programming a separate .html file for the signature and the program to capture, I opted to go with a sendkey method

    Here's my code...

    'Goes to the end of the current email (so signature appears at the bottom)
    SendKeys "{PGDN}", True

    'Goes to the insert tab in the toolbar
    SendKeys "%i"

    'Selects the signature
    SendKeys "s"

    'Press enter to insert the signature
    SendKeys "~"


    Hope this helps everyone...


    Thanks!

  3. #3
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Hi,

    Thanks
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)

  4. #4
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    You can use this link
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

Similar Threads

  1. Replies: 12
    Last Post: 12-10-2019, 09:56 PM
  2. Replies: 26
    Last Post: 10-22-2019, 02:39 PM
  3. Replies: 2
    Last Post: 05-23-2013, 08:08 AM
  4. Replies: 1
    Last Post: 05-22-2013, 01:50 PM
  5. Replies: 4
    Last Post: 03-01-2013, 10:48 PM

Tags for this Thread

Posting Permissions

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