Mail Merge using Lotus Notes for e-mail and excel for data source

I've been searching and searching and all I can find are 3rd party
products.

What I want to do is write some script (in Lotus Notes) that will run
off of the actions menu. What the script does is pull the data from an
excel spreadsheet and send e-mails based on the data in that excel
spreadsheet.

I also want to use the rich formatting available in Lotus Notes for the
e-mails (thus the need to use Lotus Script, I assume).

Can this be done and if so, how?

Any ideas greatly appreciated.
-Michael.

I would suggest looking at an example in the Notes.net sandbox. There
was a sample for using MS word to do mail merge in Lotus. Maybe you can
come up with something from there.

I haven't used this functionality myself so this is about the best I
can offer.

http://www-10.lotus.com/ldd/sandbox....c?OpenDocument

Thanks. But I guess what I'm looking for is something that will run
w/in Lotus Notes and use Excel (or heck, any data source that isn't in
Notes) to create mail merges.

Doesn't Lotus Notes support mail merging of some kind? I know Outlook
doesn't. I know it relies upon Word. But I thought Notes was supposed
to have this capability somehow?

I've gotten the mail merge to work this way so far, Do the legwork in
Word (create document, select data source, etc.). Set Notes as the
default mail client (In IE). Then when you tell word to mail merge, it
sends the e-mails into Notes. Problem is I loose all the 'rich text'
formatting and can't attach documents.

Thus the need to have Notes be the 'work horse' in the process as
opposed to MS Word.

Thanks in advance.
-Michael

nondisclosure007-at-hotmail.com wrote:
> Thanks. But I guess what I'm looking for is something that will run
> w/in Lotus Notes and use Excel (or heck, any data source that isn't in
> Notes) to create mail merges.
>
> Doesn't Lotus Notes support mail merging of some kind? I know Outlook
> doesn't. I know it relies upon Word. But I thought Notes was supposed
> to have this capability somehow?
>
> I've gotten the mail merge to work this way so far, Do the legwork in
> Word (create document, select data source, etc.). Set Notes as the
> default mail client (In IE). Then when you tell word to mail merge, it
> sends the e-mails into Notes. Problem is I loose all the 'rich text'
> formatting and can't attach documents.
>
> Thus the need to have Notes be the 'work horse' in the process as
> opposed to MS Word.
>
> Thanks in advance.
> -Michael
>
you may be interested in Domino List Manager. Granted, it is still notes
and it is 3rd party, but you can import your addresses from a
spreadsheet in to the database. Then, you can mailshot each address and
automatically handle opt-in/out and delivery failures.

http://www.lan2lan.com/ibmdatasheets