+ Reply to Thread
Results 1 to 4 of 4

VBA to open a new email, (outlook) add the recipient, and the subject of 'Issue Found'

  1. #1
    Forum Contributor
    Join Date
    11-02-2011
    Location
    Rugby, England
    MS-Off Ver
    Office 365
    Posts
    846

    VBA to open a new email, (outlook) add the recipient, and the subject of 'Issue Found'

    Morning Happy campers,

    In one of my worksheets i would like to add a command button that when clicked will do the following (Outlook will always be open)

    *Open new blank email
    *Add the recipeint - surname, [email protected]
    *Add the subject title of 'Issue found'

    Then the user would only need to add the main text body and hit send.

    The email recipient will always be the same, as will the subject title.
    So far i can get Excel to open outlook, but it opens the program not a new email. Shell ("OUTLOOK")

    Kind regards, galvinpaddy

  2. #2
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,028

    Re: VBA to open a new email, (outlook) add the recipient, and the subject of 'Issue Found'

    something like this...
    Please Login or Register  to view this content.
    Regards, John55
    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.

    ...enjoy -funny parrots-

  3. #3
    Forum Contributor
    Join Date
    11-02-2011
    Location
    Rugby, England
    MS-Off Ver
    Office 365
    Posts
    846

    Re: VBA to open a new email, (outlook) add the recipient, and the subject of 'Issue Found'

    Thank-you very much indeed
    Solved & rep added.

  4. #4
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,028

    Re: VBA to open a new email, (outlook) add the recipient, and the subject of 'Issue Found'

    thx! glad it helped you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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