Hi,

I've a send email code in Excel that works fine but I would like to view the emails that the code generates instead of it sending it automatically. How do I view the emails first in Outlook before it sends out automatically?

Thank you.

Depends on what code you're using, can you post a sample?

My guess is you may have a line like this:

olMail.Send

and you may need to change it to

olMail.Display

where "olMail" (or whatever you have) is the variable name for the actual mail item



This post has been edited by ipisors: Apr 4 2012, 10:55 AM

PS, all of what I said applies only if you're actually manipulating Outlook, either thru early or late binding (Outlook library reference, or Create Object). If you're using something like ThisWorkbook.SendMail, then I'm not entirely sure...post the code you're using now