Excel Marco: Compose Mail from Excel

[Vibu212]

Please Login or Register  to view this content.

Hello,

I have the above code. The code will compose a new email with a selective subject based on a cell.

Now, I came up with this coding using internet resources but could not get it to output a cell value (string) as the subject of the email. Is it possible? If then how should I approach it?

In a sense, I want the subject to be

"<Cell Value> Vendor Request"

Thanks in advance!

Edit:

I put in

Please Login or Register  to view this content.

but gave me error

[tarquinious]

I want the subject to be
"<Cell Value> Vendor Request"

I have changed the following lines in your above code. This might work a little better for you:

Please Login or Register  to view this content.