Mailmerge to Lotus Notes Email

[Frank Wood]

Hello,

I have a list with duplicate emails in Excel that I would like to distribute
via Lotus Notes email. The Data would look something like this:

Name Sold Email
Joe 3 (e-mail address removed)
Hank 4 (e-mail address removed)
Billy 5 (e-mail address removed)
Tom 7 (e-mail address removed)
William 5 (e-mail address removed)
etc...

I wish to create a macro that would take all those associated with
(e-mail address removed) and distributes that info into a lotus notes email body and
sends them to (e-mail address removed). Then takes all of Sally's and does the same.
There are over 100 different names with different numbers of records for
each. I was thinking that I should use the mailmerge feature in Word to
automate some of this process. My questions are:
1. Will Word Mail Merge work with Lotus Notes email?
2. is there a simple way of parsing the correct number of records into the
body of the email macro or otherwise???

Any suggestions would be greatly appreciated!

Frank Wood
(e-mail address removed)

 

[Doug Robbins - Word MVP]

Aside from the Lotus Notes issue, mail merge cannot really do that sort of
thing out of the box.

Any solution is almost certainly going to require the use of some Visual
Basic Code to iterate through the records of the Excel worksheet, compiling
the data for the message and then for sending it via Lotus Notes, assuming
that is possible, which I do not know.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Frank Wood]

Hi Doug,

Yes, I assumed it would require VB code, I just didn't know how well Word
would interface with Notes even without the issue of parsing the the data.
Even if i was not trying to automate the process, can Word use the mail merge
wizard to merge with Notes email?

Frank

 

[Peter Jamieson]

When I had Notes set up here and tried to do this, the problem I always came
up against was that you had to intervene manually as each e-mail was created
(I can't remember the precise details - I think the problem was that you had
to send each email individually from the Notes client). Of course things may
have changed or there may be a workaround, but I have to say I didn't find
all that much info. on the Lotus support site. I no longer have a copy of
Notes installed so cannot check.

You will certainly need to have MAPI support configured.

I don't know all that much about programming from within the Notes
environment (you used to be able to do all that LotusScript stuff) but if I
had to do this I think I would look at the option of building my emails
using that approach and automating Excel to get my data.

(If you search Google groups for "jamieson lotus notes" you'll probably find
a bit more detail about some of the issues.)

Peter Jamieson

 

[Frank Wood]

Thank Peter, I'll see what I can find. Sending each email individually would
still be acceptable, although a completely automated solution would of course
be ideal.

I also have noticed that the info related to this is sparse at best. It
seems that either Word users don;t use Notes or vice versa. <shrug> ar at
least no-one seems to be writing much about the connectivity or lack there of
between the two. I may just try to ask similar questions in a Notes forum.
Maybe someone there has experience with this. In any case, thank you very
much for you assistance! And thanks for the google search tip as well!

Frank Wood

 

[Doug Robbins - Word MVP]

I would suggest that a Notes forum would be a much more likely place to find
information.

At least I would expect that all of the participants there use Notes and
probably most of them use Word

Here, probably every body uses Word and most of them use Outlook.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP