Dear's I am beginner to VBA programming and just in the start trying to convert excel 2003 macro to excel 2010 used to send emails to a list of emails with attachments. I made a new file and pasted macro 2003 code in macro enable excel 2010 file. When I tried to run a macro it returns subject error.

After googling a bit I came to know that "Hasroutingslip" property has been deprecated in office 2007 and someone suggested to use "Sendmail" option. Below is the code.
Can anyone please tell me in beginner mode that how to convert below code to Excel 2010 VBA code

Prompt response from pro's is requested.

Code:

ActiveWorkbook.HasRoutingSlip = True
With ActiveWorkbook.RoutingSlip
.Delivery = xlAllAtOnce
.Recipients = Array(x, y, z, z1)
.Subject = "subject"
.Message = "body text."

End With
ActiveWorkbook.Route