Add attachment to email and copy a range into email body

[hillmas83]

Hi,

I have followed the code set by Ron de Bruin below

https://www.rondebruin.nl/win/s1/outlook/bmail2.htm

i now have two modules. One will create an email with an attachement, the other will create an email with a range from one of my sheets pasted into the body of the email.

For some reason, i am unable to combine the two. Please help.

I just need a way to copy one sheet and add it as an attachement, then copy another sheet and add that as the email body.

thanks,
M

 

[Trevor G]

What have you tried to combine the 2 procedures?