usmc_tanks
New Member
- Joined
- Mar 19, 2018
- Messages
- 10
Hello!
I'm hoping I explain this correctly but what I'm trying to do is use vba to send an email where the selected range is added to the body of the email and at the same time add the same selected range as an attachment to the email.
I'm currently using Ron de Bruin's "Mail Range/Selection in the body of mail" http://www.rondebruin.nl/win/s1/outlook/bmail2.htm vba which works perfectly but I now need to email it as an attachment as well. I again used Ron de Bruin's "Mail Range or Selection" http://www.rondebruin.nl/win/s1/outlook/amail4.htm vba but I somehow need to compile these two vba so I'm not sending two separate emails (one with the range selection in the email body and another with the range selection as an attachment). Is there a way I can combine these two vba? Thanks in advance!
I'm hoping I explain this correctly but what I'm trying to do is use vba to send an email where the selected range is added to the body of the email and at the same time add the same selected range as an attachment to the email.
I'm currently using Ron de Bruin's "Mail Range/Selection in the body of mail" http://www.rondebruin.nl/win/s1/outlook/bmail2.htm vba which works perfectly but I now need to email it as an attachment as well. I again used Ron de Bruin's "Mail Range or Selection" http://www.rondebruin.nl/win/s1/outlook/amail4.htm vba but I somehow need to compile these two vba so I'm not sending two separate emails (one with the range selection in the email body and another with the range selection as an attachment). Is there a way I can combine these two vba? Thanks in advance!