I am using the Send Object command to send selected reports using
GroupWise in Novell Network. The following statement is used to attach a
report to GroupWise email and send it to specific user. There could be
anywhere from 1 to 300 e-mail sent at a any one time. 

                    DoCmd.SendObject acReport,     
                    "rptDataEntryCheckToEmail", _
                    "SnapshotFormat(*.snp)", strTo, _
                    strCC, "", strSubject, strBody, False, ""


This works great, however, when the user clicks Email command button
"Choose Profile" dialogue box pops up. The dialogue box defaults to
"Novel Default Settings" and all the user has to do is click OK button
to continue. 

The dialogue box is only displayed once regardless of how many records
the SendEmail function are processed or how many e-mails are sent to
various email addresses.  

The problem with "Choose Profile" dialogue box is the fact that same
users click Email button and walking away thinking the process is going
to take a long time so they may as well do something else in the mean
time. However, if the user walks away too quickly the user may not click
OK when "Choose Profile" dialogue box pops up. 

The email function takes anywhere from 5 to 60 minutes to process
filtered records and send e-mail remainders to selected people. If the
user does not click OK button when prompted by "Choose Profile" dialogue
box, he or she comes back later to find that  "Choose Profile" dialogue
box is still there waiting for someone to click OK button. 

At that stage the user gets really angry with the &%&^ programmer who
didn't program the application to automatically send e-mails without the
$%^ dialogue box coming up in the first place. 

As the programmer in the firing line I am begging anyone to tell me how
to use DoCmd.SendObject without "Choose Profile" dialogue box coming up
at all. Help, users of this application are after blood (my blood). Any
help will be greatly appreciated.


____________________________________________________


John Fejsa
Systems Analyst/Computer Programmer
Hunter Centre for Health Advancement
Locked Bag 10, WALLSEND NSW 2287
Phone: (02) 4924 6336 Fax: (02) 4924 6209
www.hcha.org.au
____________________________________________________


The doors we open and close each day decide the lives we live

____________________________________________________


CONFIDENTIALITY & PRIVILEGE NOTICE

This message is intended for the addressee named
and may contain confidential information.

If you are not the intended recipient, please
delete it and notify the sender.

Views expressed in this message are those of the
individual sender, and are not necessarily the
views of Hunter Health.

John,

<< The problem with "Choose Profile" dialogue box is the fact that same
users click Email button and walking away thinking the process is going
to take a long time so they may as well do something else in the mean
time. However, if the user walks away too quickly the user may not click
OK when "Choose Profile" dialogue box pops up. >>

I have a similar problem with sending e-mail via GroupWise.  Currently, I 
programmed a MsgBox to appear immediately after the user clicks the "Send 
E-Mail" command button warning that this dialog box may appear and to 
simply click OK if it does.  Until you find an automatic, coded way to 
avoid the box, I would put a similar MsgBox in your code.

Also, I would encourage you to do two things:

1) In the same MsgBox, warn the user that e-mail may take five to sixty 
minutes to compile, and

2) After the e-mail compliles and sends, use another MsgBox to tell the 
user that it has finished.  In this way, the user isn't sitting there 
guessing if the e-mail has been sent or not.

In the meantime, I'm going to search Windows to see what file is updated 
(if any) when clicking OK to the "Choose Profile" dialog box.  If clicking 
OK updates some kind of .INI file, you could program Access to head 
GroupWise off at the pass.  That is, to edit the .INI file and insert the 
proper command line, save it, and THEN send the e-mail.  Once the proper 
command line is in the .INI file, when Access issues the send e-mail 
command, the "Choose Profile" dialog box will not appear... ever.

Greg

If the pc is specific to one user, in the Administrative Tools | Mail ,
click SHOW PROFILES and select the option to "Always Use This Profile" and
whenever you use the send command, it will automatically launch the email
message and close when finished.  The user won't have to choose a profile.

hth,

Beth

-----Original Message-----
From: Gregory Serrano [mailto:SerranoG@m...] 
Sent: Thursday, February 20, 2003 11:51 AM
To: Access
Subject: [access] Re: Email Choose Profile Pop-up Dialogue Box

John,

<< The problem with "Choose Profile" dialogue box is the fact that same
users click Email button and walking away thinking the process is going
to take a long time so they may as well do something else in the mean
time. However, if the user walks away too quickly the user may not click
OK when "Choose Profile" dialogue box pops up. >>

I have a similar problem with sending e-mail via GroupWise.  Currently, I 
programmed a MsgBox to appear immediately after the user clicks the "Send 
E-Mail" command button warning that this dialog box may appear and to 
simply click OK if it does.  Until you find an automatic, coded way to 
avoid the box, I would put a similar MsgBox in your code.

Also, I would encourage you to do two things:

1) In the same MsgBox, warn the user that e-mail may take five to sixty 
minutes to compile, and

2) After the e-mail compliles and sends, use another MsgBox to tell the 
user that it has finished.  In this way, the user isn't sitting there 
guessing if the e-mail has been sent or not.

In the meantime, I'm going to search Windows to see what file is updated 
(if any) when clicking OK to the "Choose Profile" dialog box.  If clicking 
OK updates some kind of .INI file, you could program Access to head 
GroupWise off at the pass.  That is, to edit the .INI file and insert the 
proper command line, save it, and THEN send the e-mail.  Once the proper 
command line is in the .INI file, when Access issues the send e-mail 
command, the "Choose Profile" dialog box will not appear... ever.

Greg

Thanks Serranno

I actually do display a warning message before the process starts
executing and give the user an option of cancalling the process (see
code below)

    strMsg = "This could take a long time!" _
            & "@Depending on the number of records required to be
processed " _
            & "this function could take anywhere between 30 seconds and
60 minutes. " _
            & vbCrLf & vbCrLf & "Press OK button now to start the
process or Cancel button to exit." _
            & "@WARNING: Do NOT press Cancel or Exit buttons while the
process is in progress " _
            & "becuse this could result in lost emails."
    beep
    intDoIt = MsgBox(strMsg, vbQuestion + vbOKCancel + vbDefaultButton1,
"Are you sure?")
    
    If intDoIt = vbCancel Then
        Exit Sub
    End If

However, I will try to add the second part warning them that they may
get another message box regarding "Choose Profile" dialogue box.

I also received the following email from Joe Dunn and I am going to
investigate the product he recommended in the email.

===============================================

I am currently looking at a "PDF and Email library' for Access from ACG
(Attac Consulting Group) - it handles Outlook, Lotus Notes and
GroupWise.
Might be worth looking at - I need to send 6 or 8 reports to each of 20
sites each week and I am planning to:

output the reports in PDF
merge the PDF files for each site into 1 PDF
generate an e-mail with the 1 PDF file attached
send 2 e-mail to each site (one for Manager, one for general office
staff)

ACG can be reached at

http://ourworld.compuserve.com/homepages/attac-cg/acgsoft.htm

ATTAC Consulting Group
2869 Baylis Drive
Ann Arbor
MI 48107-1705 USA

Hope this helps!




____________________________________________________


John Fejsa
Systems Analyst/Computer Programmer
Hunter Centre for Health Advancement
Locked Bag 10, WALLSEND NSW 2287
Phone: (02) 4924 6336 Fax: (02) 4924 6209
www.hcha.org.au
____________________________________________________


The doors we open and close each day decide the lives we live

____________________________________________________


CONFIDENTIALITY & PRIVILEGE NOTICE

>>> SerranoG@m... 21/02/2003 4:51:04 >>>
John,

<< The problem with "Choose Profile" dialogue box is the fact that same
users click Email button and walking away thinking the process is going
to take a long time so they may as well do something else in the mean
time. However, if the user walks away too quickly the user may not click
OK when "Choose Profile" dialogue box pops up. >>

I have a similar problem with sending e-mail via GroupWise.  Currently,
I 
programmed a MsgBox to appear immediately after the user clicks the
"Send 
E-Mail" command button warning that this dialog box may appear and to 
simply click OK if it does.  Until you find an automatic, coded way to 
avoid the box, I would put a similar MsgBox in your code.

Also, I would encourage you to do two things:

1) In the same MsgBox, warn the user that e-mail may take five to sixty 
minutes to compile, and

2) After the e-mail compliles and sends, use another MsgBox to tell the 
user that it has finished.  In this way, the user isn't sitting there 
guessing if the e-mail has been sent or not.

In the meantime, I'm going to search Windows to see what file is updated

(if any) when clicking OK to the "Choose Profile" dialog box.  If
clicking 
OK updates some kind of .INI file, you could program Access to head 
GroupWise off at the pass.  That is, to edit the .INI file and insert
the 
proper command line, save it, and THEN send the e-mail.  Once the proper

command line is in the .INI file, when Access issues the send e-mail 
command, the "Choose Profile" dialog box will not appear... ever.

Greg

This message is intended for the addressee named
and may contain confidential information.

If you are not the intended recipient, please
delete it and notify the sender.

Views expressed in this message are those of the
individual sender, and are not necessarily the
views of Hunter Health.

Beth,

<< If the pc is specific to one user, in the Administrative Tools | Mail ,
click SHOW PROFILES and select the option to "Always Use This Profile" and
whenever you use the send command, it will automatically launch the email
message and close when finished.  The user won't have to choose a profile. 
>>

I'm using GroupWise version 5.5 and I don't see a menu 
with "Administrative Tools" anywhere.  The closest I get is Tools | 
Options.

When I do get the "Choose Profile" dialog box, there is an OPTIONS button 
there that I click and, lo and behold, there's a checkbox labeled "Make 
this profile the default."  However, when I clicked it and rebooted my 
computer, the dialog box still popped up and the checkbox was magically 
UNchecked.  D'OH!  How do I make it stick?

Oh, BTW, John... if you know how many records you're going to process 
before you compose the e-mail messages, you can create a function that 
calculates how long the processing will take based on that number.  Then 
in the warning message, instead of saying, "This may take a long time!" 
you can estimate, "This procedure will take approxmiately X minutes to 
complete."

Greg

Sorry I can't help you with this one Greg.  I'm not familiar with GroupWise.

Maybe someone else out there will have the answer.

Beth 
INI, Inc.
www.iniinc.com
-----Original Message-----
From: Gregory Serrano [mailto:SerranoG@m...] 
Sent: Friday, February 21, 2003 11:01 AM
To: Access
Subject: [access] Re: Email Choose Profile Pop-up Dialogue Box

Beth,

<< If the pc is specific to one user, in the Administrative Tools | Mail ,
click SHOW PROFILES and select the option to "Always Use This Profile" and
whenever you use the send command, it will automatically launch the email
message and close when finished.  The user won't have to choose a profile. 
>>

I'm using GroupWise version 5.5 and I don't see a menu 
with "Administrative Tools" anywhere.  The closest I get is Tools | 
Options.

When I do get the "Choose Profile" dialog box, there is an OPTIONS button 
there that I click and, lo and behold, there's a checkbox labeled "Make 
this profile the default."  However, when I clicked it and rebooted my 
computer, the dialog box still popped up and the checkbox was magically 
UNchecked.  D'OH!  How do I make it stick?

Oh, BTW, John... if you know how many records you're going to process 
before you compose the e-mail messages, you can create a function that 
calculates how long the processing will take based on that number.  Then 
in the warning message, instead of saying, "This may take a long time!" 
you can estimate, "This procedure will take approxmiately X minutes to 
complete."

Greg

Gregory,

You can go to http://www.mvps.org/access and do the search for GroupWise and
you will
be able to download a zip file that contains a database with a couple of
modules that will satisfied
your need to send email with or without attachments using GroupWise.  The
only down fall that I'd
experience is that if you want to group emails you would have loop thru the
process for every recipients.

Good Luck,
Derrick Flores
San Antonio, Texas


----- Original Message -----
From: "Gregory Serrano" <SerranoG@m...>
To: "Access" <access@p...>
Sent: Friday, February 21, 2003 5:00 PM
Subject: [access] Re: Email Choose Profile Pop-up Dialogue Box


> Beth,
>
> << If the pc is specific to one user, in the Administrative Tools | Mail ,
> click SHOW PROFILES and select the option to "Always Use This Profile" and
> whenever you use the send command, it will automatically launch the email
> message and close when finished.  The user won't have to choose a profile.
> >>
>
> I'm using GroupWise version 5.5 and I don't see a menu
> with "Administrative Tools" anywhere.  The closest I get is Tools |
> Options.
>
> When I do get the "Choose Profile" dialog box, there is an OPTIONS button
> there that I click and, lo and behold, there's a checkbox labeled "Make
> this profile the default."  However, when I clicked it and rebooted my
> computer, the dialog box still popped up and the checkbox was magically
> UNchecked.  D'OH!  How do I make it stick?
>
> Oh, BTW, John... if you know how many records you're going to process
> before you compose the e-mail messages, you can create a function that
> calculates how long the processing will take based on that number.  Then
> in the warning message, instead of saying, "This may take a long time!"
> you can estimate, "This procedure will take approxmiately X minutes to
> complete."
>
> Greg

Hi Beth

Thanks for the information but 

1) Administrative staff move from workstation to workstation so I would
have to set it on multiple machines, if I could make your suggestion
work...

2) However, I couldn't make your suggestion work. First of all, I
couldn't find Administrative Tools, Mail as you instructed so I used
Control Panel, Mail instead (I suppose I got there anyway.) 

In the general tab under "When starting Windows Messaging use this
profile" label "Novel Defauls Setting" was already selected in the
combobox but  there wasn't  anything that allowed me to select "Always
Use This Profile" option. I am not sure how to actually set it. I had a
look on both NT 4 (SP6) and XP Professional platforms and neither of
them have that option. Can you send me a screen shot from your computer
at: 

john.fejsa@h...

so I can see where I went wrong.

Thanks

____________________________________________________


John Fejsa
Systems Analyst/Computer Programmer
Hunter Centre for Health Advancement
Locked Bag 10, WALLSEND NSW 2287
Phone: (02) 4924 6336 Fax: (02) 4924 6209
www.hcha.org.au
____________________________________________________


The doors we open and close each day decide the lives we live

____________________________________________________


CONFIDENTIALITY & PRIVILEGE NOTICE

>>> BethMoffitt@i... 21/02/2003 5:58:09 >>>
If the pc is specific to one user, in the Administrative Tools | Mail ,
click SHOW PROFILES and select the option to "Always Use This Profile"
and
whenever you use the send command, it will automatically launch the
email
message and close when finished.  The user won't have to choose a
profile.

hth,

Beth

-----Original Message-----
From: Gregory Serrano [mailto:SerranoG@m...] 
Sent: Thursday, February 20, 2003 11:51 AM
To: Access
Subject: [access] Re: Email Choose Profile Pop-up Dialogue Box

John,

<< The problem with "Choose Profile" dialogue box is the fact that same
users click Email button and walking away thinking the process is going
to take a long time so they may as well do something else in the mean
time. However, if the user walks away too quickly the user may not click
OK when "Choose Profile" dialogue box pops up. >>

I have a similar problem with sending e-mail via GroupWise.  Currently,
I 
programmed a MsgBox to appear immediately after the user clicks the
"Send 
E-Mail" command button warning that this dialog box may appear and to 
simply click OK if it does.  Until you find an automatic, coded way to 
avoid the box, I would put a similar MsgBox in your code.

Also, I would encourage you to do two things:

1) In the same MsgBox, warn the user that e-mail may take five to sixty 
minutes to compile, and

2) After the e-mail compliles and sends, use another MsgBox to tell the 
user that it has finished.  In this way, the user isn't sitting there 
guessing if the e-mail has been sent or not.

In the meantime, I'm going to search Windows to see what file is updated

(if any) when clicking OK to the "Choose Profile" dialog box.  If
clicking 
OK updates some kind of .INI file, you could program Access to head 
GroupWise off at the pass.  That is, to edit the .INI file and insert
the 
proper command line, save it, and THEN send the e-mail.  Once the proper

command line is in the .INI file, when Access issues the send e-mail 
command, the "Choose Profile" dialog box will not appear... ever.

Greg


This message is intended for the addressee named
and may contain confidential information.

If you are not the intended recipient, please
delete it and notify the sender.

Views expressed in this message are those of the
individual sender, and are not necessarily the
views of Hunter Health.

Sorry for the delay John.  I've been out ill, but I have replied to you
personally under separate email.

Beth

-----Original Message-----
From: John Fejsa [mailto:John.Fejsa@h...] 
Sent: Sunday, February 23, 2003 3:13 PM
To: Access
Subject: [access] Re: Email Choose Profile Pop-up Dialogue Box


Hi Beth

Thanks for the information but 

1) Administrative staff move from workstation to workstation so I would
have to set it on multiple machines, if I could make your suggestion
work...

2) However, I couldn't make your suggestion work. First of all, I
couldn't find Administrative Tools, Mail as you instructed so I used
Control Panel, Mail instead (I suppose I got there anyway.) 

In the general tab under "When starting Windows Messaging use this
profile" label "Novel Defauls Setting" was already selected in the
combobox but  there wasn't  anything that allowed me to select "Always
Use This Profile" option. I am not sure how to actually set it. I had a
look on both NT 4 (SP6) and XP Professional platforms and neither of
them have that option. Can you send me a screen shot from your computer
at: 

john.fejsa@h...

so I can see where I went wrong.

Thanks

____________________________________________________


John Fejsa
Systems Analyst/Computer Programmer
Hunter Centre for Health Advancement
Locked Bag 10, WALLSEND NSW 2287
Phone: (02) 4924 6336 Fax: (02) 4924 6209
www.hcha.org.au
____________________________________________________


The doors we open and close each day decide the lives we live

____________________________________________________


CONFIDENTIALITY & PRIVILEGE NOTICE

>>> BethMoffitt@i... 21/02/2003 5:58:09 >>>
If the pc is specific to one user, in the Administrative Tools | Mail ,
click SHOW PROFILES and select the option to "Always Use This Profile"
and
whenever you use the send command, it will automatically launch the
email
message and close when finished.  The user won't have to choose a
profile.

hth,

Beth

-----Original Message-----
From: Gregory Serrano [mailto:SerranoG@m...] 
Sent: Thursday, February 20, 2003 11:51 AM
To: Access
Subject: [access] Re: Email Choose Profile Pop-up Dialogue Box

John,

<< The problem with "Choose Profile" dialogue box is the fact that same
users click Email button and walking away thinking the process is going
to take a long time so they may as well do something else in the mean
time. However, if the user walks away too quickly the user may not click
OK when "Choose Profile" dialogue box pops up. >>

I have a similar problem with sending e-mail via GroupWise.  Currently,
I 
programmed a MsgBox to appear immediately after the user clicks the
"Send 
E-Mail" command button warning that this dialog box may appear and to 
simply click OK if it does.  Until you find an automatic, coded way to 
avoid the box, I would put a similar MsgBox in your code.

Also, I would encourage you to do two things:

1) In the same MsgBox, warn the user that e-mail may take five to sixty 
minutes to compile, and

2) After the e-mail compliles and sends, use another MsgBox to tell the 
user that it has finished.  In this way, the user isn't sitting there 
guessing if the e-mail has been sent or not.

In the meantime, I'm going to search Windows to see what file is updated

(if any) when clicking OK to the "Choose Profile" dialog box.  If
clicking 
OK updates some kind of .INI file, you could program Access to head 
GroupWise off at the pass.  That is, to edit the .INI file and insert
the 
proper command line, save it, and THEN send the e-mail.  Once the proper

command line is in the .INI file, when Access issues the send e-mail 
command, the "Choose Profile" dialog box will not appear... ever.

Greg


This message is intended for the addressee named
and may contain confidential information.

If you are not the intended recipient, please
delete it and notify the sender.

Views expressed in this message are those of the
individual sender, and are not necessarily the
views of Hunter Health.

I am having the same problem.  Can you post the resolution to the list

-----Original Message-----
From: Beth Moffitt [mailto:BethMoffitt@i...]
Sent: Wednesday, February 26, 2003 10:04 AM
To: Access
Subject: [access] Re: Email Choose Profile Pop-up Dialogue Box


Sorry for the delay John.  I've been out ill, but I have replied to you
personally under separate email.

Beth

-----Original Message-----
From: John Fejsa [mailto:John.Fejsa@h...] 
Sent: Sunday, February 23, 2003 3:13 PM
To: Access
Subject: [access] Re: Email Choose Profile Pop-up Dialogue Box


Hi Beth

Thanks for the information but 

1) Administrative staff move from workstation to workstation so I would
have to set it on multiple machines, if I could make your suggestion
work...

2) However, I couldn't make your suggestion work. First of all, I
couldn't find Administrative Tools, Mail as you instructed so I used
Control Panel, Mail instead (I suppose I got there anyway.) 

In the general tab under "When starting Windows Messaging use this
profile" label "Novel Defauls Setting" was already selected in the
combobox but  there wasn't  anything that allowed me to select "Always
Use This Profile" option. I am not sure how to actually set it. I had a
look on both NT 4 (SP6) and XP Professional platforms and neither of
them have that option. Can you send me a screen shot from your computer
at: 

john.fejsa@h...

so I can see where I went wrong.

Thanks

____________________________________________________


John Fejsa
Systems Analyst/Computer Programmer
Hunter Centre for Health Advancement
Locked Bag 10, WALLSEND NSW 2287
Phone: (02) 4924 6336 Fax: (02) 4924 6209
www.hcha.org.au
____________________________________________________


The doors we open and close each day decide the lives we live

____________________________________________________


CONFIDENTIALITY & PRIVILEGE NOTICE

>>> BethMoffitt@i... 21/02/2003 5:58:09 >>>
If the pc is specific to one user, in the Administrative Tools | Mail ,
click SHOW PROFILES and select the option to "Always Use This Profile"
and
whenever you use the send command, it will automatically launch the
email
message and close when finished.  The user won't have to choose a
profile.

hth,

Beth

-----Original Message-----
From: Gregory Serrano [mailto:SerranoG@m...] 
Sent: Thursday, February 20, 2003 11:51 AM
To: Access
Subject: [access] Re: Email Choose Profile Pop-up Dialogue Box

John,

<< The problem with "Choose Profile" dialogue box is the fact that same
users click Email button and walking away thinking the process is going
to take a long time so they may as well do something else in the mean
time. However, if the user walks away too quickly the user may not click
OK when "Choose Profile" dialogue box pops up. >>

I have a similar problem with sending e-mail via GroupWise.  Currently,
I 
programmed a MsgBox to appear immediately after the user clicks the
"Send 
E-Mail" command button warning that this dialog box may appear and to 
simply click OK if it does.  Until you find an automatic, coded way to 
avoid the box, I would put a similar MsgBox in your code.

Also, I would encourage you to do two things:

1) In the same MsgBox, warn the user that e-mail may take five to sixty 
minutes to compile, and

2) After the e-mail compliles and sends, use another MsgBox to tell the 
user that it has finished.  In this way, the user isn't sitting there 
guessing if the e-mail has been sent or not.

In the meantime, I'm going to search Windows to see what file is updated

(if any) when clicking OK to the "Choose Profile" dialog box.  If
clicking 
OK updates some kind of .INI file, you could program Access to head 
GroupWise off at the pass.  That is, to edit the .INI file and insert
the 
proper command line, save it, and THEN send the e-mail.  Once the proper

command line is in the .INI file, when Access issues the send e-mail 
command, the "Choose Profile" dialog box will not appear... ever.

Greg


This message is intended for the addressee named
and may contain confidential information.

If you are not the intended recipient, please
delete it and notify the sender.

Views expressed in this message are those of the
individual sender, and are not necessarily the
views of Hunter Health.

Denise,

As I replied to Greg, I'm not familiar with GroupWise.  I work in a strictly
'Microsoft Shop'.  

I'm using Office XP on XP OS and in the control panel, mail options, you can
specify to use a specific profile when launched.  This is what I have done
and I don't have any issues.  Again, there would be issues if a user does
not use the same pc unless you set every pc up under each login to launch
their specific profile.  I wonder, is there a registry setting for default?

Maybe someone else out there will have the answer for this issue when using
Novel.  

-----Original Message-----
From: Groleau, Denise [mailto:GroleauD@a...] 
Sent: Wednesday, February 26, 2003 10:14 AM
To: Access
Subject: [access] Re: Email Choose Profile Pop-up Dialogue Box

I am having the same problem.  Can you post the resolution to the list

-----Original Message-----
From: Beth Moffitt [mailto:BethMoffitt@i...]
Sent: Wednesday, February 26, 2003 10:04 AM
To: Access
Subject: [access] Re: Email Choose Profile Pop-up Dialogue Box


Sorry for the delay John.  I've been out ill, but I have replied to you
personally under separate email.

Beth

-----Original Message-----
From: John Fejsa [mailto:John.Fejsa@h...] 
Sent: Sunday, February 23, 2003 3:13 PM
To: Access
Subject: [access] Re: Email Choose Profile Pop-up Dialogue Box


Hi Beth

Thanks for the information but 

1) Administrative staff move from workstation to workstation so I would
have to set it on multiple machines, if I could make your suggestion
work...

2) However, I couldn't make your suggestion work. First of all, I
couldn't find Administrative Tools, Mail as you instructed so I used
Control Panel, Mail instead (I suppose I got there anyway.) 

In the general tab under "When starting Windows Messaging use this
profile" label "Novel Defauls Setting" was already selected in the
combobox but  there wasn't  anything that allowed me to select "Always
Use This Profile" option. I am not sure how to actually set it. I had a
look on both NT 4 (SP6) and XP Professional platforms and neither of
them have that option. Can you send me a screen shot from your computer
at: 

john.fejsa@h...

so I can see where I went wrong.

Thanks

____________________________________________________


John Fejsa
Systems Analyst/Computer Programmer
Hunter Centre for Health Advancement
Locked Bag 10, WALLSEND NSW 2287
Phone: (02) 4924 6336 Fax: (02) 4924 6209
www.hcha.org.au
____________________________________________________


The doors we open and close each day decide the lives we live

____________________________________________________


CONFIDENTIALITY & PRIVILEGE NOTICE

>>> BethMoffitt@i... 21/02/2003 5:58:09 >>>
If the pc is specific to one user, in the Administrative Tools | Mail ,
click SHOW PROFILES and select the option to "Always Use This Profile"
and
whenever you use the send command, it will automatically launch the
email
message and close when finished.  The user won't have to choose a
profile.

hth,

Beth

-----Original Message-----
From: Gregory Serrano [mailto:SerranoG@m...] 
Sent: Thursday, February 20, 2003 11:51 AM
To: Access
Subject: [access] Re: Email Choose Profile Pop-up Dialogue Box

John,

<< The problem with "Choose Profile" dialogue box is the fact that same
users click Email button and walking away thinking the process is going
to take a long time so they may as well do something else in the mean
time. However, if the user walks away too quickly the user may not click
OK when "Choose Profile" dialogue box pops up. >>

I have a similar problem with sending e-mail via GroupWise.  Currently,
I 
programmed a MsgBox to appear immediately after the user clicks the
"Send 
E-Mail" command button warning that this dialog box may appear and to 
simply click OK if it does.  Until you find an automatic, coded way to 
avoid the box, I would put a similar MsgBox in your code.

Also, I would encourage you to do two things:

1) In the same MsgBox, warn the user that e-mail may take five to sixty 
minutes to compile, and

2) After the e-mail compliles and sends, use another MsgBox to tell the 
user that it has finished.  In this way, the user isn't sitting there 
guessing if the e-mail has been sent or not.

In the meantime, I'm going to search Windows to see what file is updated

(if any) when clicking OK to the "Choose Profile" dialog box.  If
clicking 
OK updates some kind of .INI file, you could program Access to head 
GroupWise off at the pass.  That is, to edit the .INI file and insert
the 
proper command line, save it, and THEN send the e-mail.  Once the proper

command line is in the .INI file, when Access issues the send e-mail 
command, the "Choose Profile" dialog box will not appear... ever.

Greg


This message is intended for the addressee named
and may contain confidential information.

If you are not the intended recipient, please
delete it and notify the sender.

Views expressed in this message are those of the
individual sender, and are not necessarily the
views of Hunter Health.

John,

<< In the meantime, I'm going to search Windows to see what file is 
updated (if any) when clicking OK to the "Choose Profile" dialog box.  If 
clicking OK updates some kind of .INI file, you could program Access to 
head GroupWise off at the pass.  That is, to edit the .INI file and insert 
the proper command line, save it, and THEN send the e-mail.  Once the 
proper command line is in the .INI file, when Access issues the send e-
mail command, the "Choose Profile" dialog box will not appear... ever. >>

I did this.  The file that's updated is not a GroupWise .INI file.  It's a 
Windows .DAT file that Windows warns may damage the system if manually 
edited.  Therefore, Derrick's option is the only viable one so far.

Greg