+ Reply to Thread
Results 1 to 4 of 4

Trying to create an email with certain details based on what has come from input Boxes

  1. #1
    Registered User
    Join Date
    12-11-2013
    Location
    auckland
    MS-Off Ver
    Excel 2010
    Posts
    49

    Question Trying to create an email with certain details based on what has come from input Boxes

    Hi Experts,

    I have an interesting one here that I have tried all my efforts on however am officially stumped.

    I am trying to generate an email based on a layout that will always stay the same except a few details will always change, so I have decided to use input boxes to help streamline things for the user.

    The below code works up to a point however there are a few errors (vbYesNo, Hyperlink, Enter spacing) and this is a Frankenstein's monster kind of code... Any help would be greatly appreciated, my issues are noted in the code

    Please Login or Register  to view this content.
    I also apologise if this code is the worst anyone has seen, but we all start somewhere and learn along the way

    Thanks team.
    Last edited by morangeman; 07-05-2018 at 05:40 PM. Reason: failed to read... Im sorry

  2. #2
    Forum Contributor
    Join Date
    09-21-2009
    Location
    Belgium - Mechelen
    MS-Off Ver
    Office 365
    Posts
    274

    Re: Trying to create an email with certain details based on what has come from input Boxes

    Apologies.
    Wrong code given.
    Last edited by MarMo; 07-06-2018 at 05:17 AM. Reason: wrong answer in forum
    Even a little help can be a big help !!
    1. A sample workbook says more then words. Add problem description and solution so we can understand the problem.
    2. Your appreciation is accepted by clicking the star "Add Reputation" at the lower left of the post.
    3. If your problem is solved, mark it as [SOLVED]: See "FAQ : " https://www.excelforum.com/faq.php
    4. Use [CODE] [/CODE] tags to illustrate your code: see here

  3. #3
    Registered User
    Join Date
    12-11-2013
    Location
    auckland
    MS-Off Ver
    Excel 2010
    Posts
    49

    Re: Trying to create an email with certain details based on what has come from input Boxes

    Quote Originally Posted by MarMo View Post
    Apologies.
    Wrong code given.
    Thanks for your response.... Any ideas what the correct code was? I'm unable to see what you originally submitted.

  4. #4
    Forum Contributor
    Join Date
    09-21-2009
    Location
    Belgium - Mechelen
    MS-Off Ver
    Office 365
    Posts
    274

    Re: Trying to create an email with certain details based on what has come from input Boxes

    I thought this was a post in Excel VBA forum, that's why i didn't post the code.
    But you'd like to see what it was.

    This workd in Excel, but it might also work in Outlook.
    Perhaps you can test it or modify it to your needs.

    THe HTMLBody part is not working in this code.
    Maybe you need to ask for it in another thread.

    Please Login or Register  to view this content.
    Last edited by MarMo; 07-09-2018 at 03:33 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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