Macro to send mail via lotus notes diff people diff attachment

Hi all

I had google for this many times in last 3 days, but could not get through. Also visited http://www.rondebruin.nl/win/s1/notes/notes8.htm

I am looking for a code which will

1] Pick up mail id's from columns [ To, CC & BCC].
2] On the next column Attachment path is given. Different attachment for different mail ids mentioned in point 1
3] Mail Body will be common for all.

It will be great relive if I get through this code.

Some How Am modulating the code of Outlook to work for lotus notes but it gives me error no 438. Please look into.

Please Login or Register  to view this content.

I never worked with Outlook. However this may give you some ideas in Lotus Notes. It assumes the following:

Your TO addees are in Column A. Your CC addees are in Column B. Your Attachments are in Column D. On testing it did send a standard email to the addees and copy tos. I had a problem with the attachments, but maybe you can play around with it and see if you can get it to work.

Please Login or Register  to view this content.

Finally its solved. Code is as below...

Please Login or Register  to view this content.