Send email outlook with table on body

  • Re: Send email outlook with table on body


    Try this, note the comments in the code which show what you need to change to suit your particular needs.


    Simply assign the SendEmail code to your button.

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

  • Re: Send email outlook with table on body


    Hello,


    Try this code, this will send the mail from Excel workbook using MailEnvelope. Note if you dont want to send comment the .send line.


    Thanks
    Vijay.S



  • Re: Send email outlook with table on body


    Try this, note the comments in the code which show what you need to change to suit your particular needs.


    Simply assign the SendEmail code to your button.


    I'm very close now what i want is to select range of that table that is C15:E25 in the same sheet where my button is. can you please tell me which line will i need to change to get that range

  • Hi,


    Just replace this line #8


    Code
    1. Set rng = ActiveSheet.Cells(1).CurrentRegion


    by your own range :


    Code
    1. Set rng = Range("C15:E25")


    Hope this will help

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Like" icon ...just below...in the bottom right corner...:)