Create Email from Excel

[JohnDoe0016]

I have an excel sheet which creates an email when clicked. Currently the body of the message only shows the row where the data is (the recipient will need to know the row to complete other tasks required)
I would like to add more text to the body of the email as well as a hyperlink to the file location.

Here is the code in my cell so far.

=IF(COUNTA($A5,$B5,$D5)=3,HYPERLINK("mailto:"&$S5&"?subject=Signature for "&E5&" MPH ("&$A5&"; MPH "&$D5&"; SFC "&$B5&")&Body=Row "&ROW(),"▲"),"")

Columns A (text field), B (Order number), and D (revision of this data) give information and all are required for this form
Column S is a cell with all of the email addresses (will change depending on the values in other cells in that row)
Column E (text) is the category of the data

Any help would be greatly appreciated! I'm using Excel and Outlook 2007 (as will all of the other users)

 

[KB_Miner]

Can you post the macro code? Would be easier to see what changes need to be made to add what you're asking for.

 

[JohnDoe0016]

Can you post the macro code? Would be easier to see what changes need to be made to add what you're asking for.

I currently don't have any macros in this file. I'm pretty inexperienced with that portion of excel. Each row is independent of each other (other than the list of emails which are determined on another sheet) I've made a simple table to show each value in the email function.

[TABLE="width: 100"]
<tbody>[TR]
[TD]Part number
[/TD]
[TD]Order Number
[/TD]
[TD]Revision
[/TD]
[TD]Catagory
[/TD]
[TD]Text Field
[/TD]
[TD]Email function
[/TD]
[TD]Email Addresses
[/TD]
[/TR]
[TR]
[TD]User Entered text
[/TD]
[TD]User entered number
[/TD]
[TD]User entered number
[/TD]
[TD]User selected (drop down)
[/TD]
[TD]User entered text
[/TD]
[TD]email code with hyperlink button
[/TD]
[TD](Based on column D)
[/TD]
[/TR]
</tbody>[/TABLE]