problem emailing reports using scheduler

Hi all,

I am struggling with Jet Scheduler to get emails automatically sent. More specific: Scheduler runs a report for about 10 people in batch on a 2-weekly basis. It then must send the report via Outlook to the email address that is retrieved from a named range on the Options-sheet, based on the resource-no. using a VLOOKUP-function.
When the resource no. is 4 digits: no problem. There is one resource however with a 3-digit number, so it is preceded by a zero. This now is my problem. This zero disappears in the process and I have tried all possible solutions with formatting, but I have been unable to get an email to this person. In my logfile the following message appears:
2012-03-21 11.12.34 The message could not be sent.
2012-03-21 11.12.34 Could not submit the message - error 0x80040607
I attach the file, maybe someone can have a look at it and send me some suggestions.
I think the problem lies in the formatting of cells Options!D5 and Options!C24.
Please note that in the attachment the formats of D5 and C24 are not the same. When I run the report manually with these settings, all seems to work just fine. Letting it run by the Scheduler causes the #N/A errors in C15 and C24.
Hope someone has the answer…..

regards,
Willem@marin