VBA Email Sending

[tlrobinson512]

Hello,

I am searching for the solution to being able to send an autoemail based on the email address entered into a specific cell in Excel.

I have been successful in writing a code for calling up a macro that has a specific email address in it and sending the auto email via outlook, but in this case, the user inputs their name and email address into two cells, and I want it to pick up that email address in cell "D24" and send an auto response. Any help would be GREATLY appreciated!! I am a novice VBA user. The email would be sent upon clicking of the command button I have in the sheet.

 

[tlrobinson512]

In case anyone ever needs this, I was given the piece of the puzzle in this code. It is below.

Dim myApp As Outlook.Application, myMail As Outlook.MailItem
Set myApp = New Outlook.Application
Set myMail = myApp.CreateItem(olMailItem)
myMail.To = Cells(22, 4)
With myMail
.Subject = "Your Request " & "Ref No. " & Cells(7, 4)
.Body = "Thank you for submitting your request. We have received your request and will begin prcoessing it immediately. Please allow 30 days for resolution." & vbCrLf & vbCrLf
.Send
End With
Set myApp = Nothing
Set myMail = Nothing