Using VBA to send emails in Outlook - issue

mjayz

New Member
Joined
Sep 18, 2009
Messages
26
Hi

I am using VBA to send multiple emails with attachments. I am using .display so that the people using the macro can review each email before clicking send. On one computer, all the emails pop up one behind the other. The user just has to hit send and it disappears and the next email is behind it. On some other computers (I am at work on a server) the emails all populate in the taskbar down the bottom. The user has to click on the task bar which has a group of 100+ emails and chose one and then hit send. They have to repeat this for every email.

If someone is able to explain why this happens and how to change it, it would be appreciated. I hope I have explained it sufficiently.

Thanks

MJ
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,216
Office Version
  1. 365
Platform
  1. Windows
Which versions of Outlook are being used?
 

Watch MrExcel Video

Forum statistics

Threads
1,122,335
Messages
5,595,569
Members
413,996
Latest member
mabelO

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top