Automation of email sending from Excel...

[Fester675]

[TABLE="class: grid, width: 700"]
<tbody>[TR]
[TD]NAME (A1)
[/TD]
[TD]EMAIL (B1)
[/TD]
[TD]SUBJECT (C1)
[/TD]
[TD]TEXT (D1)
[/TD]
[TD]ATTACHMENT (E1)
[/TD]
[/TR]
[TR]
[TD]Andy (A2)
[/TD]
[TD]ah@mail.com
[/TD]
[TD]Auto email
[/TD]
[TD]Dear (insert name) Andy
This is a sample of the body text to be included in the email message.
Signature
[/TD]
[TD]Attach PDF 1
[/TD]
[/TR]
[TR]
[TD]Harry
[/TD]
[TD]hj@mail.com
[/TD]
[TD]Auto email
[/TD]
[TD]Dear (insert name) Harry
This is a sample of the body text to be included in the email message.
Signature
[/TD]
[TD]Attach PDF 2

[/TD]
[/TR]
</tbody>[/TABLE]
Here is a sample of my Excel sheet. Is it possible to create one Command Button that will open Outlook, paste the email address (column B) in the TO field; the subject (column C) into the subject field; Text (D) into the main body, while inserting the recipients name; attach the file (E) and SEND?

So, for instance, I hit the button and for each individual row, there will be an email in Outlook generated, the TO/SUBJECT/BODY (including recipient's name)/ATTACHMENT all completed and sent from a particular/shared mailbox.

The real file will have approximately 200 to complete.

Thank you in advance!!