This line:
strTo = RS!cEmailAddress
is putting the current email address into a string variable, which would be used when the email is sent. They don't demonstrate that, they just say "Send the email using some technique or other". The other line builds a string that would look like:
2010118123456_MabryMail
Again, they don't demonstrate how they would use it, but presumably either for a file name or something. For what you're doing now, you just need a query that gets a listing of your locations. This code would loop through that query, and within the loop you'd have the Lebans code create a PDF for the current location.
I understand the time issue; my daughter lives in the UK. I will certainly be around tomorrow for follow-up. You can dump anything email related, and where it says "Send the email using some technique or other", you'd have your Lebans code. Right before that you'd want to place the current location into either a form control or global variable, whichever you chose. Using the example from the site it would look like:
Forms![Select Load List]![LoadID] = RS!LocationFieldName
You've worked so hard, here's a snippet from an app of mine that does this type of thing:
Code:
Do While Not rs.EOF
Forms!frmStatementFilter.txtEmailCust = rs!CustomerAccount
blRet = ConvertReportToPDF(strReport, vbNullString, _
"c:\" & rs!CustomerAccount & "Statement.pdf", False, False, 0, "", "", 0, 0)
DoEvents
'I have code here to send an email with the above attached
rs.MoveNext
Loop