Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / March 2006

Tip: Looking for answers? Try searching our database.

mailmerge to email using Lotus Notes or Eudora, no Outlook

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
trash - 13 Oct 2005 16:37 GMT
Where I work, every machine has Microsoft Office 2003 (every
application in the bundle except for Outlook). The default email client
is Lotus Notes 6, but we also have licenses for Eudora.

We need to create a mailmerge using Word 2003 grabbing the data from
from an Excel file or a flat file from a mainframe. This is no problem.
We can print thousands of letters at a time (or as much as the printer
can support).

The problem that we have is that we cannot do mailmerge to email. The
email option does not come up in the menu that Word 2003 offers.

The Novell/Windows administrator says that the installation of Outlook
includes certain files (DLLs most likely) that allow Word to
communicate with the default email client, in our case Lotus Notes 6.
The problem here is we cannot give users Outlook even it is hidden or
somewhat disabled (internal BS plus all the vulnerabilities that
Outlook has).

How can we make Word talk to an email client can send the thousands of
emails that we need to send.

cheers,
Frank
chriskepu@gmail.com - 17 Oct 2005 23:45 GMT
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
tvon - 07 Mar 2006 20:34 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.