Hi Frank,
It's funny that I've found your message. The problem that you're
having is the same problem I'm having.
I started my search yesterday, but still no success in finding anything
that will tell me how to Email Merge to Lotus Notes.
We use Lotus Notes 6 here @ work & Office XP. I do though, have
Outlook XP on my system, thank goodness! I've managed to install
Microsofts Outlook Domino Connector to have Outlook as my default email
application & have Outlook communicating to the Domino Server to
retreive my emails. I can do Email Merge this way, with Outlook. I
can't set everyone up with Outlook & the Domino Connector though.
Everyone is to use Lotus Notes. So running with Outlook, the Email
Merge works perfect, just how it should work.
I've tried Email Merge with someone else's system that's running just
Lotus Notes 6 with the thought of Word will send Bulk Emails regardless
which Email Application you use. I thought it uses the default Email
app, but it doesn't. It didn't work for me, which I thought it might
be a setting in Lotus Notes. ....Well, after all that, this is why I'm
online looking everywhere how to run this Email Merge with Lotus Notes.
Please... if you find out how to do it with Lotus, would you mind
sending me an email on how to get it working. chris_kepu@tnt.com.au
[mailto:chris_kepu@tnt.com.au]
Regards,
Chris Kepu
> Where I work, every machine has Microsoft Office 2003 (every
> application in the bundle except for Outlook). The default email client
[quoted text clipped - 20 lines]
> cheers,
> Frank
grotel@gmail.com - 18 Oct 2005 10:02 GMT
This is the VBA Code i created, works with Office 2000 and Notes 6. U
just need to install activate notes.dll in the object-explorer of Macro
editor:
I explicitly did not use Notesbackend classes although there might be
faster. By using the Clipboard the Format conversion from Word to Notes
RTF is done automatically.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Sub MailMergeToEmail()
Dim Email, Subject, PrevRecord As Variant
Dim MyMerge As MailMerge
Dim MyEmbedded As Variant
Dim LNSession As Object
Dim LNMailDB As Object
Dim LNMailMemo As Object
Dim LNMailMemoBody As Object
Dim LNMail As Object
Dim I As Integer
Set MyMerge = ActiveDocument.MailMerge
Set LNSession = CreateObject("Notes.NotesSession")
Set LNWorkspace = CreateObject("Notes.NotesUIWorkspace")
LNMailServer = LNSession.GETENVIRONMENTSTRING("MailServer", True)
LNMailDBName = LNSession.GETENVIRONMENTSTRING("MailFile", True)
LNUserName = LNSession.UserName
PrevRecord = 0
ActiveDocument.ActiveWindow.View.ShowFieldCodes = False
Subject = InputBox("Enter subject for your Mailing", _
"Subject mailing", _
"Subject")
If MyMerge.State = wdMainAndDataSource Then
MyMerge.DataSource.ActiveRecord = wdFirstRecord
MyMerge.ViewMailMergeFieldCodes = False
While MyMerge.DataSource.ActiveRecord <> PrevRecord
PrevRecord = MyMerge.DataSource.ActiveRecord
Email = MyMerge.DataSource.DataFields("eMail").Value
ActiveDocument.Content.Copy
Set LNMail = LNWorkspace.COMPOSEDOCUMENT(LNMailServer,
LNMailDBName, "Memo")
Call LNMail.FIELDSETTEXT("Subject", Subject)
Call LNMail.FIELDSETTEXT("EnterSendTo", Email)
Call LNMail.GOTOFIELD("Body")
Call LNMail.Paste
Call LNMail.SEND
Call LNMail.Close(True)
MyMerge.DataSource.ActiveRecord = wdNextRecord
Wend
End If
MyMerge.ViewMailMergeFieldCodes = True
Set LNMailMemo = Nothing
Set LNMailDD = Nothing
Set LNSession = Nothing
End Sub
gar - 02 Nov 2005 13:08 GMT
We're having the EXACT same problem at the moment! We can use Excel to
set up the mail merge on Word, but the problem is transfering that mail
merge to Notes 6. This VBA solution is our only hope at the moment (bar
forking out on software).
I'm not too familiar with VBA but having a look at it now. Do you just
fill that code into Microsoft VB? How exactly do you install activate
notes.dll in the object-explorer of the Macro editor?
Thanks,
Garrett
B - 04 Nov 2005 00:09 GMT
Unbelievable! EXACT same problem I'm working on. I could use some
additional feedback on how to fill in that code as well. This is
awesome!!
Thanks, Barb
Karl M. - 31 Jan 2006 12:15 GMT
Hey!
Thanks for that code. Well like all others, I have a similar Problem. I want
to implement a Lotus Notes functionallity into a .NET 2005 Class Library. I'm
only not so familiar to VBA. Could you make an example of this code in C#? Or
could you at least give me a link, where I can download a tutorial about or
something similar?
Nice greetings
I'm having the same problem but with Eudora 6.2 . Has anyone figured
out a solution using Eudora??
Thanks.
trash Wrote:
> Where I work, every machine has Microsoft Office 2003 (every
> application in the bundle except for Outlook). The default email
[quoted text clipped - 22 lines]
> cheers,
> Frank

Signature
tvon
Peter Jamieson - 08 Mar 2006 11:16 GMT
I don't have Eudora here, but there's a document about COM Automation in
Eudora 4 at
http://www.eudora.com/pdf_docs/automation.pdf
which may give you some clues about how to adapt the macro for VBA that
appeared earlier in this thread, assuming that the COM object is still there
in Eudora 6.2.
Peter Jamieson
> I'm having the same problem but with Eudora 6.2 . Has anyone figured
> out a solution using Eudora??
[quoted text clipped - 28 lines]
>> cheers,
>> Frank