Link to home
Start Free TrialLog in
Avatar of Brandon Feister
Brandon Feister

asked on

VBA Code to send different attachments to different recipients using lotus notes

I have around 40 files and I need to send each file to a different person using lotus notes.  I want to have the functionality of the code here: https://www.rondebruin.nl/win/s1/outlook/amail6.htm but I need it to work in lotus notes.
Avatar of Máté Farkas
Máté Farkas
Flag of Hungary image

This is not so simple because Access or Excel cannot cooperate with Lotus Notes.
However Lotus has also an OLE Object Library which allows you to implement a similar functionality.
Check this link: http://www.fabalou.com/vbandvba/lotusnotesmail.asp
Avatar of Brandon Feister
Brandon Feister

ASKER

Thank you for your help but the linked code seems to be how to send one email to many people.  How can I modify it to send many different emails to many different people?
Sorry, I thought that you are a programmer / developer if you wanted to use an existing code (what you sent before).
If you cannot change that code yourself then please create a GIG project to let implement it by someone.
I'm sorry I'm new to this site, what is a GIG project?
Unfortunately you disabled accepting gig project offers: https://www.experts-exchange.com/gigs
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.