Notes/Domino 4 and 5 Forum

Hi all,

I tried researching this but I am not quite sure how to phrase what I need, so I didn't find anything. I have a spreadsheet from Excel that I need to import to a Notes view. No problem there, however the form is first and last name of the employees in my company ( with other info but it's not important) and I need to get the email addresses of those who have one. Is there a way to do a batch update in Lotus Notes? I know how to get an email address from the Address Book with @NameLookup but when I tried to put that in an agent, it looked up only the first person's email and update everyone in the database with that email address. Is there a way to write an agent to read through each name and update a field in the document with their email?

I tried an agent with @DbLookup but it didn't work. Any hints or examples would be most appreciated.

Thank You.