 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / May 2007Mailmerge to Lotus Notes Email
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 Fred@aol.com Hank 4 Fred@aol.com Billy 5 Fred@aol.com Tom 7 Sally@aol.com William 5 Sally@aol.com etc... I wish to create a macro that would take all those associated with Fred@aol.com and distributes that info into a lotus notes email body and sends them to fred@aol.com. 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 fwood@cox.net 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.  SignatureHope 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 > Hello, > [quoted text clipped - 24 lines] > Frank Wood > fwood@cox.net 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 > Aside from the Lotus Notes issue, mail merge cannot really do that sort of > thing out of the box. [quoted text clipped - 32 lines] > > Frank Wood > > fwood@cox.net 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 > Hi Doug, > [quoted text clipped - 50 lines] >> > Frank Wood >> > fwood@cox.net 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 > 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 [quoted text clipped - 69 lines] > >> > Frank Wood > >> > fwood@cox.net 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. SignatureHope 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 > Thank Peter, I'll see what I can find. Sending each email individually > would [quoted text clipped - 99 lines] >> >> > Frank Wood >> >> > fwood@cox.net |
Reply to this Message |
 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.