Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mailmerge 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 Hank 4 Billy 5 Tom 7 William 5 etc... I wish to create a macro that would take all those associated with and distributes that info into a lotus notes email body and sends them to . 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 a 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 |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mailmerge to Lotus Notes Email
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. -- Hope 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 "Frank Wood" wrote in message ... 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 Hank 4 Billy 5 Tom 7 William 5 etc... I wish to create a macro that would take all those associated with and distributes that info into a lotus notes email body and sends them to . 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 a 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 |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mailmerge to Lotus Notes Email
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 "Doug Robbins - Word MVP" wrote: 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. -- Hope 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 "Frank Wood" wrote in message ... 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 Hank 4 Billy 5 Tom 7 William 5 etc... I wish to create a macro that would take all those associated with and distributes that info into a lotus notes email body and sends them to . 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 a 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 |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mailmerge to Lotus Notes Email
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 "Frank Wood" wrote in message ... 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 "Doug Robbins - Word MVP" wrote: 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. -- Hope 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 "Frank Wood" wrote in message ... 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 Hank 4 Billy 5 Tom 7 William 5 etc... I wish to create a macro that would take all those associated with and distributes that info into a lotus notes email body and sends them to . 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 a 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 |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mailmerge to Lotus Notes Email
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 "Peter Jamieson" wrote: 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 "Frank Wood" wrote in message ... 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 "Doug Robbins - Word MVP" wrote: 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. -- Hope 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 "Frank Wood" wrote in message ... 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 Hank 4 Billy 5 Tom 7 William 5 etc... I wish to create a macro that would take all those associated with and distributes that info into a lotus notes email body and sends them to . 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 a 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 |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mailmerge to Lotus Notes Email
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. -- Hope 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 "Frank Wood" wrote in message ... 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 "Peter Jamieson" wrote: 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 "Frank Wood" wrote in message ... 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 "Doug Robbins - Word MVP" wrote: 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. -- Hope 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 "Frank Wood" wrote in message ... 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 Hank 4 Billy 5 Tom 7 William 5 etc... I wish to create a macro that would take all those associated with and distributes that info into a lotus notes email body and sends them to . 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 a 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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use Lotus Notes for email merges in Word | Mailmerge | |||
Word & Lotus Notes | Microsoft Word Help | |||
mailmerge to email using Lotus Notes or Eudora, no Outlook | Mailmerge | |||
email address truncated to 24 characters with mailmerge to Lotus Notes | Mailmerge | |||
been sent a lotus notes email. how do i save? | Microsoft Word Help |