VBA code to send emails for each Transaction Reference #

[dougdrex]

Hi I'm using Excel 2010.

I need to send out emails with a subset of the data in an Excel file. Here is some helpful information about the data itself:

• The data is populated in columns A - T.
• Row 1 is a header row. Then there are nearly 300 rows of data.
• Column F contains the Transaction Reference #. There are at least 2 rows of data for each Transaction Reference #, and sometimes up to 10 rows.
• Column Q contains the Maker ID (email address).
• Column S contains the Checker ID (email address).

Below are the things the VBA code will need to do:

1. There should be a separate email message for each Transaction Reference #.
2. Populate the email address from Column S (Checker ID) in the “To” field (same in each row for the Transaction Reference #).
3. Populate the email address from Column Q (Maker ID) in the “CC” field (same in each row for the Transaction Reference #).
4. Populate the email “Subject” field with predetermined verbiage that will include the Transaction Reference #.
5. Populate the body of the email with several components:

• Predetermined text verbiage
• The header row from the data (Row 1, Columns A – T).
• Each row of data containing the specific Transaction Reference # in Column F (include Columns A – T).
• Signature

Please let me know if there are any details that are not clear. It might be less complicated than I’m imagining, but I’m not a VBA expert so it certainly seems intimidating.


Thanks!
Doug

 

[dougdrex]

Bump

If my explanation needs clarification, please let me know (and specify which part). This is the last part of a macro that I'm creating and would love to be able to finish.