Have the code below that loos through values in a field and transmits a PDF via e-mail.
"cus_Rpt09" field contains a blank value which does not require an e-mail to be sent.
Is there any way to exclude this from the Get Possible Values statement.
NB - Appreciate that the obvious route would be to exclude these from the data load but on this specific report I cannot do this as this is pass 2 out of 3 and excluding blanks on data load for this field would exclude non blanks from pass 1 and 3 which work from a different field.
Hope that makes sense!
Thanks in advance for any assistance...
'=========================================================================== sub SubmitReport2
set v = ActiveDocument.Variables("varSubmission") varSubmission = 2 v.SetContent varSubmission, true
Set val=ActiveDocument.Fields("cus_Rpt09").GetPossibleValues(20000) For i = 0 to Val.count - 1