+ Reply to Thread
Results 1 to 2 of 2

E-mail drafer macro leaves the body of the mail blank.

  1. #1
    Forum Contributor Gabor's Avatar
    Join Date
    02-15-2004
    Location
    Székesfehérvár, Hungary
    MS-Off Ver
    xl2016
    Posts
    226

    E-mail drafer macro leaves the body of the mail blank.

    Hello Everyone,

    I have been using the below code to have e-mails drafted, the trigger was a CommandButton on a Userform.
    Please Login or Register  to view this content.
    For some strange reason, it works in one workbook and it doesn't work wfully in another.
    Where it doesn't, the mail is constructed, the recipients are filled ok, the cc-ed addresses ar filled OK, the Subject of the mail is written OK, but the BODY of the mail is left blank.
    I have tried all sorts of comparisons and copyovers, deletions expression by expression, cannot come to grips with what makes the difference.

    Would appreciate any guidance and experience in this matter.
    Thanks
    Regards,

    Gabor

    Protect trees.. maybe one day we need to climb back....

  2. #2
    Forum Contributor Gabor's Avatar
    Join Date
    02-15-2004
    Location
    Székesfehérvár, Hungary
    MS-Off Ver
    xl2016
    Posts
    226

    Re: E-mail drafer macro leaves the body of the mail blank.

    I found the reason.
    If the number of the recipients in Range("MailTo") or in Range("CCto") is too much, the code cannot finish the execution, but it stops after a number of characters.

+ 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. Mail Range/Selection in the body of the mail along with an attachment
    By johnny_canuck in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-27-2013, 05:52 AM
  2. Send e-mail with image on body (.html) on e-mail manager <> outlook
    By mariotnc in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-05-2012, 09:28 PM
  3. Replies: 1
    Last Post: 07-22-2012, 09:26 AM
  4. Word Format as Body of mail using Send mail
    By andy_iyeng in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-19-2012, 05:04 AM
  5. Send E-mail with image in e-mail body
    By ncaravela in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-27-2010, 10:54 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