Sending worksheet via Lotus Notes

[Sibrulottes]

Hi,
so I'm applying different advanced filters to cellular data, and sending reports to 3 different layers of managers in the organisation. I'm running the same loop on 3 different colomns of a manager list. The macro runs great until it stops at various points in the list at .Send 0, vaRecipients

Which is usualy what would happen if the vlookup function retrieving the email returned nothing. Would somebody care to help me figure it out? I'll gladly send you a copy of the file, but won't post it publicly since it holds sensitive info.

Please Login or Register  to view this content.

[Sibrulottes]

If it is any help,

the debugging error message states
Execution error 7000
Notes error: The database already contains a document with this ID (UNID)

Should I have my macro sleep a little after sending one email, so as to give time to Lotus notes to clear the email before excel requests another document?