Apr 4 2012, 10:48 AM
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?
Apr 4 2012, 10:53 AM
Depends on what code you're using, can you post a sample?
My guess is you may have a line like this:
and you may need to change it to
where "olMail" (or whatever you have) is the variable name for the actual mail item
Apr 4 2012, 10:56 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
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here