+ Reply to Thread
Results 1 to 3 of 3

list of items displayed in same line in the email

  1. #1
    Forum Contributor
    Join Date
    05-13-2019
    Location
    Halifax, Canada
    MS-Off Ver
    2016
    Posts
    172

    list of items displayed in same line in the email

    Hi Gurus,

    I have written the following code to automate email that is sent to one of my colleagues every month. One aspect is that I have got list of items which is dynamic and keeps on changing every month. The following code creates email with signature (in original format), but the list of items is displayed in the same line instead of a new line. I have used the loop to address this issue but it works only when I use plain text email format and not HTML format . I want to use HTML email format to use signature at its original format.


    Please Login or Register  to view this content.
    Can you please suggest code that creates new line for every list item? I appreciate your advice.

    Thank you
    Roshan Shakya

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,606

    Re: list of items displayed in same line in the email

    Change the vbCrLf to HTML < br >

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Forum Contributor
    Join Date
    05-13-2019
    Location
    Halifax, Canada
    MS-Off Ver
    2016
    Posts
    172

    Re: list of items displayed in same line in the email

    Thank you AlphaFrog.

    Much appreciated.

+ 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] Macro to Email set of cells with identified email list and subject line with outlook
    By aaron061883 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-20-2020, 01:18 PM
  2. Replies: 5
    Last Post: 04-11-2020, 05:39 PM
  3. [SOLVED] Remove line items if not found in another list
    By sriley5 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-04-2020, 10:36 AM
  4. [SOLVED] Separate list items on new line working on some Macs and not others
    By dsrt16 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-10-2018, 05:32 PM
  5. [SOLVED] Unigue list from items in each line of list
    By jomili in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 01-12-2016, 04:02 PM
  6. Combine Line Items From Columns/List
    By BrewsterBruiser in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 07-31-2014, 10:17 AM
  7. Replies: 3
    Last Post: 10-08-2008, 10:32 AM

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