Hello all,

I created a userform for Outlook that populates an email based on what the user chooses and enters in userform1. This works fine when I create a new email, but when I choose an Excel File or any type of file and send to mail recipient the combobox draws a blank in userform1. How do I fix this?

Here's the code for userform1.

Please Login or Register  to view this content.

and my module code..


Please Login or Register  to view this content.

Please let me know if you need more information. Thanks!