|
|
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[ at ]aol.com
Hank 4 Fred[ at ]aol.com
Billy 5 Fred[ at ]aol.com
Tom 7 Sally[ at ]aol.com
William 5 Sally[ at ]aol.com
etc...
I wish to create a macro that would take all those associated with
Fred[ at ]aol.com and distributes that info into a lotus notes email body and
sends them to fred[ at ]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[ at ]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.
--
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" <FrankWood[ at ]discussions.microsoft.com> wrote in message
news:85A60A01-158D-4376-A359-D97432AB21A9[ at ]microsoft.com...
[Quoted Text] > 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[ at ]aol.com
> Hank 4 Fred[ at ]aol.com
> Billy 5 Fred[ at ]aol.com
> Tom 7 Sally[ at ]aol.com
> William 5 Sally[ at ]aol.com
> etc...
>
> I wish to create a macro that would take all those associated with
> Fred[ at ]aol.com and distributes that info into a lotus notes email body and
> sends them to fred[ at ]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[ at ]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
"Doug Robbins - Word MVP" wrote:
[Quoted Text] > 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" <FrankWood[ at ]discussions.microsoft.com> wrote in message
> news:85A60A01-158D-4376-A359-D97432AB21A9[ at ]microsoft.com...
> > 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[ at ]aol.com
> > Hank 4 Fred[ at ]aol.com
> > Billy 5 Fred[ at ]aol.com
> > Tom 7 Sally[ at ]aol.com
> > William 5 Sally[ at ]aol.com
> > etc...
> >
> > I wish to create a macro that would take all those associated with
> > Fred[ at ]aol.com and distributes that info into a lotus notes email body and
> > sends them to fred[ at ]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[ at ]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
"Frank Wood" <FrankWood[ at ]discussions.microsoft.com> wrote in message
news:263C5623-FDC3-4923-BE4F-FCBF60013EC8[ at ]microsoft.com...
[Quoted Text] > 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" <FrankWood[ at ]discussions.microsoft.com> wrote in message
>> news:85A60A01-158D-4376-A359-D97432AB21A9[ at ]microsoft.com...
>> > 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[ at ]aol.com
>> > Hank 4 Fred[ at ]aol.com
>> > Billy 5 Fred[ at ]aol.com
>> > Tom 7 Sally[ at ]aol.com
>> > William 5 Sally[ at ]aol.com
>> > etc...
>> >
>> > I wish to create a macro that would take all those associated with
>> > Fred[ at ]aol.com and distributes that info into a lotus notes email body
>> > and
>> > sends them to fred[ at ]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[ at ]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
"Peter Jamieson" wrote:
[Quoted Text] > 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" <FrankWood[ at ]discussions.microsoft.com> wrote in message
> news:263C5623-FDC3-4923-BE4F-FCBF60013EC8[ at ]microsoft.com...
> > 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" <FrankWood[ at ]discussions.microsoft.com> wrote in message
> >> news:85A60A01-158D-4376-A359-D97432AB21A9[ at ]microsoft.com...
> >> > 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[ at ]aol.com
> >> > Hank 4 Fred[ at ]aol.com
> >> > Billy 5 Fred[ at ]aol.com
> >> > Tom 7 Sally[ at ]aol.com
> >> > William 5 Sally[ at ]aol.com
> >> > etc...
> >> >
> >> > I wish to create a macro that would take all those associated with
> >> > Fred[ at ]aol.com and distributes that info into a lotus notes email body
> >> > and
> >> > sends them to fred[ at ]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[ at ]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.
--
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" <FrankWood[ at ]discussions.microsoft.com> wrote in message
news:F5264997-4237-482E-BF15-4192E8E5C05E[ at ]microsoft.com...
[Quoted Text] > 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" <FrankWood[ at ]discussions.microsoft.com> wrote in message
>> news:263C5623-FDC3-4923-BE4F-FCBF60013EC8[ at ]microsoft.com...
>> > 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" <FrankWood[ at ]discussions.microsoft.com> wrote in message
>> >> news:85A60A01-158D-4376-A359-D97432AB21A9[ at ]microsoft.com...
>> >> > 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[ at ]aol.com
>> >> > Hank 4 Fred[ at ]aol.com
>> >> > Billy 5 Fred[ at ]aol.com
>> >> > Tom 7 Sally[ at ]aol.com
>> >> > William 5 Sally[ at ]aol.com
>> >> > etc...
>> >> >
>> >> > I wish to create a macro that would take all those associated with
>> >> > Fred[ at ]aol.com and distributes that info into a lotus notes email body
>> >> > and
>> >> > sends them to fred[ at ]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[ at ]cox.net
>> >>
>> >>
>> >>
>>
|
|
|