Outlook Mail Automation

Hi

We have developed a VFP6 app for a customer that sends mail through Outlook.
However our customer doesn't want all the recipients to be visible to each
other so I thought it would be ideal to use BCC if it is available.

I am currently using the following code to handle the mail

olMessage = olOutlook.CreateItem(olMailItem)
olRecipient = olmessage.Recipients.Add(addresslist)
olmessage.send()

Could this be modified to send via BCC instead of straight addresses ?

Thanks in advance

Andy

Jan
Fri Feb 11 06:24:44 CST 2005

Andy Gladwish napsal(a):
> Hi
>
> We have developed a VFP6 app for a customer that sends mail through Outlook.
> However our customer doesn't want all the recipients to be visible to each
> other so I thought it would be ideal to use BCC if it is available.
>
> I am currently using the following code to handle the mail
>
> olMessage = olOutlook.CreateItem(olMailItem)
> olRecipient = olmessage.Recipients.Add(addresslist)
olRecipient.Type=3 && olBCC
> olmessage.send()
>
> Could this be modified to send via BCC instead of straight addresses ?
>
> Thanks in advance
>
> Andy
>

Fred
Fri Feb 11 19:01:59 CST 2005

I don't try to use the recipients list, I just do this:
olMailItem=0

oOutLookObject = CreateObject("Outlook.Application")

oEmailItem = oOutLookObject.CreateItem(olMailItem)

WITH oEmailItem

.To = "joe@blow.com"

.CC = "copyjoe@blow.com"

.BCC = "blindcopyjoe@blow.com"

.Attachments.add("c:\somefile.txt")

.Subject = "This is the Subject"

.Send()

ENDWITH

You can string multiple email addresses together by separating them with a
";":

.BCC = "email1@test.com;email2@test.com;etc.."

--
Fred
Microsoft Visual FoxPro MVP


"Andy Gladwish" <AndyGladwish@discussions.microsoft.com> wrote in message
news:E2B2E488-4822-424D-85F2-997A3FE5254E@microsoft.com...
> Hi
>
> We have developed a VFP6 app for a customer that sends mail through
> Outlook.
> However our customer doesn't want all the recipients to be visible to each
> other so I thought it would be ideal to use BCC if it is available.
>
> I am currently using the following code to handle the mail
>
> olMessage = olOutlook.CreateItem(olMailItem)
> olRecipient = olmessage.Recipients.Add(addresslist)
> olmessage.send()
>
> Could this be modified to send via BCC instead of straight addresses ?
>
> Thanks in advance
>
> Andy
>

Jan
Mon Feb 14 01:09:30 CST 2005

Hi,
it works too, but it is not recommended my MS (see docu).


Fred Taylor napsal(a):
> I don't try to use the recipients list, I just do this:
> olMailItem=0
>
> oOutLookObject = CreateObject("Outlook.Application")
>
> oEmailItem = oOutLookObject.CreateItem(olMailItem)
>
> WITH oEmailItem
>
> .To = "joe@blow.com"
>
> .CC = "copyjoe@blow.com"
>
> .BCC = "blindcopyjoe@blow.com"
>
> .Attachments.add("c:\somefile.txt")
>
> .Subject = "This is the Subject"
>
> .Send()
>
> ENDWITH
>
> You can string multiple email addresses together by separating them with a
> ";":
>
> .BCC = "email1@test.com;email2@test.com;etc.."
>

Fred
Mon Feb 14 02:01:12 CST 2005

Where is this document that doesn't recommend it?

--
Fred
Microsoft Visual FoxPro MVP


"Jan Bucek" <bucek.jan@post.cz> wrote in message
news:uQKU%23PmEFHA.480@TK2MSFTNGP10.phx.gbl...
> Hi,
> it works too, but it is not recommended my MS (see docu).
>
>
> Fred Taylor napsal(a):
>> I don't try to use the recipients list, I just do this:
>> olMailItem=0
>>
>> oOutLookObject = CreateObject("Outlook.Application")
>>
>> oEmailItem = oOutLookObject.CreateItem(olMailItem)
>>
>> WITH oEmailItem
>>
>> .To = "joe@blow.com"
>>
>> .CC = "copyjoe@blow.com"
>>
>> .BCC = "blindcopyjoe@blow.com"
>>
>> .Attachments.add("c:\somefile.txt")
>>
>> .Subject = "This is the Subject"
>>
>> .Send()
>>
>> ENDWITH
>>
>> You can string multiple email addresses together by separating them with
>> a ";":
>>
>> .BCC = "email1@test.com;email2@test.com;etc.."
>>

Jan
Mon Feb 14 02:20:31 CST 2005

Fred Taylor napsal(a):
> Where is this document that doesn't recommend it?
>
Description of BCC property of MailItem:
...
Returns the display list of blind carbon copy (BCC) names for a
MailItem. This property contains the display names only. The Recipients
collection should be used to modify the BCC recipients.
...
in "C:\Program Files\Microsoft Office\Office\1029\VBAOUTL9.CHM" of my
Office2k.

For english is not my native language, maybe I understand it wrong?

Sincerely Jan Bucek

Fred
Mon Feb 14 09:06:42 CST 2005

All I know is it does work quite fine by referencing the .To/.CC/.BCC
properties. I've always found the Recipients collection a bit hard to deal
with, while the direct reference to the properties has always worked fine
for me.

Thanks for pointing it out, but it looks like it's a warning that has no
merit or is just plain wrong, possibly a documentation error or was true in
an earler version of Outlook. It works fine in OL2K,OLXP, OL2K3 (though XP
and 2K3 have the "problem" of trying to warn you that mail is being sent
through automation.

--
Fred
Microsoft Visual FoxPro MVP


"Jan Bucek" <bucek.jan@post.cz> wrote in message
news:e4JEr3mEFHA.1292@TK2MSFTNGP10.phx.gbl...
> Fred Taylor napsal(a):
>> Where is this document that doesn't recommend it?
>>
> Description of BCC property of MailItem:
> ...
> Returns the display list of blind carbon copy (BCC) names for a MailItem.
> This property contains the display names only. The Recipients collection
> should be used to modify the BCC recipients.
> ...
> in "C:\Program Files\Microsoft Office\Office\1029\VBAOUTL9.CHM" of my
> Office2k.
>
> For english is not my native language, maybe I understand it wrong?
>
> Sincerely Jan Bucek

Jim
Thu Feb 17 16:50:13 CST 2005

Is there a work around for the 'problem' of of trying to warn you that mail
is being sent through automation? I'm still using OL2K for that reason. I
send out email invitations for a survey using this method regularly
(oftentimes to 1000 or more people) and can't/won't upgrade my Office
because of the warning.

My server is NT4 (which is now not supported)
Exchange server 5.5 (which gets dropped later this year for support)
Outlook 2000 (which doesn't have the so-called security of later versions
of office)
all because I need this very important feature of emailing clients for my
surveys.

(I promise that I'm not a spammer - these are legitimate emails going out!!)

Thanks,
Jim Clay
Team Resources, Inc.
www.teamresources.com


"Fred Taylor" <ftaylor@mvps.org!REMOVE> wrote in message
news:OHHdKbqEFHA.1936@TK2MSFTNGP14.phx.gbl...
> All I know is it does work quite fine by referencing the .To/.CC/.BCC
> properties. I've always found the Recipients collection a bit hard to
> deal with, while the direct reference to the properties has always worked
> fine for me.
>
> Thanks for pointing it out, but it looks like it's a warning that has no
> merit or is just plain wrong, possibly a documentation error or was true
> in an earler version of Outlook. It works fine in OL2K,OLXP, OL2K3
> (though XP and 2K3 have the "problem" of trying to warn you that mail is
> being sent through automation.
>
> --
> Fred
> Microsoft Visual FoxPro MVP
>
>
> "Jan Bucek" <bucek.jan@post.cz> wrote in message
> news:e4JEr3mEFHA.1292@TK2MSFTNGP10.phx.gbl...
>> Fred Taylor napsal(a):
>>> Where is this document that doesn't recommend it?
>>>
>> Description of BCC property of MailItem:
>> ...
>> Returns the display list of blind carbon copy (BCC) names for a MailItem.
>> This property contains the display names only. The Recipients collection
>> should be used to modify the BCC recipients.
>> ...
>> in "C:\Program Files\Microsoft Office\Office\1029\VBAOUTL9.CHM" of my
>> Office2k.
>>
>> For english is not my native language, maybe I understand it wrong?
>>
>> Sincerely Jan Bucek
>
>

Fred
Thu Feb 17 19:35:11 CST 2005


Google for "Outlook Redemption" and/or "clickyes".

--
Fred
Microsoft Visual FoxPro MVP


"Jim Clay" <clay_j@bellsouth.net> wrote in message
news:OdhCMMUFFHA.936@TK2MSFTNGP12.phx.gbl...
> Is there a work around for the 'problem' of of trying to warn you that
> mail is being sent through automation? I'm still using OL2K for that
> reason. I send out email invitations for a survey using this method
> regularly (oftentimes to 1000 or more people) and can't/won't upgrade my
> Office because of the warning.
>
> My server is NT4 (which is now not supported)
> Exchange server 5.5 (which gets dropped later this year for support)
> Outlook 2000 (which doesn't have the so-called security of later versions
> of office)
> all because I need this very important feature of emailing clients for my
> surveys.
>
> (I promise that I'm not a spammer - these are legitimate emails going
> out!!)
>
> Thanks,
> Jim Clay
> Team Resources, Inc.
> www.teamresources.com
>
>
> "Fred Taylor" <ftaylor@mvps.org!REMOVE> wrote in message
> news:OHHdKbqEFHA.1936@TK2MSFTNGP14.phx.gbl...
>> All I know is it does work quite fine by referencing the .To/.CC/.BCC
>> properties. I've always found the Recipients collection a bit hard to
>> deal with, while the direct reference to the properties has always worked
>> fine for me.
>>
>> Thanks for pointing it out, but it looks like it's a warning that has no
>> merit or is just plain wrong, possibly a documentation error or was true
>> in an earler version of Outlook. It works fine in OL2K,OLXP, OL2K3
>> (though XP and 2K3 have the "problem" of trying to warn you that mail is
>> being sent through automation.
>>
>> --
>> Fred
>> Microsoft Visual FoxPro MVP
>>
>>
>> "Jan Bucek" <bucek.jan@post.cz> wrote in message
>> news:e4JEr3mEFHA.1292@TK2MSFTNGP10.phx.gbl...
>>> Fred Taylor napsal(a):
>>>> Where is this document that doesn't recommend it?
>>>>
>>> Description of BCC property of MailItem:
>>> ...
>>> Returns the display list of blind carbon copy (BCC) names for a
>>> MailItem. This property contains the display names only. The Recipients
>>> collection should be used to modify the BCC recipients.
>>> ...
>>> in "C:\Program Files\Microsoft Office\Office\1029\VBAOUTL9.CHM" of my
>>> Office2k.
>>>
>>> For english is not my native language, maybe I understand it wrong?
>>>
>>> Sincerely Jan Bucek
>>
>>
>
>

Jim
Fri Feb 18 09:09:03 CST 2005

It'll be a shotgun blast to the machine before I 'click yes' that many times
so I'll look for Outlook Redemption.

Thanks Fred.

Jim


"Fred Taylor" <ftaylor@mvps.org!REMOVE> wrote in message
news:OR$5WoVFFHA.3068@TK2MSFTNGP10.phx.gbl...
>
> Google for "Outlook Redemption" and/or "clickyes".
>
> --
> Fred
> Microsoft Visual FoxPro MVP
>
>
> "Jim Clay" <clay_j@bellsouth.net> wrote in message
> news:OdhCMMUFFHA.936@TK2MSFTNGP12.phx.gbl...
>> Is there a work around for the 'problem' of of trying to warn you that
>> mail is being sent through automation? I'm still using OL2K for that
>> reason. I send out email invitations for a survey using this method
>> regularly (oftentimes to 1000 or more people) and can't/won't upgrade my
>> Office because of the warning.
>>
>> My server is NT4 (which is now not supported)
>> Exchange server 5.5 (which gets dropped later this year for support)
>> Outlook 2000 (which doesn't have the so-called security of later
>> versions of office)
>> all because I need this very important feature of emailing clients for my
>> surveys.
>>
>> (I promise that I'm not a spammer - these are legitimate emails going
>> out!!)
>>
>> Thanks,
>> Jim Clay
>> Team Resources, Inc.
>> www.teamresources.com
>>
>>
>> "Fred Taylor" <ftaylor@mvps.org!REMOVE> wrote in message
>> news:OHHdKbqEFHA.1936@TK2MSFTNGP14.phx.gbl...
>>> All I know is it does work quite fine by referencing the .To/.CC/.BCC
>>> properties. I've always found the Recipients collection a bit hard to
>>> deal with, while the direct reference to the properties has always
>>> worked fine for me.
>>>
>>> Thanks for pointing it out, but it looks like it's a warning that has no
>>> merit or is just plain wrong, possibly a documentation error or was true
>>> in an earler version of Outlook. It works fine in OL2K,OLXP, OL2K3
>>> (though XP and 2K3 have the "problem" of trying to warn you that mail is
>>> being sent through automation.
>>>
>>> --
>>> Fred
>>> Microsoft Visual FoxPro MVP
>>>
>>>
>>> "Jan Bucek" <bucek.jan@post.cz> wrote in message
>>> news:e4JEr3mEFHA.1292@TK2MSFTNGP10.phx.gbl...
>>>> Fred Taylor napsal(a):
>>>>> Where is this document that doesn't recommend it?
>>>>>
>>>> Description of BCC property of MailItem:
>>>> ...
>>>> Returns the display list of blind carbon copy (BCC) names for a
>>>> MailItem. This property contains the display names only. The Recipients
>>>> collection should be used to modify the BCC recipients.
>>>> ...
>>>> in "C:\Program Files\Microsoft Office\Office\1029\VBAOUTL9.CHM" of my
>>>> Office2k.
>>>>
>>>> For english is not my native language, maybe I understand it wrong?
>>>>
>>>> Sincerely Jan Bucek
>>>
>>>
>>
>>
>
>