Excel 97 VBA Help File
In the MS Excel Visual Basic Reference help file contents page, I click on
Functions and it only offers me functions beginning with the letter S. So, I
have a list of Solver and SQL functions.
But what about all the other functions in VBA, for example for doing
arithmetic and manipulating dates and strings? Why don't they show up?
Are they left out because those functions are all part of Visual Basic
generally, and the Excel VBA help file is specific to the _extra_ functions
in Excel VBA? It's the only explanation I can think of. Am I right, or have
I got a corrupted help file (vbaxl...junk mail filter doesn't work with rules?
I receive mail from many pop3 accounts and mailing lists.
I use rules to organize the mail within my mailbox. One
problem I am having is that the junk mail filter does not
screen mail that is affected by the rules.
So for instance, I get an email from some alternate
account that I have. The mail comes in and gets picked up
by the rule and moved to the appropriate folder. When
this happens, the junk mail filter never checks the
message. Only mail left in the Inbox is screened.
Can someone help figure out how to make this work or does
anyone have a workaround? I'd hate to ...export/import Exchange mail
Please let me know if this can be done:
1. I have two Exchange servers running in different domains A and B
2. Server A has 10 users and have email and AD entries for these users
3. Server A is a new box and only has AD entries and no email in email
Is there a way to export the mail messages, and other records from the
old Exchange mail boxes of the server A and then import it into the
corresponding mailboxes of a new Server B?
If they're in the same forest, the both Exchange servers should be in the
same organization, and you can use the Move Mailbox Wizard.
If they'...help need with VC 6.0 IDE and mfc
First let me explain the scenario where i m using this requirement.
We are Using CustomAppWizard and designing a wizard .One of the wizard
pages will Insert Composite controls as many as the user wants .
1.So i should be able to dynamically insert ATL controls without using
Insert Control Dailog.
2. can any one tell me how to dynamically create Template file in
TEMPLATE folder of resource view .
3. I want to include many files created by templet files and add them
to build by editing newproj.inf
Is it possible to do this.
4.I would even like to know if i have 2 ifles in my C drive h...Help, I cannot Save!
I created a document and locked the worksheet to protect the formulars
before creating a template for the document. But now when I open th
document and insert a new sheet using the template I created, th
document will refuse to save.
Once I click on save, office assistant will say "doc not saved". Wha
could I have done wrong? PLease help.
computerfineman's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3716
View this thread: http://www.excelforum.c...Can E-mail recipient policy be linked to the OU membership?
Running Exchange 2003 (mixed mode) and Windows 2003 server (Windows 2000
I'd like to create a e-mail recipient policy that is linked to the different
OU's that are created on the system.
Is it possible to link the policy to a specific OU or do I need to create
groups on the AD to control which recipients a policy applies to?
Yes, you can create a recipient policy that looks to just a specific OU. It
is done through LDAP queries. Here are some references to articles and
whitepapers that discuss how to work with recipient policies.
HO...Outlook Send/Receive mail SLOW
When I receive/send email, it loads sends/receives
extremely slow. The percentage indicator when
receiving/sending starts at 3-5% and stays that way for
awhile. After several minutes, the mail eventually comes
Any reason for this?
Whenever I open Outlook 2003, I am getting a dialog box which displays the
Microsoft Office Outlook has encountered a problem and needs to close. We
are sorry for the inconvenience
When I click Debug it displays a message box with the following error
"The instruction at "0x3007e993" referenced memory at "0x0000000:. The
memory could not be read"
When I click No it Visual Studio JIT debugger pops up.
I uninstalled and installed several times but still the problem persists.
Is there any regsitry entry that I've to modify/delete?
...Need Help with Deleting Empty Paragraphs in Word 2003
I have written the code below to delete all empty paragraphs at the end of a
document and then place the cursor at the end of the last paragraph.
It works fine as a stand alone sub in a new doc, but fails inside the real
document that contains other code that manipulates several documents.
The failure is that it will delete the last empty para, but then gets stuck
looping inside the While...Wend because subsequent .Delete are not happening.
So, the question is why would this work in one document, but then fail in
n = 0 ...HELP Recovering addresses and email from Outlook 2003
I had some serious driver issues that required re-installing XP from
disc. I did use the backup option and have a backup of all the old
data. And of course had to reinstall Office 2003.
Will third party software restore my old email and addresses or am I
out of luck?? Thanks for the help
> I had some serious driver issues that required re-installing XP from
> disc. I did use the backup option and have a backup of all the old
> data. And of course had to reinstall Office 2003.
> Will third party software restore my old email and addresses or am I
> out of lu...Setting up a new e-mail account
I'm trying to set up my yahoo account so that I receive
my e-mail messages in my Outlook Inbox. I went to
Accounts, and servers, and put in mail.yahoo.com for
incoming mail (POP3) and smtp.yahoo.com for outgoing mail
(smtp). When I click on the send/receive button I get an
Dave <firstname.lastname@example.org> wrote:
> I'm trying to set up my yahoo account so that I receive
> my e-mail messages in my Outlook Inbox. I went to
> Accounts, and servers, and put in mail.yahoo.com for
> incoming mail (POP3) and smtp.yahoo.com for outgoing mail
&...Receiving POP3 mail into Outlook without Send/Receive
I want the POP3 mail to be received into Outlook (If open) when the mail
arrives in POP3 account. Is that possible?
Set an Automatic Polling Interval.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
After furious head scratching, delanda asked:
| I want the POP3 mail to be received into Outlook (If open) when the
| mail arrives in POP3 account. Is that possible?
...Replying to an Outlook e-mail
When replying to e-mail in Outlook, everything works fine. But when I try to
reply to an e-mail that has an embedded picture in it, Outlook won't send it.
I get the message that the e-mail was sent, but it stays in the outbox and
"Jack Johnson" <email@example.com> wrote in message
> When replying to e-mail in Outlook, everything works fine. But when I try to
> reply to an e-mail that has an embedded picture in it, Outlook won't send
&...Help me identify my missing permission (Cannot open public folder) -2147217843 (Maybe Authentication Fails?)
The following snippet of code throws an error number -2147217843. When
I googled this error code, I see many references to authentication
failed. I am assuming my problem is some kind of permission related
problem on the "MyNewFolder" public folder.
-- start code ---
Dim objFolder As New CDO.Folder
Dim f As ADODB.Field
'sURL is like: file://./backofficestorage/mydomain.com/Public
objFolder.DataSource.Open sURL, , adModeReadWrite, adFailIfNotExists
--- end code --
I have code that runs before this that actually creates the
"MyNewFolder" publ...Need HELP! for Linking data
Could someone please direct me to where I can learn how to link date in a
work book. i.e., I have individual pages for each subject but I need the
data that is entered in these individual pages to transfer to the Master
without having to manually in put it.........TNX
There are not too many bits about linking worksheets or workbooks that I can
But have a look at the links below, in case they give you the information
I think it is frustratingly one of those things which is very easy when you
know how, or if you can get someone to actually show you, but if you hav...I want to add a mail account without setting a SMTP server. Is it possible?
I want to add a second mail account that is outside my company.
Since the company firewall does not allow us to connect to SMTP-servers I
to add this account without setting the SMTP propertiy.
I cannot specify the company server as it is an Exchange server and the
outside one an IMAP one.
Currently I have specified the outside SMTP server since outook does not
allow me to add an account wihtout setting this.
I keep getting annoying error messages as my computer can't connect to the
Any one know a way around this?
The company server has SMTP enabled, u...Saving e-mail & attachments when upgrading
I'm upgrading from NT4 to XP Home and the only data I need
to keep are the emails & attachments. I have to format the
hard drive to eliminate the partitions. This machine is on
a network and I can save to the other machune.
Look here for all the information you need on backup and restoration of
MVP - Outlook
*** Replies sent to my e-mail address will probably not be answered --
please reply only to the newsgroup to preserve the message thread. ***
"Mike" <firstname.lastname@example.org> wrote ...Help with Registration
Operating System: Mac OS X 10.5 (Leopard)
I've tried to register my copy of Office for Mac through the Mactopia page. I log in successfully, but then it just keeps on loading and doesn't refresh or change.
On 6/16/09 6:35 PM, in article email@example.comR9absDaxw,
"firstname.lastname@example.org" <email@example.com> wrote:
> I've tried to register my copy of Office for Mac through the Mactopia page. I
> log in successfully, but then it just keeps on loading and doesn't refresh or
> ...how to install Microsoft Mail to Outlook 2003
I found 'this' (http://www.outlook-tips.net/howto/msmail.htm) on
I don't know if it works...
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Outlook Tips: http://www.outlook-tips.net/
Search for answers: http://groups.google.com
Most recent posts to the Outlook newsgroups:
...Help about numeric type field. Thanks.
I created a SQL Server 2005 CE DB ( .sdf, version 3.0) with vs2005. And I
created a table which has 2 fields: fld1 - int, fld2 - numeric(38,25).
But I encounted an error messagebox when I tried to insert a record
The msgbox said Conversion overflows.
The setting for my numeric fld2 is (precision=38,scale=25). So why occur
error when to insert 9000000?
Thanks in advance.
...HELP! Outlook POP3 problem(s)
Hello. I am so lost. I have a few e-mail accounts set up on my computer
which retrieves my mail from a couple of different providers and deposits the
mail into my Outlook Inbox. Up until yesterday, my mail always has worked
fine. For some strange reason, my Outlook is now (Again) retrieving my
messages from all of my accounts I had set up, which are all duplicates of my
messages. There is now nearly 4,000 duplicate messages in my folders. I
can't seem to stop the download of these already retrieved messages. To top
things off, a couple of my email account login windows keep p...Spam Filtering HELP
I recently started a new job, and discovered after day one, that I had
inharited a spam mess. Now the previous admin ad installed a Symantic
Spam Server Prox which in my opinion, was a complete waste of money as
it does not allow for blocking IP addresses.
Now here is the question;
I am running Exchange 2003, and am looking at setting up the Conection
Filter under Message Delivery to block messages based on IP address.
The problem is that when I save the IPs to be blocked, I get a message
stating that the Connection filter "has to be enabled manually through
the specific SMTP virtual serv...Need macro help to close excel
I have created a button in Access2000 that opens an Excel Spreadsheet. What
I need now is assit in closing excel upon completion. I can get an excel
macro to save my file and close the worksheet, but it is not closing excel
entirely. I'm on project with this employer and could use a response today
to fix this before I leave. Thanks much to any and all. My macro is as
' SaveClose Macro
' Macro recorded 9/27/2004 by cdjohnso
' Keyboard Shortcut: Ctrl+Shift+C
ActiveWorkb...Duplicate E-Mail #4
Every time I get e-mail from certain users I get their e-mail twice. I
have not been able to figure out why this is happening. Is it their
fault or my fault and if it is my fault, how do I fix it?
Alfred Kaufmann <firstname.lastname@example.org> wrote:
> Every time I get e-mail from certain users I get their e-mail twice. I
> have not been able to figure out why this is happening. Is it their
> fault or my fault and if it is my fault, how do I fix it?
See if this helps: http://www.howto-outlook.com/faq/duplicates.htm
Brian Tillman [MVP-Outlook]
...Help with simple(?) VBA function
I'm trying to selectively BOLD cells by the use of a User-Defined function.
The VBA Help topics suggest something like this:
Worksheets("Sheet1").Range("A1:A5").Font.Bold = True
When I try to use it the referenced cells are not changed and the function
Can anyone point this VBA neophyte in the right direction?
A function can only return a value.
Macros and Functions (Macros as Opposed to Functions)