+ Reply to Thread
Results 1 to 5 of 5

how to link textbox message as email body using excel VBA code

  1. 01-01-2014, 07:06 PM #1
    yogi_himalayan
    yogi_himalayan is offline
    Registered User
    Join Date
    01-01-2014
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2013
    Posts
    26

    how to link textbox message as email body using excel VBA code

    Happy New Year all, I am novice and seeking assistance for 2 issues I could not resolve by myself.

    1. how to link textbox message as email body
    2. how to link email address on sheets("StoreQuery").Range("I2:I8") in order to send multiple receivers at at time

    I have attached spreadsheet and codes are below. when I run the macro it does not show any error but it does not transfer message in TextBox1 to email body, and same issue with receivers email

    Thanks and just wondering if it can be resolved.

    Kind regards


    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 01-01-2014, 07:35 PM #2
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,213

    Re: how to link textbox message as email body using excel VBA code

    You can't use:

    Please Login or Register  to view this content.

    You'd need to concatenate the ranges using ";"

    For example:

    Please Login or Register  to view this content.

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 01-01-2014, 07:53 PM #3
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,213

    Re: how to link textbox message as email body using excel VBA code

    Actually, you probably need to fully qualify the ranges:

    Please Login or Register  to view this content.

    Regards, TMS
    Reply With QuoteRegister To Reply
  4. 01-01-2014, 08:23 PM #4
    yogi_himalayan
    yogi_himalayan is offline
    Registered User
    Join Date
    01-01-2014
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2013
    Posts
    26

    Re: how to link textbox message as email body using excel VBA code

    Hi TMShucks,

    Thanks you very much, you are genius. It works excellent and I very much appreciate your time and consideration to notify error on my coding.

    wish you all the best

    Kind regards
    Yogi
    Reply With QuoteRegister To Reply
  5. 01-01-2014, 08:40 PM #5
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,213

    Re: how to link textbox message as email body using excel VBA code

    You're welcome. Thanks for the rep.

    Please note that I commented out the error trapping to see where and how it failed. You probably want to put that back.

    Regards, TMS


    If you are satisfied with the solution(s) provided, please mark your thread as Solved.


    New quick method:
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

    Or you can use this way:

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save


    You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Textbox to email body
    By mattress58 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-24-2013, 06:36 PM
  2. email excel spreadsheet as body of message, not as attachment
    By Email Spreadsheet as Body of Email Msg. in forum Excel General
    Replies: 6
    Last Post: 06-18-2012, 01:01 PM
  3. Excel code to email whats in the spreadsheet in the body of email
    By Kain93 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-18-2012, 09:55 AM
  4. Putting a clickable link in the body of email sent from Excel
    By raehippychick in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-19-2008, 06:04 AM
  5. [SOLVED] Copy and paste 2 excel sheets in message body of email
    By rrmando in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-03-2006, 05:10 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1