Create an Excel, outlook macro that when replying to an email, select the row of a spreads

Hi guys, hoping you can help here. I receive applications from customers in my applications inbox and was wondering how I can create a macro that, when i open the application, i fill out the relevant information on a spreadsheet, and when replying to the email, I CC the coworker that deals with the application. The message body will use a default signature template plus with the macro, I can enter the row number of the account i just entered, and within the signature, it pulls specific information from that row and puts it in the message body (there are some fields on the spreadsheet that i manually decide and enter where I cant get from the app itself)

Can you share a sample workbook as per the yellow banner above. We can then help you with the code.

There are more columns in my real data, basically just want to extract Product column & Employee Name column for each account application I receive from customers, and put that on the email.

Here you go. Give this code a try. I took the liberty of assuming you might want an email value in column H. You can hard code the value instead. Your first post explanation was not clear to me so let me know if you have questions.

Please Login or Register  to view this content.