Alright. So, I have the form all set up. What I need now is a way to take that form and put it into the body of an Outlook email. Any Pointers?
Thanks in advance.
Alright. So, I have the form all set up. What I need now is a way to take that form and put it into the body of an Outlook email. Any Pointers?
Thanks in advance.
Yes. Do some googling/bing and see if you can find an example of what you're trying to do. Then use/adapt that code to you situation.
you will have to recreate the form in the .body of the email vba code.
use vbcrlf and spaces to arrange the layout you want. get the field data by using me.field1...
you can add lines boxes and colors to make it look like your form, you can even use HTML formatting if you like.