Recent content by AaronKamp

Thanks, you guys rock! :) Roy-Vidar's solution worked like a charm. I tried it first since it was the easiest to implement and test. The original w/ the DoCmd.SendObject did loop through all records. I thought since I called the outlook message in the loop in the With, that it would loop. I'm...

Here is the code that loops, however it will only send in text format. Function SponsorApproval() On Error GoTo SA_Error Dim ESA As String Dim Title As String Dim Message As Integer ESA = "You are about to send emails to all Executive Sponsors with outstanding approvals." &...

I'm having a bit of difficulty with this code. In a simpler form it works just fine except line breaks in the contacts section of the body were not being shown when recieved by recipients. In RTF format this is not the case; however, now the code no longer loops through the recordset. It only...

=VLOOKUP(C1,$F$1:$G$12,2,TRUE) For this to work, I changed how the range was listed in the following manner: ------F------ 0 500000 500000.001 1000000 1000000.001 3000000 3000000.001 6000000 6000000.001 10000000 10000000.001 20000000 ---G--- 0.15 0.15 0.12 0.12 0.1 0.1 0.9 0.9 0.8 0.8 0.7 0.7

Thanks for the quick responses, you guys rock! The second code set from Zathras worked flawlessly, all I needed to do was tweak line 7 to <> 0 vs <> the empty set. For whatever reason, I couldn't get Loomah's code to work properly in my project. Improving my VBA skills (or lack of) is...

I tried searching for a similar topic but did not find anything that answered my question... I would like some input as to a relatively simple method for selecting multiple sheets within a workbook based on a value located in a common cell (i.e. if E17 has any value other than zero, that sheet...