title: Macros to Send attach different files to multiple individual emails, vba
body: <p>I am a computer technician, not a programmer, but in my new job I have been asked to finish a macros in excel (vba).
  It consists of a list of id card numbers in one of the columns (the number of cells is variable each time it is used, one day you can put 20 people and another 12 for example), and emails in another column.
  In a folder there are some pdf documents whose name is the id card of the person that appears in the excel.</p>
  
  <p>What they ask me is that, being ordered the id card in alphabetical order, take the id card and email. The id card will serve to find your corresponding pdf and add it as an attachment with the idea of sending it by email, to whom? there the cell is used with the email data. This has to be done with each of the existing rows, take pdf file to attach it and send email to the address of that same row until there are no more rows on the sheet.</p>
  
  <p>Can someone tell me how to do that or tell me the functions I need?</p>
  
  <p>Thank you.</p>
  
  <p>Graphical idea:<br>
  <img src="https://i.stack.imgur.com/PEZJx.jpg" alt=""></p>