473,385 Members | 1,707 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

vba code for AccessXP to Groupwise

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.

Apr 18 '07 #1
4 3645
GH
On Apr 18, 3:41 pm, bobh <vulca...@isp.comwrote:
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

Apr 19 '07 #2
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.
Apr 19 '07 #3
On Apr 19, 9:27 am, "Rick A.B." <rick.bre...@minneapolis.eduwrote:
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.

Apr 19 '07 #4
On Apr 19, 7:16 am, GH <borgcollectiv...@gmail.comwrote:
On Apr 18, 3:41 pm, bobh <vulca...@isp.comwrote:
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
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.

Apr 19 '07 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Steve | last post by:
Recently due to viruses I had to wipe my harddrive and reload everything. Now, in AccessXP(2000 and XP mode) all new reports and all reports in existing databases open in Fit to Page rather than...
1
by: Dennis Hartmann | last post by:
Has anyone found a "display" method for the GroupwareTypeLibrary.Message object, comparable to the Display method of the Outlook.MailItem object? I simply want end user or have the option of...
2
by: Norman Fritag | last post by:
Hi there are there any issues with sending multiple emails via GroupWise ver. 6??? please comment. Regards Norman
1
by: Molly J. Fagan | last post by:
Hello everyone-- I'm trying to develop a help desk system to replace Trak-It. We have a help desk e-mail address and want all messages sent to that e-mail address to go into an Access database...
5
by: Laertes | last post by:
Hi, I know there is already a plethora of emails regarding Groupwise/Access problems but mine is slightly different to the ones I've read about. I'm trying to use the sendobject command to...
0
by: Bob Hynes | last post by:
Hi All, In one of my Access97 db applications I created a report which I output to a RichTextFormat file attach it to an Email and send it out, that has worked just fine for a couple of years now....
2
by: Jim | last post by:
Tried a search, but didn't find quite what I was looking for. Situation: Have a VBA code process, tapping CDOSYS to send e-mail from Access, attaching an Excel spreadsheet, to a given list of...
5
cori25
by: cori25 | last post by:
Hi, I have been trying to come up with a module in access using VB to allow email messages to be sent using GroupWise. I am having a hard time and was wondering if anyone has any experience with...
5
by: bobh | last post by:
HI, I understand AccessXP file size has a 2 gig limit but I trying to understand the following I have a tab delimited data file that is 1.3 gigs big and I try to import it into an empty...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.