VBA Email code creates TWO windows

[esvenk]

Hi everyone,
I'm trying to get my excel script to send an email with Outlook (or at least display it so the user can review before sending), and it does it perfectly!...when it's one long script. Trouble is, when I take out the email portion and reference it instead, the whole concotion creates two email windows... even when I change the .display to .send, it sends two emails.

I've pared back the script into its bare essentials, thinking that I must have written some piece of code that was messing it up. No dice. This code still has the same problem.
What am I doing wrong?

Please Login or Register  to view this content.

If you want, you can run the code for yourself. Running the top sub will open one email window, but running the bottom sub (which only references the first sub) will open two. I've tried rearranging the subs, I've tried turning the first sub into a function.

Any ideas?

[6StringJazzer]

I get an error when I try to run the second one. The way the second one is coded is unnecessarily complicated. If you need to have two, try this for the second one. I ran it this way and got only one window:

Please Login or Register  to view this content.

[esvenk]

That works! Thank you!!

[6StringJazzer]

If your question has been answered please mark your thread as "Solved" so that members will know that your problem is solved.

Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

[esvenk]

THREAD TOOLS!!
I looked everywhere for that thread solved thing.
Thank you again