[mso] Re: mso Digest V2 #145, "Re: Excel 2000 and Outlook 2000 questions"

Linda,

thanks for the suggestion about ClickYes - unfortunately, I don't think that
we can use it because it would have to be installed by our network
administrators, and they'd probably take a dim view on it.

But, I'll give it a try anyway - they might just give way considering how
important our team is at the moment.

Regards,
Richard Watt

----- Original Message ----- 
From: <mso@xxxxxxxxxxxxx>
To: "mso digest users" <ecartis@xxxxxxxxxxxxx>
Sent: Saturday, May 24, 2003 8:01 AM
Subject: mso Digest V2 #145


> MSO Digest
> To view individual posts in the archives, go here:
> http://www.freelists.org/archives/mso------------------------------------
> mso Digest Fri, 23 May 2003 Volume: 02  Issue: 145
>
> In This Issue:
> [mso] Excel 2000 and Outlook 2000 questions
> [mso] Re: Excel 2000 and Outlook 2000 questions
>
> ----------------------------------------------------------------------
>
> Subject: [mso] Re: Access Sub-Query  :VSMail mx2
> Date: Fri, 23 May 2003 09:31:21 -0400
> From: "Colli, Anthony G" <Anthony.Colli@xxxxxxx>
>
>
>
>
>
> Hi James.  Thanks.  That's what I ended up doing.  I'm a true Master
> when it comes to finding Plan B but I don't think it takes full
> advantage of the power in Access.  Anyone who looks at my DB creations
> could tell instantly what an ignorant, rank amateur I really am.  sigh.
> /g
>
>
> /g
>
> At least you are curious and ask questions when you need some guidance. =
> Lately I have spent quite a bit of time fixing a database application =
> that was put together by some one who had no idea what they were doing. =
> There are multiple tables with the same yet different data, non =
> normalized data, forms that don't work as expected ect... Now that it is =
> time to retrieve info from this database it's all but impossible to get =
> a correct data set. Very likely it will take me more time to fix that it =
> did to create.=20
>
> Sometimes plan B is often the better plan because of =
> architecture/user/budget/time constraints. I use plan B all the time!
>
> Keep up the good work and keep the questions coming.
>
> -Anthony
>
> ------------------------------
>
> From: "Richard Watt" <mad_mac@xxxxxxxxxxxxxx>
> Subject: [mso] Excel 2000 and Outlook 2000 questions
> Date: Fri, 23 May 2003 19:06:51 +0100
>
> Hi,
>
> I have two questions about Office 2000 from work.
>
> Firstly, we've got a database system that uses Excel for its front-end
that allows us to send emails through Outlook to acknowledge the receipt of
an application document. This works fine, except that the security settings
we have in place pop up warnings about the Excel code attempting to access
the address book (which it has to do to verify email addresses), and then
another about an application attempting to send email on our behalf: is this
OK?
>
> This is very annoying as Outlook 2000 is configured to make us wait
several seconds at the second prompt before it enables the "Yes" button -
this also eats into the time period that we can set for Outlook to grant
access to the address book to Excel (max. 10 minutes it seems).
>
> Is there any way that we can get rid of this? We'll probably have to ask
the IT administrators to remove it, but if there is a way, that would be
great.
>
> Secondly, I've written some code in Visual Basic 6 in Word that allows us
to complete a letter document with information from the same Excel database
as mentioned above. Everything is fine, except that I need to express a time
period as a number of years, and using a calculation formula, I can get the
period in days.
>
> I know that I can use the YEARFRAC worksheet function to do this in an
Excel worksheet, but I can't get access to this function from VB. I've tried
getting references to the workbook's add-ins, after checking that the
Analysis Toolpak is available, but to no avail.
>
> Any advice on this would be greatly appreciated.
>
> Luckily, I don't need answers until Monday evening at the latest: we've
got a bank holiday in the UK on Monday.
>
> Thanks in advance and best regards,
> Richard Watt
>
> ------------------------------
>
> Date: Fri, 23 May 2003 23:24:05 -0400
> From: "Linda F. Johnson" <linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
> Subject: [mso] Re: Excel 2000 and Outlook 2000 questions
>
>
> The same thing happens when you do a mail merge from Word to Outlook, so I
> use a little third party program called ClickYes that works really well.
> All it does is Click the Yes button for you, so you don't have to do it
> manually.
>
> You can get it here:
> http://www.express-soft.com/mailmate/clickyes.html
>
> Sorry...I'm clueless about your second question, since I don't do VBA
>
> Linda
> Publisher ~ ABC ~ All 'Bout Computers
> Owner ~ Linda's Computer Stop
> http://personal-computer-tutor.com
> FREE MS Office eBook Tutorial
> http://personal-computer-tutor.com/library.htm
>
>
>
> -----Original Message-----
> From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
> Of Richard Watt
> Sent: Friday, May 23, 2003 2:07 PM
> To: Microsoft Office Group
> Subject: [mso] Excel 2000 and Outlook 2000 questions
>
>
> Hi,
>
> I have two questions about Office 2000 from work.
>
> Firstly, we've got a database system that uses Excel for its front-end
that
> allows us to send emails through Outlook to acknowledge the receipt of an
> application document. This works fine, except that the security settings
we
> have in place pop up warnings about the Excel code attempting to access
the
> address book (which it has to do to verify email addresses), and then
> another about an application attempting to send email on our behalf: is
this
> OK?
>
> This is very annoying as Outlook 2000 is configured to make us wait
several
> seconds at the second prompt before it enables the "Yes" button - this
also
> eats into the time period that we can set for Outlook to grant access to
the
> address book to Excel (max. 10 minutes it seems).
>
> Is there any way that we can get rid of this? We'll probably have to ask
the
> IT administrators to remove it, but if there is a way, that would be
great.
>
>
>
> ------------------------------
>
> End of mso Digest V2 #145
> *************************
>
>
>

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in 
the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: