+ Reply to Thread
Results 1 to 12 of 12

Remove Paragraph from Email Macro

  1. #1
    Registered User
    Join Date
    12-06-2019
    Location
    Romania
    MS-Off Ver
    2016
    Posts
    22

    Remove Paragraph from Email Macro

    Hello,
    I have added a few bullets to my email macro but the problem is that i am getting a paragraph before Line 1, and don't know how to remove it

    Please Login or Register  to view this content.
    The result:
    "
    Hello,

    Please find attached a report

    The items that are listed below are only a combo of:
    ### this line is a paragraph, i want to remove this empty line ###
    • Line1
    • Line2
    • Line3

    Roland
    "

    Any ideas ?
    Thank you.

  2. #2
    Valued Forum Contributor
    Join Date
    12-01-2011
    Location
    Philippines
    MS-Off Ver
    Excel 2016
    Posts
    949

    Re: Remove Paragraph from Email Macro

    why not just use text instead of html and use the bullet symbol --> •

  3. #3
    Registered User
    Join Date
    12-06-2019
    Location
    Romania
    MS-Off Ver
    2016
    Posts
    22

    Re: Remove Paragraph from Email Macro

    I just tried.
    Did not think about using the bullet simbol, good idea.
    But the problem is i can not get it to indent
    & " • Line1<br>" _
    & "• Line2<br>" _
    Result:
    • Line1 'the space's are not showing
    • Line2

  4. #4
    Valued Forum Contributor
    Join Date
    12-01-2011
    Location
    Philippines
    MS-Off Ver
    Excel 2016
    Posts
    949

    Re: Remove Paragraph from Email Macro

    Please Login or Register  to view this content.
    Last edited by k1dr0ck; 12-09-2019 at 03:04 AM.

  5. #5
    Registered User
    Join Date
    12-06-2019
    Location
    Romania
    MS-Off Ver
    2016
    Posts
    22

    Re: Remove Paragraph from Email Macro

    Does not work.
    i get this result: "Hello, Please find attached a report The items that are listed below are only a combo of: • Line1 • Line2 • Line3 Roland."
    vbnewline does not work in html
    i just want now to add a "tab" or a few "spaces" before "_____• Line1"

  6. #6
    Valued Forum Contributor
    Join Date
    12-01-2011
    Location
    Philippines
    MS-Off Ver
    Excel 2016
    Posts
    949

    Re: Remove Paragraph from Email Macro

    Please Login or Register  to view this content.
    Last edited by k1dr0ck; 12-09-2019 at 03:14 AM.

  7. #7
    Registered User
    Join Date
    12-06-2019
    Location
    Romania
    MS-Off Ver
    2016
    Posts
    22

    Re: Remove Paragraph from Email Macro

    that is exactly how it is now.
    it still does not add spaces or a tab's lenght "___" before "• Line1"

  8. #8
    Valued Forum Contributor
    Join Date
    12-01-2011
    Location
    Philippines
    MS-Off Ver
    Excel 2016
    Posts
    949

    Re: Remove Paragraph from Email Macro

    does this work?
    *5 spaces before the bullet symbol

    Please Login or Register  to view this content.
    Quote Originally Posted by Rolly_Sefu View Post
    that is exactly how it is now.
    it still does not add spaces or a tab's lenght "___" before "• Line1"

  9. #9
    Registered User
    Join Date
    12-06-2019
    Location
    Romania
    MS-Off Ver
    2016
    Posts
    22

    Re: Remove Paragraph from Email Macro

    NO, result is the same: "• Line1"

  10. #10
    Valued Forum Contributor
    Join Date
    12-01-2011
    Location
    Philippines
    MS-Off Ver
    Excel 2016
    Posts
    949

    Re: Remove Paragraph from Email Macro

    hmmm html does not recognize leading spaces inside quotes, never knew that

    last option is &emsp:

    Please Login or Register  to view this content.
    or this

    Please Login or Register  to view this content.
    if that does not work, i have no idea anymore

  11. #11
    Registered User
    Join Date
    12-06-2019
    Location
    Romania
    MS-Off Ver
    2016
    Posts
    22

    Re: Remove Paragraph from Email Macro

    "& "&emsp;• Line1<br>" _" this is working.
    Thanks.

  12. #12
    Valued Forum Contributor
    Join Date
    12-01-2011
    Location
    Philippines
    MS-Off Ver
    Excel 2016
    Posts
    949

    Re: Remove Paragraph from Email Macro

    glad to know it worked, if this has solved your problem you can now mark this thread as solved.

+ 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. Adding a Text/Paragraph using Macro
    By Prevax in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-08-2017, 03:57 PM
  2. Remove Duplicate Email from VBA generated email
    By Mitchell28 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-17-2015, 01:16 PM
  3. [SOLVED] Userform... (¶) how to remove the paragraph symbol?
    By ricku87 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-22-2013, 12:38 PM
  4. [SOLVED] Macro to check for words in a given paragraph !
    By kinirobin in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 08-21-2012, 12:58 PM
  5. Macro to remove duplicates and send email?
    By Milet in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-17-2011, 04:55 PM
  6. [SOLVED] Import a Code to a paragraph using a formula or macro!
    By Manos in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-11-2006, 09:55 AM
  7. Remove the paragraph space.
    By kumawat_s in forum Excel General
    Replies: 1
    Last Post: 05-12-2005, 09:28 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