Trying to create a macro with no knowledge prior to this attempt RRS feed

  • Question

  • I have a monthly notification that gets sent out to Account Excutives notifying them of a list of clients who will be recieving surveys. I'm given a spreadsheet that has a range of data including the client data that I would like to have automatcally copied to each email. The rows vary depending on how many clients are assigned to an AE. Idealy I would like to create a macro or implement a VBA code that filters by AE and then takes the rows assigned to this AE and pastes both the AE's name in a certain spot in the email (outlook) and then the client data within the body of the email. Is this explanation sufficient or is more information needed?


    Sunday, February 2, 2014 11:20 PM

All replies