Joe Jersey
asked on
Mail Merge from MS Word and email the attachment using Lotus Notes.
Hi Experts,
I wonder if you could help me as I am a bit stuck. I need someone to help me Mail Merge using MS Word, and email the word document using Lotus Notes (the email address is in an excel spreadsheet along with other merge data (name/address etc).
Everything is setup and the mail merge works fine using outlook. However, the office where the mailmerge will be running does not use Outlook but Lotus Notes (v6.5). Is there a way I can merge and email using Lotus Notes.
Thanks very much and I look forward to any help.
Kind Regards,
Joe.
ps Notes version is 6.5 and MS Word version is 2003.
I wonder if you could help me as I am a bit stuck. I need someone to help me Mail Merge using MS Word, and email the word document using Lotus Notes (the email address is in an excel spreadsheet along with other merge data (name/address etc).
Everything is setup and the mail merge works fine using outlook. However, the office where the mailmerge will be running does not use Outlook but Lotus Notes (v6.5). Is there a way I can merge and email using Lotus Notes.
Thanks very much and I look forward to any help.
Kind Regards,
Joe.
ps Notes version is 6.5 and MS Word version is 2003.
Please check the following URL which will solve your issue and hope the attached files also will help you for this.
http://searchdomino.techtarget.com/tip/1,289483,sid4_gci1101621,00.html
http://searchdomino.techtarget.com/tip/1,289483,sid4_gci1101621,00.html
ASKER
Oh wow! thanks folks for the very fast reply.
sjef_bosman:, I know I can't use POP3 as it has been disabled on the server and they will not let me use it, however I am not familiar with DAMO. I'm just about to google it. The problem I have is that I have full access to excel and word (so I can write/use VBA macros etc) but I have no access to Lotus Notes, just a normal users ability to send and receive email.
Jeews: thanks very much for the link, unfortunately my predicament is the other way around. I already have the merge working in word, I just need to send the merge via email using Lotus Notes.
Thanks for the suggestions so far. :)
sjef_bosman:, I know I can't use POP3 as it has been disabled on the server and they will not let me use it, however I am not familiar with DAMO. I'm just about to google it. The problem I have is that I have full access to excel and word (so I can write/use VBA macros etc) but I have no access to Lotus Notes, just a normal users ability to send and receive email.
Jeews: thanks very much for the link, unfortunately my predicament is the other way around. I already have the merge working in word, I just need to send the merge via email using Lotus Notes.
Thanks for the suggestions so far. :)
DAMO: Domino Access for Microsoft Outlook
http://www.ibm.com/developerworks/lotus/library/damo/
http://searchdomino.techtarget.com/generic/0,295582,sid4_gci1271194,00.html
Google for
Lotus DAMO Outlook
There's also a Microsoft equivalent (they say); a Lotus Domino connector.
http://kevinmarquette.blogspot.com/2008/01/get-outlook-2007-work-with-lotus-domino.html
http://www.ibm.com/developerworks/lotus/library/damo/
http://searchdomino.techtarget.com/generic/0,295582,sid4_gci1271194,00.html
Google for
Lotus DAMO Outlook
There's also a Microsoft equivalent (they say); a Lotus Domino connector.
http://kevinmarquette.blogspot.com/2008/01/get-outlook-2007-work-with-lotus-domino.html
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
also see this solution
https://www.experts-exchange.com/questions/22602778/E-mail-using-a-VB-Excel-Spreadsheet-to-Lotus-Notes.html
I hope this helps !
https://www.experts-exchange.com/questions/22602778/E-mail-using-a-VB-Excel-Spreadsheet-to-Lotus-Notes.html
I hope this helps !
ASKER
Thanks very much folks. I've got some good stuff to try out here. I'll let you know the outcome.
Thanks again and i'll be back soon. :)
Thanks again and i'll be back soon. :)
ASKER
Sorry for delay, this is the first time I managed to get to a Notes 6.5 machine.
Thanks wobbled for that snippet of code.
I tried running it but I get an error message at the following point:
MailDoc.CreateRichTextItem ("Attachment") (line 49)
It says that an attachment already exists and throws up a runtime error.
Do you know what I need to do? Thanks.
Thanks wobbled for that snippet of code.
I tried running it but I get an error message at the following point:
MailDoc.CreateRichTextItem
It says that an attachment already exists and throws up a runtime error.
Do you know what I need to do? Thanks.
Do you reuse the document? Because, according to the sources, the attachment is created in a brand new document. Or did you modify the code somewhere?
ASKER
Hi sjef,
No I haven't modified the code, and everytime the SendNotesMail sub is called a new document has been created and needs to be sent using a new email message. (If that makes sense).
Basically, the word macro creates a new merged document/ saves it/calls the SendNotesMail sub with an email address/subject/body etc, moves onto the next record and does the same process again.
No I haven't modified the code, and everytime the SendNotesMail sub is called a new document has been created and needs to be sent using a new email message. (If that makes sense).
Basically, the word macro creates a new merged document/ saves it/calls the SendNotesMail sub with an email address/subject/body etc, moves onto the next record and does the same process again.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Just checked that and sjef is correct - it works fine without an attachment, but fails if you add the line. Of all the email clients I have ever used I have to say that Lotus Notes is the worse one by far!
Hope you get it working ok
Hope you get it working ok
ASKER
Ahhh yes, that seems to have done the trick quite nicely!
Wobbled, I'm with you, sometimes Lotus Notes drives me up the wall! I have this love hate relationship with it.
Thanks very much everyone for your assistance on this! It has been a real help!
Kind Regard,
Joe.
Wobbled, I'm with you, sometimes Lotus Notes drives me up the wall! I have this love hate relationship with it.
Thanks very much everyone for your assistance on this! It has been a real help!
Kind Regard,
Joe.
This looks promising for an issue I'm trying to solve in an all Notes shop. However, I'm not a Notes guy...can you guys give a breif description on how to implement this? I assume its not Lotus Script because I get a lot of syntax errors there.
Only people who participated in this here question will see your request. It is much more appreciated if you do the other way round: ask your own question, and place references from your question to this one and vice versa.
ASKER
Hi LDeahl
Yeah, this isn't lotus script. Actually it's VBA (working within MS Word to link into Lotus).
As sjef_bosman mentions, you are much better off asking a specific question - the experts are very quick and very good. Hope this helps.
J.
Yeah, this isn't lotus script. Actually it's VBA (working within MS Word to link into Lotus).
As sjef_bosman mentions, you are much better off asking a specific question - the experts are very quick and very good. Hope this helps.
J.
You could continue to use Outlook as a mail client for this specific purpose. There are ways to make Outlook a mail client to a Domino server, e.g. DAMO, and POP3.
Two cents...?