Where can I get the promo code auto-mailer script from the xls-table using Outlook?

Question

Automation

Good evening!
Given:
There is an xls-table with 1000 promotional codes.
A person receives emails according to a certain template. The text of the letter contains the request identifier and the e-mail for the response.
A person copies an identifier from the letter, pastes it opposite the first unassigned promo code, copies the promo code, and sends a message to e-mail from the letter with beautiful formatting / attached PDF containing the promo code assigned to this identifier.
Task:
To simplify a person's life by automating these template actions
Question:
Where can I get a similar script? What should it be written on? Perhaps someone will offer their development services)

Answer 1

If you need to use Outlook, then it's better to do it in VBA.
You can make a button on the Outlook panel, with the launch of a macro that will do these actions with the selected letter.
No one will provide you with a ready-made script, it is better to contact Freelancing.