+ Reply to Thread
Results 1 to 3 of 3

Body of an email using multiple strings from an array

  1. #1
    Registered User
    Join Date
    01-17-2017
    Location
    NEW JERSEY
    MS-Off Ver
    10.0
    Posts
    28

    Body of an email using multiple strings from an array

    Hi.

    I have multiple strings stored in array like this:

    Please Login or Register  to view this content.
    I would like to create a body of an email with each string from the array on a separate line. How do i do that?

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Body of an email using multiple strings from an array

    Try

    Please Login or Register  to view this content.
    Martin

  3. #3
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Body of an email using multiple strings from an array

    You could try Join.
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

+ 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. Macro to put Items in array for email body HELP PLEASE!
    By cory0789 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-18-2016, 10:09 PM
  2. vba insert multiple ranges from excel to body of email
    By Angie28 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-25-2015, 07:18 PM
  3. [SOLVED] Trying to use multiple named ranges in the body of an automatically sent email from Excel
    By Jo2710 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-18-2014, 12:01 AM
  4. Need to attach Image from special folders(multiple platforms), into body of email
    By kingkyle2005 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-19-2013, 11:26 AM
  5. Replies: 2
    Last Post: 05-09-2013, 09:56 PM
  6. Placing an array into the body of an email
    By prestopr in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-12-2013, 07:53 AM
  7. Macro to add two dimensional string array as email body.
    By duran16 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-01-2012, 01:14 PM

Tags for this Thread

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