Excel Mail Merge with Outlook

[Wizard23]

Hi,

Is it possible to create a form on excel to have it mail merge with outlook and be sent out to clients ?

I.E. I want to create a document in excel where you can answer questions and those questions get answered for us and put nicely back into excel. If anyone know how this would be setup through a macro or just in general that would be great. All I have found so far is just how you can put in specific names,dates,email etc.

Thanks again !

 

[djprakash1]

Wizard - try this

Dim OutApp As Object
Dim OutMail As Object


DoEvents
On Error Resume Next

Set OutApp = CreateObject("Outlook.Application")
OutApp.session.Logon
Set OutMail = OutApp.CreateItem(0)
On Error Resume Next

With OutMail
.To = "YOURMAIL@TEST.COM"
.Subject = "SUBJECT"
.HTMLBody = "JOBS COMPLETED FOR TODAY...BLAH BLAH BLAH"
.Display
.Send

End With
On Error GoTo 0
OutApp.session.Logoff
Set OutMail = Nothing
Set OutApp = Nothing

 

[Wizard23]

Wizard - try this

Dim OutApp As Object
Dim OutMail As Object


DoEvents
On Error Resume Next

Set OutApp = CreateObject("Outlook.Application")
OutApp.session.Logon
Set OutMail = OutApp.CreateItem(0)
On Error Resume Next

With OutMail
.To = "YOURMAIL@TEST.COM"
.Subject = "SUBJECT"
.HTMLBody = "JOBS COMPLETED FOR TODAY...BLAH BLAH BLAH"
.Display
.Send

End With
On Error GoTo 0
OutApp.session.Logoff
Set OutMail = Nothing
Set OutApp = Nothing

Hi,

This just sends email to one receipeient. I am curious is there a way to create a macro that sends to a list of mutiple recepients in an excel document and then tracks their responses to a questionaire in excel as well??

 

[Wizard23]

Does anyone else have any ideas? Looking for a way to poll data?