I know how to send the object, but how can I receive the file in MS Access?
For example, I send the report using Docmd.SendObject,...
Then it opens Lotus Notes application to send the file. Later, if the someone response to me with the file, then I want to retrieve that file data in my MS Access, how can I transfer the file to MS Access inside, then I update it to my tables.
Actually, does MS Access transfer the file from Lotus Notes to MS Access?
You are into fairly complex territory here. Izy wrote something very like this but using Outlook. I can't find the thread since the problems with the site the other week. However Izy might be able to provide a link - he popped the code on his site. Although not directly relevent it might give you ideas of a course of action assuming Lotus Notes can be automated