+ Reply to Thread
Results 1 to 2 of 2

VBA code to draft outlook email from excel sheet

  1. #1
    Registered User
    Join Date
    07-31-2021
    Location
    Darwin, Australia
    MS-Off Ver
    Office 365
    Posts
    1

    VBA code to draft outlook email from excel sheet

    I'm trying to send email from excel sheet using vba code. The problem i'm facing email body lost all formatting for example bold, font size and line break etc.
    i have attached the sheet and here is the vba code which exactly i want to do it. But I don't know how to use sheet cell range in this code.

    code.jpg





    And required outcome:

    outlook outcome.jpg
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: VBA code to draft outlook email from excel sheet

    In your VBA code, if you specify the body format, would that fix the issue? For example, in your sub-routine, add this line under xOutMail with statement.
    Please Login or Register  to view this content.

+ 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. Create MS Outlook Email from Excel and Save to Draft Folder
    By jski21 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-07-2020, 05:55 AM
  2. Replies: 1
    Last Post: 04-27-2016, 09:39 PM
  3. [SOLVED] VBA code required to draft emails in outlook taking excel inputs.
    By mchilapur in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-12-2015, 03:56 PM
  4. how to creat an email draft in outlook using excel macros
    By jeethu570 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-02-2015, 08:30 AM
  5. Macro to send saved draft email from outlook in HTML format
    By jamesshakedown in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-18-2013, 07:55 AM
  6. Copy data from excel to Outlook new email and create draft.
    By G.Bregvadze in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-08-2013, 03:31 AM
  7. Excel Hyperlink send email draft via outlook
    By Sithorce in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-31-2013, 10:37 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