Thanks gmayor, this is great!

I used your data as a reference but created my own template and changed the path in the code.

My form works but the button doesn't. The only way I can get it to work is to:

1) Enter the data in the form (not press any of the buttons)
2) Run the macro from Outlook

Only then does it open my email template with the form fields info in it based on where I placed the various ## references.

Will continue to troubleshoot and hopefully find the fix.

Many thanks, your help is much appreciated