Results 1 to 3 of 3

Outlook email. Help with text within the body

Threaded View

  1. #1
    Registered User
    Join Date
    10-13-2015
    Location
    York, England
    MS-Off Ver
    VISTA
    Posts
    3

    Outlook email. Help with text within the body

    I have a macro which opens an excel file, updates it, then attaches it to an Outlook email. Rather than showing what appears within the body of the email as separate text (as shown in my example), I would like to use text from a range of cells within a specific tab in the active workbook. For space reasons I have only shown the following part of the macros. Can anyone help?
    emailItem.Body = "Hi," & vbNewLine & vbNewLine & "Please find attached, Weekly Error Log." & _
        vbNewLine & vbNewLine & _
        "Kind Regards," & vbNewLine & _
        "Retail Accounts Team"
    emailItem.Attachments.Add ActiveWorkbook.FullName
    Administrator's note: Please take the time to review our rules. There aren't many, and they are all important. Our guidelines recommend code tags. I have added them for you this time because you are a new member. --6StringJazzer


    Thank you
    Last edited by 6StringJazzer; 09-12-2024 at 04:42 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How to add text to the body of an Outlook email from Excel
    By worthmw in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-07-2020, 08:31 PM
  2. VBA Outlook Email: Replace a text in the body by a cell value
    By ClaudiaRovastino in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-18-2020, 02:53 PM
  3. [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
  4. Importing body text from Outlook email to Excel throws up an error
    By BanginMyHeadOnMyDesk in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-18-2019, 03:07 PM
  5. [SOLVED] I need the body of my Outlook email to look like the source worksheet (wrapped text)
    By aliciaward1001 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-03-2018, 12:18 PM
  6. Add to Excel from Outlook when a email body contain a specific text
    By mathewfer in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 05-08-2013, 08:28 AM
  7. Outlook : Auto Save Email body to Word / Text
    By sgcareerman in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-04-2012, 10:23 AM

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