+ Reply to Thread
Results 1 to 3 of 3

Copy Range with Headers to Outlook Email

  1. #1
    Forum Contributor
    Join Date
    12-11-2012
    Location
    Guadalajara, Mexico
    MS-Off Ver
    Excel 2007 & 2013
    Posts
    101

    Copy Range with Headers to Outlook Email

    Hello,

    I have a sample file attached and was wondering the most effective way to create a macro that would send an email with a range in the body of the email.

    The email has to do with deduction people will be getting and its like this.

    In column H is the list of email addresses, the range on the body of the email is on the same row but from columns C through G and should always include the headers.

    Can someone please help with this?
    Last edited by Leith Ross; 10-23-2019 at 08:52 PM.

  2. #2
    Forum Contributor
    Join Date
    12-11-2012
    Location
    Guadalajara, Mexico
    MS-Off Ver
    Excel 2007 & 2013
    Posts
    101

    Re: Copy Range with Headers to Outlook Email

    I found this code and modified it to add email body and it does not run for some reason:

    Please advise on what I may be doing wrong:

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    12-11-2012
    Location
    Guadalajara, Mexico
    MS-Off Ver
    Excel 2007 & 2013
    Posts
    101

    Re: Copy Range with Headers to Outlook Email

    Ok I solved it: I was putting the strBdy in the wrong place

+ 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. Find the range of a table & copy/past into body of an Outlook email
    By JamesGilchrist in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-28-2014, 08:44 PM
  2. Copy Range of Data from Excel into Outlook Email
    By Vlade777 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-28-2014, 10:07 AM
  3. send selected range in email with default outlook email signature included
    By mdsickler in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-04-2013, 10:50 PM
  4. export email headers to excel from outlook
    By Rainnstar in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 08-03-2012, 05:42 PM
  5. 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