MS Excel / VBA help thread

You are reading a single comment by @christianSpaceman and its replies. Click here to read the full conversation.

•

aggi in reply to @Chalfie

Remove .Display and replace with .Send and lose the two lines after that (the two lines are basically wait for two seconds and then send Alt+S which is the keyboard shortcut for send in Outlook, a bit of a workaround for someone who didn't know how to send automatically).

•

christianSpaceman in reply to @aggi

Could be wrong, but from memory I don't think you can do the .Send. I think it asks for confimation, which is why you use the Display / SendKeys to send it for you.

•

Sam_w in reply to @christianSpaceman
Could you use .send and disable alerts using
```
Application.DisplayAlerts = False
```

About

Avatar for christianSpaceman @christianSpaceman started