+ Reply to Thread
Results 1 to 2 of 2

Can't enter more than 1 line of text in body of email

  1. #1
    Registered User
    Join Date
    07-24-2013
    Location
    NJ
    MS-Off Ver
    Excel 2010
    Posts
    7

    Can't enter more than 1 line of text in body of email

    Hi, I am pretty new to VBA but can follow the coding logic somewhat easily...

    I know this has been addressed before, but I have tried several variations based on others' answers and still can't get this code to add anything into the body. I want it to greeet the user by name (the value in the cell before the email address) and then have another line of text below that. Any suggestions?

    Thank you much!

    Please Login or Register  to view this content.

  2. #2
    Forum Contributor
    Join Date
    08-08-2005
    Location
    Kansas, USA
    MS-Off Ver
    2016
    Posts
    293

    Re: Can't enter more than 1 line of text in body of email

    in Strbody, add "& vbNewLine " for a new line

+ 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. Body Text in Email
    By nickysquawkes in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-05-2013, 03:38 PM
  2. Multi line email body from HYPERLINK CONCATENATE MAILTO?
    By JRR007 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-23-2012, 08:18 AM
  3. [SOLVED] Create macro to send worksheet as body of email using cells as subject line
    By LindaABH in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-16-2012, 07:43 PM
  4. Replies: 4
    Last Post: 02-27-2012, 03:13 AM
  5. [SOLVED] Email Body Text & Signature
    By Darrell Lankford in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-07-2006, 12:55 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