+ Reply to Thread
Results 1 to 2 of 2

Email Range but add large Body of Words

  1. #1
    Forum Contributor
    Join Date
    03-14-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    491

    Email Range but add large Body of Words

    Hi,

    How can I alter the below code to allow me to add words to the range I intend to send in my email?
    it may be a large body of words...

    Please Login or Register  to view this content.

  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,740

    Re: Email Range but add large Body of Words

    Using a MailEnvelope in VBA is quite different than composing an email. There is no body attribute. Instead, use the Introduction attribute, which will allow you to insert text in the body of the email.

    Please Login or Register  to view this content.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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] Adding a Range to an Email Body
    By djfatboyfats in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 08-13-2014, 11:29 AM
  2. [SOLVED] sending email with specific range as email body vba modification
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-19-2014, 11:24 AM
  3. How to send email from excel using VBA with Cell Range (Including Images) as Email Body
    By Novice_To_Excel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-24-2014, 05:06 AM
  4. Problem using loop for sending excel range in email body using Range to HTML code
    By drajanm in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-24-2012, 03:17 AM
  5. [SOLVED] Send range to email body
    By VBA FTW in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-01-2012, 05:59 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