+ Reply to Thread
Results 1 to 3 of 3

Move text from textbox to body of new email message

  1. #1
    Registered User
    Join Date
    11-11-2014
    Location
    Boston, Massachusetts
    MS-Off Ver
    MS Office 2007
    Posts
    2

    Move text from textbox to body of new email message

    Hello,

    I am trying to move text from a TextBox in Excel to the body of an email and keep the formatting of the text (font, color). Is this possible with a simple TextBox? Any help is appreciated.

    -Tucker

  2. #2
    Registered User
    Join Date
    11-06-2014
    Location
    India
    MS-Off Ver
    2010
    Posts
    4

    Re: Move text from textbox to body of new email message

    Hi

    W can able to add the text to email body from text box but we can't except the same font and color.
    Text from the excel cells are able to add in email body with same format (font and color).

    I have tried and woks fine for Excel cell value coopy to email body and subject.

  3. #3
    Registered User
    Join Date
    11-11-2014
    Location
    Boston, Massachusetts
    MS-Off Ver
    MS Office 2007
    Posts
    2

    Re: Move text from textbox to body of new email message

    Hi Jeffri,

    I tried to set .Body = ws.Range("A1").value but it still did not carry over formatting. Is it maybe a security issue?

    -Tucker

+ 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. [SOLVED] Createing Email from Userform - Body of email contain content from textbox
    By honger in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-10-2014, 08:44 PM
  2. [SOLVED] how to link textbox message as email body using excel VBA code
    By yogi_himalayan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-01-2014, 08:40 PM
  3. Textbox to email body
    By mattress58 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-24-2013, 06:36 PM
  4. possible to write email body in userform's textbox?
    By dan2010 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-29-2010, 05:12 AM
  5. [SOLVED] Body message - email
    By al007 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-24-2006, 07:10 AM

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