I was hoping someone might be able to help me with a straight-forward macro. I send out a lot of confirmation emails through an internal database that opens up an email in Outlook and fills the body of the message with an outdated reply I can't change. So every time I do this I have to delete everything in the email except the unique link the database enters and replace it with what I use now. Below is an edited version of the email:
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Hi Name,

It was great speaking with you a few minutes ago. As I mentioned, below, please find the link to your personal profile on our Company Name website.

Once you have input your hourly rate, reviewed our T&Cs (just by clicking the two “I agree” buttons at the bottom of each of the two scroll through bars) and uploaded a bio, I will then forward it over to our client and be back in touch to introduce the two of you and work on matching up schedules for getting you on the phone.

Link: Link URL


Best Regards,

First Last
Analyst
Company Name LLC
9999 Street Address
Somewhere, ST 99999
Phone: 999-999-9999
Cell: 999-999-9999
Email: [email protected]

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

I need the macro to remove all of the text from the message with the exception of the line with the "Link: Link URL", and then replace it with what is provided above.. The URL will always be unique, but only the last part of it is variable, so i.e. http://www.companyname.com/something/unique

The signature at the bottom of the email is stored in my outlook as the default signature, so the macro would be able to source that from there.

I would greatly appreciate any help. This would save a lot of time in my day. Thank you in advance.