+ Reply to Thread
Results 1 to 8 of 8

is there a way to add a button to an outlook html body programmatically from within Excel

  1. #1
    Valued Forum Contributor dmcgov's Avatar
    Join Date
    11-11-2015
    Location
    Florida, USA
    MS-Off Ver
    Office 365 Business
    Posts
    1,518

    is there a way to add a button to an outlook html body programmatically from within Excel

    So i have some code that creates (from within an Excel macro) an email, attaches a PDF file and inserts a file download link (from the network). all that is working great.

    but now i want to insert a commandbutton in to the body of the email but by way of VBA

    can that be done? if yes, how?

    thanks

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: is there a way to add a button to an outlook html body programmatically from within Ex

    What do you want to happen when they press the button? I'm not sure it's even possible to do that in the user interface. There is no VBA attached to emails to run if a button is pressed.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: is there a way to add a button to an outlook html body programmatically from within Ex

    Unless, it's just image that redirects you to url
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

  4. #4
    Valued Forum Contributor dmcgov's Avatar
    Join Date
    11-11-2015
    Location
    Florida, USA
    MS-Off Ver
    Office 365 Business
    Posts
    1,518

    Re: is there a way to add a button to an outlook html body programmatically from within Ex

    so i have a few macros that i would attach to buttons so it could be any action. but some ideas would be to update a networked spreadsheet, update the corresponding pdf, attach a scanned copy of a check, send emails to vendors, etc.

    so am i asking something that hasn't been done before?

  5. #5
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: is there a way to add a button to an outlook html body programmatically from within Ex

    Code cannot travel with email. So can't really see how this can be done.

    Now, adding button to your Outlook ribbon, that's another story. But in email body... I can't think of way to do it.

  6. #6
    Valued Forum Contributor dmcgov's Avatar
    Join Date
    11-11-2015
    Location
    Florida, USA
    MS-Off Ver
    Office 365 Business
    Posts
    1,518

    Re: is there a way to add a button to an outlook html body programmatically from within Ex

    putting a button on the ribbon is going to be the next step then. i need to ask a question on scanning incoming email subject lines, keep it in the same thread or create a new one?

  7. #7
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: is there a way to add a button to an outlook html body programmatically from within Ex

    If you use Office 365, depending on action... I'd just use flow rather than VBA. But yes, best to ask in new thread.

  8. #8
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: is there a way to add a button to an outlook html body programmatically from within Ex

    If you put a button under the ribbon, it's only going to be on your ribbon. If you are trying to make functionality available to an email recipient, it can't be done through Outlook. As CK76 suggests, you might want to look into Microsoft Flow.

+ 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. How to change colour code on HTML.BODY for outlook emails
    By Joy079 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-23-2019, 08:42 PM
  2. html body and default Outlook signature??
    By michud08 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-03-2017, 11:11 AM
  3. [SOLVED] Send Table/Range of Cells As Part of Body through Outlook(HTML) using VBA
    By richardking in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-30-2016, 08:58 PM
  4. [SOLVED] Vba to draft html body in outlook
    By arun.sj in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 07-15-2015, 07:37 AM
  5. Using HTML Body Format in Outlook mail
    By akash kothari in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-08-2014, 11:33 AM
  6. Excel ws into outlook html body with current html signature
    By Cadelanne in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-29-2014, 09:03 AM
  7. Problem with copying charts into html body outlook
    By katekatebobs in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 12-13-2013, 02:16 PM

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