Email output variable

[jlang11]

ok, Im stuck again. You guys were awesome last time and the help is much appreciated.

I have a macro that creates an email that advises members when they have contributed funds or received a refund to/from the club. My spreadsheet headings are Email address, Name, 1st contribution, 1st date, 2nd cont, 2nd date, 3rd cont, 3rd date, 4th cont, 4th date. Refunds show as a negative number, despite it saying "contribution".

What I dont want to happen is if someone contributed only 2 times, for the 3rd cont and date and 4th, etc, to print in the email... They have all made at least 1 contribution (Original Contribution Received).


Here is the message part of the macro. I think it would just be a series of IF statements after the initial contribution, but not sure how to format it.

Please Login or Register  to view this content.

Is something like this what I should be doing??

Please Login or Register  to view this content.

Here is the current output from one:

Please Login or Register  to view this content.

Id rather not have the additional "Transaction --" and/or the space between the dollar amounts and the total if possible. Some people will only have 1 "transaction" and dollar amount.

[TMS]

I think it's a case of seeing the wood for the trees. I would suggest you build each of the transaction parts and then it's easier to see if you need the part and add it.

Regards, TMS

[jlang11]

Not sure what you mean. I will need it for some, but not others. Some people have 1 transaction, and some have 4. Some 2 and some 3.

I guess I could break them into different sheets, Sheet1 with 1 transaction, Sheet2 with 2 transactions, etc, and copy the macro 4 times and delete the extra lines for each page...

[TMS]

It would look something like this:

Please Login or Register  to view this content.

Regards, TMS

[TMS]

Actually, I think this version aligns the positive and negative values a little better:

Please Login or Register  to view this content.

Regards, TMS

[TMS]

@jlang11:

I notice you have been on the board since I offered this solution. As I spent some time putting it together for you, I would be very interested to know if it worked and did what you hoped for.


Regards, TMS

[jlang11]

My apologies. I received an email alerting me there was a post and was anxious to see what it was, but due to the holiday I was not at my computer to test it. I should have some time very shortly to test it and I appreciate your effort. The code looks very intereting and I am anxious to see what it does. Ill post back in a few and let you know.

Thanks again!

[jlang11]

That works perfectly!!!! Thank you so much!!!!

[TMS]

You're welcome. Thanks for the rep.


Please note the "i = 2" which is just in there for testing

[jlang11]

Which worked out perfectly because I also had i = long (For i = 2 To LastRow) when it pulls the email address from column a.

Thanks again!!