none
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?

    -Darren

    Sunday, February 2, 2014 11:20 PM

All replies