Jojothemonk3y
New Member
- Joined
- Feb 1, 2017
- Messages
- 5
Hello!
I would like to send an email from excel that has a pre-populated body of text that but also pulls some data from an excel sheet to populate parts of the email.
So for example, you would click the macro....a prompt would ask for a row number and based on that, the email box would pop with a prewritten body that would pull information from specified columns in the sheet that completes certain sentences (eg Your order ref (contents of B4)). Additionally it would also attach a specified document from a local drive It wouldn't need to populate the email address.
I'm not sure if this is possible? Any ideas?
Thanks in advance!
I would like to send an email from excel that has a pre-populated body of text that but also pulls some data from an excel sheet to populate parts of the email.
So for example, you would click the macro....a prompt would ask for a row number and based on that, the email box would pop with a prewritten body that would pull information from specified columns in the sheet that completes certain sentences (eg Your order ref (contents of B4)). Additionally it would also attach a specified document from a local drive It wouldn't need to populate the email address.
I'm not sure if this is possible? Any ideas?
Thanks in advance!