Having a problem with compiling

I have a VB code that checks through various tables in a database and sends out emails as needed.
The code uses Outlook to send the email.
When I run the code in VB, it works fine; checks all the tables, asks me if I want to allow Outlook to run, then sends the emails.
However, when I compile the program and run the exe file, it does nothing; it just automatically ends as if there were no emails to send out.
Anyone have any ideas as to why this would be happening? Any help would be greatly appreciated.