Exporting Date received and Date Sent to Access
How can export both 'date received' and 'date sent' fields to another program
such as Access or Excel?
However, if you use Access to set up a linked table connected to your =
mail folder, you will see the Received date among the available =
properties. (I don't remember whether Sent is also shown.) Third-party =
export tools are also available; see =
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
and Microsoft Outlook Programming - Jump...quick oe query
hope youre all doing well.
had to write a very long letter & had spent over an hour on it, then i hit
a button on the keyboard & just like that, it was all gone - not a draft,
not sent, not in the out box, just gone - what freaking button am i hitting
as this is not the first time!
Dell P 4, 3GHz, 512 MB DDR SDRAM, 160 GB, Win XP HomeSP2,
16X DVD-ROM & ,6X DVD+/RW, IE7, OE6, DSL, via AT&T. I use these on a regular
basis: Malwarebytes' Anti-Malware, Ad-Aware, Spybot, Spyware Blaster,
SuperAntiSpyware, BitDefender & C...Denying access to a worksheet
Can anyone tell me how I can deny access to a particular worksheet within a
workbook. I want it so that when someone clicks on the tab to access a
particular worksheet, unless they type in a password, they are denied
access. Thanks in advance
Put this in the ThisWorkbook code module (right-click on the workbook's
titlebar and choose View Code):
Assume that Sheet3 is to be protected, and if the correct password is
not entered, then sheet1, cell a1 is to be activated:
Private Sub Workbook_SheetActivate(ByVal Sh As Object)
Const csPWORD As String = "d...removing problem emails
How do I remove a problem email from Outlook? The email
in question keeps locking up Outlook faster than I can
attempt to delete it.
Do you have the preview pane on? If so, turn it off before trying to delete
the problem message.
This posting is provided "AS IS" with no warranties, and confers no rights
"kirky" <firstname.lastname@example.org> wrote in message
> How do I remove a problem email from Outlook? The email
> in question keeps locking up Outlook faster than I can
> ...Help With If Function #2
When you are using an "IF" function, I know you can use an "and" comparison
by using an asterisk between your comparisons, for example:
What I want to know is this: Is there anyway to do an "or" comparison? So my
formula would be:
Now, obviously I know I can't just stick the word "OR" in there but is there
a way to do this?
Getting confused here
is And, the Or is
=IF(OR(A1=1,B1=1),"S",...Remove all spaces in Macro
Can I change the code below so that it would auto-remove whenever there
are spaces and don't have to run macro everytime? I think can code
somthing to the change event of the worksheet, how to modify?
**Application.ScreenUpdating = False
**Application.Calculation = xlCalculationManual
LookAt:=xlPart, SearchOrder:=xlByColumns, MatchCase:=True
**Application.Calculation = xlCalculationAutomatic
**Application.ScreenUpdating = True
what is the meaning of...NEWBIE to ACCESS help with forms
I am looking to have a form, With 1 combo boxes (telephone), and the
rest text boxes.
I want to be able to select a telephone number and have the other 2
boxes shows the associated firstname and last name
so for example.. I have a table with 3 fields
Additionally IF POSSIBLE would want to be able to choose a last name,
show the telephone and first name associated
Thanks in advance
When you create a combo box using the wizard, it gives you two options:
Save the combo box selection to a field or
Look up a record using the combo ...oe 6.x
what are the file extensions for oe 6.x mail and for the oe 6.x
(?windows?) address book?
(friend *lost* the above)
thanks in advance
dbx and wab
Note that this is an Microsoft Office Outlook forum.
Outlook Express is family of Internet Explorer and Outlook of the Office
Here is the link for the right forum
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-Backup and Restore
-Create an Office XP CD slipstreamed with Service Pack 3
"Tanya" ...Timesheet #2
Ive got a timesheet woking now for my company but they are wanting me to add
2 more colums for flexi one for how much im in credit with flexi/overtime
over 37.5 hours and another colum saying if im in debit/ under hours worked
how can i get this to automatically put overtime or undertime straight into
the correct column.
> Hi all
> Ive got a timesheet woking now for my company but they are wanting me
> to add
> 2 more colums for flexi one for how much im in credit with
> over 37.5 hours and another colum saying if im i...remove duplicates except blanks
is it possible to have a macro that removes duplicates except blanks in a
It is not a problem, but we need more information.
Which column do you want to compare, should both entries be deleted?
"jat" <email@example.com> skrev i meddelelsen
> is it possible to have a macro that removes duplicates except blanks in a
With data in ColA try the below macro which will use ColB as a helper column...
Columns(1...removing inactive payroll deduction codes
If you inactivate a payroll deduction code, can you "remove/hide" it form
the lists so that it is not chosen for processing?
...Outlook 2003 and signatures #2
I am experiencing a problem with outlook 2003, and I will
appreciate if someone can give me some directions on how
to solve this. The problem is that I have added a
signature to my outlook so that it can attach in all
emails, either new or replies to email (both options are
selected on "mail format" under options). If I try to
write a new email, the signature attaches fine with no
problem, so it works as expected. The problem happens
when I try to reply to an email. When I hit reply, the
signature that is attached to the email is the "recipient
signature" inst...Want to remove/disable/re-map shortcut key to the help files
I want to be able to either uninstall or disable the help from opening
in Excel as eveytime I press F1 by miss-take the help files open which
makes my computer hang for about 5mins while they load.
I have looked under Add/Remove programmes and then clicked on the
modity section but there isnt any option for removing them.
If this cant be done is it possable to remap the shourtcut key to
somthing else so that I dont keep hitting it.
Im using Office 2000 btw
Thanks in advance,
Message posted from http://www.ExcelForum.com/
Maybe you could a line or two to your personal.xls (...remove to-do list in outlook 2007
Is there a way to remove the to-do list in tasks? everytime i open outlook i
have to click on tasks to see my tasks, in 2003 outlook remembers my last
selection but not in 2007
No, there isn't an option to do that, but as it happens I've just =
written a little VBA code that might help. Do you want to try it out? =
See http://www.outlookcode.com/d/vbabasics.htm if you're new to VBA.=20
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
and Microsoft Outlook Programming - Jumpstart for=20
Ad...Corruption of Access File
I think that since my client and myself don't have the same version of
Access the file gets corrupted when I get the latest version from my client
(they have Access 2000 and I have Access 2003)
What can be done?
Perform this sequence when you get the updated file:
Compact | Decompile | Compact | Compact | Compile
Tools | Database Utilities | Compact/Repair
To decompile, enter something like this at the command prompt while Access
is not running. It is all one line, and include the quotes:
"c:\Program Files\Microsoft office\offic...Any Way to Run Access Function in Separate Process?
We have a modal dialog in an Access application, that upon confirmation goes
out and does about 25 minutes of queries and then puts the result on the
clipboard. This long processing period locks the user out from the rest
of the application. We want to find a way to have this 25 minutes of data
gathering run in the background without blocking the user from interacting
with other parts of the application.
Is there any way to launch the function that takes so long to run in a
separate process space, so that it doesn't lock up the application while it
runs? We would obviously n...Removing visio
I'm having a problem removing visio from my computer.
I uninstalled the software from my computer but still see components that
belong to visio under add/remove list; example: "CAD drawing and Display",
"Block diagrams help", "Callouts and connectors", etc. These names appear
under add/remove list but do not do anything; when I click on any one of
them I don't see the usual change/remove button. The only info I see is the
frequency of use.
I checked the registry to try to remove them manually, but the entry doesn't
even appear there. Nothing fr...svchost.exe error #2
When sending email in Outlook 2002 I receive the following
message: svchost.exe has generated errors and will be
closed by windows.
If I reboot the email will go until the next time I
generate and email.
...how to remove the page break lines in a spread sheet,
Can someone tell me how to change the view bakc to plain spreadsheet without
page break lines. I cannot remove the lines with the remove page break
because I did not insert page break, but i cannot tell how i got into this
view and now i am stuck there.
Click on View and then choose Normal.
"gypsie g" wrote:
> Can someone tell me how to change the view bakc to plain spreadsheet without
> page break lines. I cannot remove the lines with the remove page break
> because I did not insert page break, but i cannot tell how i got into this
> view and no...Might be outgrowing Access but daunted by SQL Server
I'm close to completing the consolidation of various small Access databases
and a couple of Excel spreadsheets that my little company uses (5 staff) into
an all encompasing Access database and I was planning on splitting the
database when I was finished to allow simaltaneous use of it by staff on our
small office network. However it is becoming more and more obvious to me that
I am going to need to give staff access to this new database from remote
locations (outside of our office network). Two staff members are regularly
overseas, one is mainly on the road with her laptop et...HOw do I do this? #2
I am trying to help my daughter and do a graph of the following data:
12 different times and 12 different temperatures, I am assuming that I
should do 2 seperate line graphs, but how do I overlay or combine the times
with teh temps?
Any ideas and or alterations to my thinking appreciated!
You probably want an "XY Scatter Chart"
On Step two of the wizard select the Series Tab at the top.
Then you can add data for the X axis and the Y axis.
Kim K wrote:
> I am trying to help my daughter and do a graph of the following data:
> 12 different times and 12...CRM Professional Edition 1.2
I received this product with my MAPS. Can I install it on a Windows SBS 2003
yes - be sure to read/follow the implementation guide (on the documentation
CD) - there's a complete chapter on installing into SBS2003 - Also - there
is an update of that chapter on the Microsoft support download site. -
"jc" <firstname.lastname@example.org> wrote in message
>I received this product with my MAPS. Can I install it on a Windows SBS
Yes, I found out how. There is an update to BCM t...converting publisher documents #2
I have designed some product labels in Publisher but the print company
cannot read it. Can I convert it to Photoshop? Or can I convert it to another
format suitable for a commercial printer.
I deal with a commerical printer who can handle Publisher files. Beside
that, convert the file to a .pdf and give that to your printer.
Microsoft MVP - Publisher
"judi-m" <email@example.com> wrote in message
> I have designed some product labels in Publisher but...OL2000 removed from Outbox
One account in my office, when sending email messages
that DO NOT get delivered due to a communication problem,
recieves a message in the Inbox rather than having the
message remain in his Outbox. The failed message is
moved to the Sent box, even though it was not delivered.
I can't find a setting for how Outlook hadles these.
...Folders appear as XML? in Outlook Web Access
Some of our users have been having trouble accessing their e-mail
through OWA (Exchange2000/Windows 2000 server, various browsers).
In the Outlook client the folders, subfolders and messages appear
normal. When they access their mail using OWA the inbox appears fine
but when they select another folder in folder view the message pane
displays what appears to be XML code. It makes it impossible to view
the subfolders or messages. I have tried the direct URL to the
subfolders/messages with the same result; a window full of garbage.
If I use Outlook to create new folders and drag the mes...