• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to copy the contents of excel to body of the email?

S

sn151

New Member
I have a spreadsheet where I have some data and a button. i would like a macro to automatically copy the contents of a specified range in the excel to the body of the email on a button click.

Please help me on this.

Thanks in advance... :)
 

Attachments

sn151 said:
No I havent used anything. I think macro recorder will not work for this case.
Click to expand...
Hi, sn151!
If I were you I'd use the macro recorder, do the stuff, and then check what I get. Surely it'll help a lot, if not fully.
Regards!
 
Hi bobhc,

I tried the code given in the link tat u sent. but it is sending the content as an attachment. It is not copying and pasting it to the body of outlook email. What to do?
 
Hi, sn151!
Glad you solved it. Thanks for your feedback and welcome back whenever needed or wanted.
Regards!
 
sn151

If you had taken a momment or two to look aroud rondebruin site you would have found the answer for yourself!!
Did you actualy vist it the site before SirJB7 did all the work for you?
 
@b(ut)ob(ut)hc
Hi, my ancient friend!
Good afternoon.
That's what I had to do to find the posted links. I knew they should be there around. ;)
Regards!
 
You must log in or register to reply here.
Back
Top