If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
mail merge to Lotus Notes email?
Is it possible to set up an e-mail mail merge to be sent
out through Lotus Notes? I'm a marketing consultant who's working with a financial planner. We're trying to set up a mail merge so he can send out a monthly market update to list of 100 or so people. he would like to personalize each message with the help of mail merge fields and this also helps him with company and regulatory compliance issues. His company email system is Lotus Notes. He's in Kansas City logged into the corporate network in St. Louis. When we tried to set up the mail merge, by default it wants to send the emails to Outlook. We changed the email program through IE to default to Lotus Notes, but then mail merge does nothing. Can this be accomplished? What needs to happen? Any and all assistance is greatly appreciated. |
#2
|
|||
|
|||
mail merge to Lotus Notes email?
I don't know much about Lotus Notes or for that matter Microsoft Exchange
Server, but for the former you are going to need the latter for this to work as planned. There is a raft of Exchange newsgroups where you should find more information on this type of integration. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Kevin wrote: Is it possible to set up an e-mail mail merge to be sent out through Lotus Notes? I'm a marketing consultant who's working with a financial planner. We're trying to set up a mail merge so he can send out a monthly market update to list of 100 or so people. he would like to personalize each message with the help of mail merge fields and this also helps him with company and regulatory compliance issues. His company email system is Lotus Notes. He's in Kansas City logged into the corporate network in St. Louis. When we tried to set up the mail merge, by default it wants to send the emails to Outlook. We changed the email program through IE to default to Lotus Notes, but then mail merge does nothing. Can this be accomplished? What needs to happen? Any and all assistance is greatly appreciated. |
#3
|
|||
|
|||
mail merge to Lotus Notes email?
I'm not a Lotus Notes expert either (cf. Graham) but have spent quite a long
time trying to see how to configure Word 2002/2003 to work with Notes 6, even to the point where it's possible to send a single document via Notes e-mail. If anything, earlier versions of Office & the Notes client seem to have slightly more easy to configure. But the key point is that every combination of Office version/Notes version seems to have its own set of problems. I think you are much more likely to find someone who has coped with this situation if you look in Notes confs. rather than Word confs. However, have you considered a. doing the whole job in Notes, at least if all the data you need for the merge is held there or can easily be imported? My understanding is that Notes was more or less designed to do this kind of thing, although I sometimes get the impression that it is harder to integrate Notes Database data and e-mail to non-Notes users than it should be b. using a third party product? I'd look around, because they all do slightly different things. I don't know any of them, but for example some people have evidently found "Print Merge Express" at http://www.ivesco.com useful. At a rather techie level, what seems to be necessary in earlier Word/Notes combinations is that a. you have the full Outlook (not Outlook Express) on your system as well as Notes Client. The main point of this actually seems to be that installing the full Outlook is the only way these days that you can set up the facilities for MAPI profile configuration, but there may be more to it than that b. you run the Notes client using the Notes user setup/location you want to use c. in Windows Control Panel|Mail (which is for MAPI profile configuration) or right-click on Outlook and choose Properties (should be the same thing), remove all existing profiles, d. create a new profile, adding the Lotus Notes Mail Service e. configure that Service However, f. I would be very unhappy - installing Outlook on a system that didn't have it and didn't need it for any other reason - doing (c) on a production machine unless I knew exactly how to recreate my usual profile(s) (if any) g. when I tried (e), on a Win2k/Office2002/Notes6 config., I just got errors with no useful explanation. I did, however, notice that when Lotus adds its MAPI-related info. to mapisvc.inf (which in theory has a list of MAPI-related services available on a PC), it says the Lotus MAPI dll is called nwnsp.dll, whereas the dll Lotus actually installs is called nwnsp32.dll. My impression is that the version of MAPI on my machine simply can't work with that dll.Maybe people who have Lotus Notes 5 or have upgraded have the right bits of software. If you do find a way through all this, I would appreciate it if you could post back here. -- Peter Jamieson "Kevin" wrote in message ... Is it possible to set up an e-mail mail merge to be sent out through Lotus Notes? I'm a marketing consultant who's working with a financial planner. We're trying to set up a mail merge so he can send out a monthly market update to list of 100 or so people. he would like to personalize each message with the help of mail merge fields and this also helps him with company and regulatory compliance issues. His company email system is Lotus Notes. He's in Kansas City logged into the corporate network in St. Louis. When we tried to set up the mail merge, by default it wants to send the emails to Outlook. We changed the email program through IE to default to Lotus Notes, but then mail merge does nothing. Can this be accomplished? What needs to happen? Any and all assistance is greatly appreciated. |
#4
|
|||
|
|||
mail merge to Lotus Notes email?
Another thought on this. Pure speculation really - if you don't have good
VBA programming expertise available I'd ignore it. Since the Lotus Notes Client is an OLE Automation client and server and that you may be able to use Word VBA + Automation to get data from Notes (if necessary), construct Notes documents, attach Word files and send them. I imagine that is exactly what some of the third party Notes products do. If this is feasible, I think what you would have to do is a. create one Word document per recipient b. use the Notes Automation objects to create and send one Notes document per recipient with the appropriate file attached. One approach might be to adapt the approach described at http://word.mvps.org/FAQs/MailMerge/...ttachments.htm to use Lotus Notes objects instead of Outlook objects. Personally, I would probably take a different approach which would a. perform one merge for each record in my data source b. save the resulting document c. mail it (somehow) via Notes. -- Peter Jamieson "Peter Jamieson" wrote in message ... I'm not a Lotus Notes expert either (cf. Graham) but have spent quite a long time trying to see how to configure Word 2002/2003 to work with Notes 6, even to the point where it's possible to send a single document via Notes e-mail. If anything, earlier versions of Office & the Notes client seem to have slightly more easy to configure. But the key point is that every combination of Office version/Notes version seems to have its own set of problems. I think you are much more likely to find someone who has coped with this situation if you look in Notes confs. rather than Word confs. However, have you considered a. doing the whole job in Notes, at least if all the data you need for the merge is held there or can easily be imported? My understanding is that Notes was more or less designed to do this kind of thing, although I sometimes get the impression that it is harder to integrate Notes Database data and e-mail to non-Notes users than it should be b. using a third party product? I'd look around, because they all do slightly different things. I don't know any of them, but for example some people have evidently found "Print Merge Express" at http://www.ivesco.com useful. At a rather techie level, what seems to be necessary in earlier Word/Notes combinations is that a. you have the full Outlook (not Outlook Express) on your system as well as Notes Client. The main point of this actually seems to be that installing the full Outlook is the only way these days that you can set up the facilities for MAPI profile configuration, but there may be more to it than that b. you run the Notes client using the Notes user setup/location you want to use c. in Windows Control Panel|Mail (which is for MAPI profile configuration) or right-click on Outlook and choose Properties (should be the same thing), remove all existing profiles, d. create a new profile, adding the Lotus Notes Mail Service e. configure that Service However, f. I would be very unhappy - installing Outlook on a system that didn't have it and didn't need it for any other reason - doing (c) on a production machine unless I knew exactly how to recreate my usual profile(s) (if any) g. when I tried (e), on a Win2k/Office2002/Notes6 config., I just got errors with no useful explanation. I did, however, notice that when Lotus adds its MAPI-related info. to mapisvc.inf (which in theory has a list of MAPI-related services available on a PC), it says the Lotus MAPI dll is called nwnsp.dll, whereas the dll Lotus actually installs is called nwnsp32.dll. My impression is that the version of MAPI on my machine simply can't work with that dll.Maybe people who have Lotus Notes 5 or have upgraded have the right bits of software. If you do find a way through all this, I would appreciate it if you could post back here. -- Peter Jamieson "Kevin" wrote in message ... Is it possible to set up an e-mail mail merge to be sent out through Lotus Notes? I'm a marketing consultant who's working with a financial planner. We're trying to set up a mail merge so he can send out a monthly market update to list of 100 or so people. he would like to personalize each message with the help of mail merge fields and this also helps him with company and regulatory compliance issues. His company email system is Lotus Notes. He's in Kansas City logged into the corporate network in St. Louis. When we tried to set up the mail merge, by default it wants to send the emails to Outlook. We changed the email program through IE to default to Lotus Notes, but then mail merge does nothing. Can this be accomplished? What needs to happen? Any and all assistance is greatly appreciated. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Word-Excel 2003 - Mail Merge Recipients problem | Gabbi | Mailmerge | 4 | January 11th, 2005 04:11 AM |
Mail Merge to Email | [email protected] | Contacts | 14 | July 2nd, 2004 09:23 PM |
How to run word and pass a mail merge values and fax it to the recipient | Belinda | Mailmerge | 2 | June 13th, 2004 12:49 AM |
HELP!!! Using Mail Merge Wizard / Access v2002 | [email protected] | Mailmerge | 1 | May 21st, 2004 08:51 AM |
Merge to Fax with SBS/Exchange? | Tom | Mailmerge | 3 | May 18th, 2004 11:22 PM |