+ Reply to Thread
Results 1 to 6 of 6

Cannot figure out how to add blank line between pasted ranges in Outlook email body

  1. #1
    Registered User
    Join Date
    08-04-2010
    Location
    United States
    MS-Off Ver
    Office 365 for windows
    Posts
    62

    Unhappy Cannot figure out how to add blank line between pasted ranges in Outlook email body

    Greetings. I managed to piece this code together but no matter what I modify or how I modify it I cannot figure out how to simply insert a blank line between each range that I am pasting into the body. They appear as tables in the email body and I need one line between them. I would really appreciate help. I hope I posted in the right board. A solution that utilizes the inspector and word editor is preferred. =/

    Please Login or Register  to view this content.
    Last edited by lOYvEpi6M87nEoIF0ul8; 07-22-2023 at 10:46 PM. Reason: Clarification

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Re: Cannot figure out how to add blank line between pasted ranges in Outlook email body

    Please Login or Register  to view this content.
    Using the HTML code : & "<br><br>" & creates the empty line.

  3. #3
    Registered User
    Join Date
    08-04-2010
    Location
    United States
    MS-Off Ver
    Office 365 for windows
    Posts
    62

    Re: Cannot figure out how to add blank line between pasted ranges in Outlook email body

    Thank you for your swift and helpful reply. I don't have the code for a function that converts ranges to html but looking it up I found one. The trouble I came across when I tried to use a similar solution that utilized temp files the range data was appearing in the email on my end with the desktop version of Outlook but not in the body of emails for IOS users specifically for some reason. In any case I would really like to stick with manipulating the word editor if I can.

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Re: Cannot figure out how to add blank line between pasted ranges in Outlook email body

    Paste this below your macro for the email :

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    08-04-2010
    Location
    United States
    MS-Off Ver
    Office 365 for windows
    Posts
    62

    Re: Cannot figure out how to add blank line between pasted ranges in Outlook email body

    Thank you.

  6. #6
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Re: Cannot figure out how to add blank line between pasted ranges in Outlook email body

    You are welcome.

+ 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. Need vba to copy body of outlook email ,paste into sheet email in workbook
    By breadwinner in forum Outlook Programming / VBA / Macros
    Replies: 1
    Last Post: 10-12-2022, 08:08 AM
  2. [SOLVED] Generating Outlook Email and inseting chart into email with Text body.
    By Hyperion1571 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-17-2019, 12:41 PM
  3. vba pull data from outlook body of email through email or subject of mail into excel
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-01-2014, 04:37 AM
  4. [SOLVED] Using Exell VBA to launch Outlook Email while separating lines in the body of Outlook.
    By Tazyote in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-27-2013, 01:18 PM
  5. export outlook 2007 email into excel with subject and body of email
    By akulka58 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-25-2013, 02:37 PM
  6. Copy and Paste Union of Ranges/Rows to Outlook Email Body
    By darkhunter in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-10-2012, 01:52 PM
  7. Replies: 2
    Last Post: 08-01-2012, 02:47 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