+ Reply to Thread
Results 1 to 6 of 6

Send email via VBA excel and copy and paste range of cells

  1. #1
    Registered User
    Join Date
    12-02-2011
    Location
    toronto, Canada
    MS-Off Ver
    Excel 2007
    Posts
    27

    Send email via VBA excel and copy and paste range of cells

    I have the below code to send an email via VBA script in excel.

    But I want to copy and paste a range of cells (A6:F28) into the body of the email;



    HTML Code: 

    Can someone please help me out

    Thanks!!
    Last edited by lester.ilao; 11-06-2014 at 12:23 PM. Reason: updated with code tags

  2. #2
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,028

    Re: Send email via VBA excel and copy and paste range of cells

    hi,
    first thing you need to do is to add code tags around your code according to the forum rules!
    then try this and see if it helps you
    Please Login or Register  to view this content.
    Regards, John55
    If you have issues with Code I've provided, I appreciate your feedback.
    In the event Code provided resolves your issue, please mark your Thread as SOLVED.
    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

    ...enjoy -funny parrots-

  3. #3
    Registered User
    Join Date
    12-02-2011
    Location
    toronto, Canada
    MS-Off Ver
    Excel 2007
    Posts
    27

    Re: Send email via VBA excel and copy and paste range of cells

    Hey John -

    Thanks so much for this... but I know I didn't mention this in my post (As I assumed that excel would do this).... But within the range there is a bar chart... was hoping it would pick this up. Any Idea on how to include this?

  4. #4
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,028

    Re: Send email via VBA excel and copy and paste range of cells

    before to be helped by someone please do the first thing I asked you!

  5. #5
    Registered User
    Join Date
    12-02-2011
    Location
    toronto, Canada
    MS-Off Ver
    Excel 2007
    Posts
    27

    Re: Send email via VBA excel and copy and paste range of cells

    all done. thanks

  6. #6
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,028

    Re: Send email via VBA excel and copy and paste range of cells

    some time ago I used this, see if it helps you too.
    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. How to send email from excel using VBA with Cell Range (Including Images) as Email Body
    By Novice_To_Excel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-24-2014, 05:06 AM
  2. Macro to copy paste data as transpose and to send email
    By Shiny in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-14-2014, 04:20 PM
  3. Copy Range of cells and paste into email
    By Shama in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-17-2012, 04:20 AM
  4. Auto Update Macro - Copy/Paste Send Email
    By djfatboyfats in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-25-2009, 08:25 AM
  5. send email with email addresses in a range of cells
    By Craig in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-10-2005, 05:05 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