Connecting Tech Pros Worldwide Forums | Help | Site Map

vba code for AccessXP to Groupwise

bobh
Guest
 
Posts: n/a
#1: Apr 18 '07
Hi All,

I have an AccessXP vba procedure which attaches a report to Groupwise
and sends it to recipients. That line of code looks like this


MailApplication.Recipients.Add strTo


this line of code adds the name in 'strTo' to the 'To' line of the
GroupWise email.


What is the line of code that I would use to add a name to the 'CC'
line of the email???


thanks
bobh.


GH
Guest
 
Posts: n/a
#2: Apr 19 '07

re: vba code for AccessXP to Groupwise


On Apr 18, 3:41 pm, bobh <vulca...@isp.comwrote:
Quote:
Hi All,
>
I have an AccessXP vba procedure which attaches a report to Groupwise
and sends it to recipients. That line of code looks like this
>
MailApplication.Recipients.Add strTo
>
this line of code adds the name in 'strTo' to the 'To' line of the
GroupWise email.
>
What is the line of code that I would use to add a name to the 'CC'
line of the email???
>
thanks
bobh.
This question is rather out of my realm of experience, but have you
tried using MailApplication.CC to see if that exists? I've seen some
suggestions to use .To, .CC, and .BCC as opposed to a Recipients
array. I tried these, and they worked fine for Outlook. If that
doesn't work, a suggestion I found on a German Office discussion board
continues still uses the Recipients array to add all recipient types
then targets specific recipient types as follows:

MailApplication.Recipients.Add (BcEmpfänger) 'wenn kein Bc, dann
Zeile löschen
With MailApplication.Recipients(2) '(2), wenn Empfänger +
BcEmpfänger
.TargetType = 2 ' <-- For the BCC type
End With
(http://ms-office-forum.de/forum/showthread.php?t=117227)

Since I no longer have Groupwise to play with, I cannot test this
code, but I would imagine that TargetType of 1 would be for a standard
CC as opposed to a BCC.

HTH
- GH

Rick A.B.
Guest
 
Posts: n/a
#3: Apr 19 '07

re: vba code for AccessXP to Groupwise


Bob
Check out the SendObject Method

SendObject(ObjectType, ObjectName, OutputFormat, To, Cc, Bcc, Subject,
MessageText, EditMessage, TemplateFile)
I use it all the time with groupwise and it works fine.


bobh
Guest
 
Posts: n/a
#4: Apr 19 '07

re: vba code for AccessXP to Groupwise


On Apr 19, 9:27 am, "Rick A.B." <rick.bre...@minneapolis.eduwrote:
Quote:
Bob
Check out the SendObject Method
>
SendObject(ObjectType, ObjectName, OutputFormat, To, Cc, Bcc, Subject,
MessageText, EditMessage, TemplateFile)
I use it all the time with groupwise and it works fine.
I would but, the SendObject does not accept a disk file as it's
ObjectName, the file I'm sending is a pdf file that's store in a
folder so objectname does not accept
"c:\MyDocs\Authorize.pdf"

but thanks for the reply
bobh.

bobh
Guest
 
Posts: n/a
#5: Apr 19 '07

re: vba code for AccessXP to Groupwise


On Apr 19, 7:16 am, GH <borgcollectiv...@gmail.comwrote:
Quote:
On Apr 18, 3:41 pm, bobh <vulca...@isp.comwrote:
>
Quote:
Hi All,
>
Quote:
I have an AccessXP vba procedure which attaches a report to Groupwise
and sends it to recipients. That line of code looks like this
>
Quote:
MailApplication.Recipients.Add strTo
>
Quote:
this line of code adds the name in 'strTo' to the 'To' line of the
GroupWise email.
>
Quote:
What is the line of code that I would use to add a name to the 'CC'
line of the email???
>
Quote:
thanks
bobh.
>
This question is rather out of my realm of experience, but have you
tried using MailApplication.CC to see if that exists? I've seen some
suggestions to use .To, .CC, and .BCC as opposed to a Recipients
array. I tried these, and they worked fine for Outlook. If that
doesn't work, a suggestion I found on a German Office discussion board
continues still uses the Recipients array to add all recipient types
then targets specific recipient types as follows:
>
MailApplication.Recipients.Add (BcEmpfänger) 'wenn kein Bc, dann
Zeile löschen
With MailApplication.Recipients(2) '(2), wenn Empfänger +
BcEmpfänger
.TargetType = 2 ' <-- For the BCC type
End With
(http://ms-office-forum.de/forum/showthread.php?t=117227)
>
Since I no longer have Groupwise to play with, I cannot test this
code, but I would imagine that TargetType of 1 would be for a standard
CC as opposed to a BCC.
>
HTH
- GH
Hi,
Yes, I've tried several combinations of things including what you
suggested and nothing has worked so far..... :(

but thanks for your reply
bobh.

Closed Thread


Similar Microsoft Access / VBA bytes