Hi there,
I am searching the correct syntax to let the macro "click" on the 'Check Names" button.
The open mail macro and the rest is working perfectly. Just want to hav ethe macro doing the check names
Here's the full macro, which is working fne
Dim MailList
MailList = Range("MailList").Value
'here the mail list gets defined
Range("MailList").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Range("A1").Select
DoEvents
MailList = Range("MailList").Value
Set moft = CreateObject("Outlook.Application")
If moft Is Nothing Then
outl = Shell("outlook.exe")
Set moft = CreateObject("Outlook.Application")
End If
Set mMail = moft.CreateItem(0)
mMail.To = MailList
mMail.CC = ""
mMail.BCC = ""
mMail.Subject = "example "
mMail.Body = "Dear all"
mMail.Display
All I need at the end is the check names task
Thanks in advance for your help
Bookmarks