Creating a Macro to Compact all .pst files
Can someone point me to an example of a macro that would:
Go through all open .pst files (I have about 20 pst files)
Empty the trash in each .pst file
Compact each .pst file
I'm using Outlook XP on Windows XP Pro SP1.
Outlook XP allegedly compacts automagically, though I have yet to
observe it doing so.
In any case, help on writing such a macro would be appreciated.
Thanks in advance.
Compacting a PST file is not something you can control from code.
[MVP - Outlook]
Author: Absolute Beginners Guide to Microsoft Office Outlook 2003
Reminder ...copy and overwrite ??? -can't get rid og duplicate messages !!!
Hey you wise people !
HOW can I make Outlook overwrite identical messages when copying a large
amount of messages from one folder to another.
I have 2 folders that are not 100% the same and would like to merge theese
into one -without getting duplicate messages.
It would seem to me that this should be a BASIC thing to do (like when you
copy between folders in Windows, it always asks you if you want to
overwrite...) but Outlook just copies everything without asking and i end up
having 100'dreds of duplicate messages.
I'm frustrated........- please help.
...Exchange 5.5 message size limit...Still to this day haven't been given a straight answer
Exchange 5.5 service pack 4, running on NT 4.0 server, all lastest SPs.
I get complaints often when outsiders try to email my users a large
NONE of my mailboxes have limits on them. I think I heard the true
limit was 2.6 megs...
Just to test it, I sent myself from my personal email accout to my work
account, a 1.06meg file. It got through.
Then I tried to sent myself a 3.5 meg file. It did not get through.
Are there some bases I am not covering?
Thans in advance!
did you check the ims settings?
> My setup:
> Exchan...Copy and paste within a macro
I've created macro to copy the value of one field and I want it to paste this
value into another field. However, it's pasting in the value that's stored
in the macro. I tried deleting the TypeTo line after the cmdEditPaste line
but now nothing gets pasted.
How do I get it to paste in what gets copied each time (from the clipboard)?
Try doing an 'Edit Select All' first and then a 'Copy' and then an 'Edit
Select All' and then 'Paste'. Remove the TypeTo after the paste.
For instance, on the GL trx entry window if you wanted t...error message 12-03-09
Every time I try to open a url from an email message, I get an error message
telling me that window can not open it. But if I click off the error message
and try to open the url again, it will open. Any body know why?? Thanks
Actually the error message states that "Windows can not find the URL."
> Every time I try to open a url from an email message, I get an error message
> telling me that window can not open it. But if I click off the error message
> and try to open the url again, it will open. Any body know why?? ...browser-view instead of message preview
I can't get the list of messages and de preview-pane in outlook 2003.
I get a browser window (google) instead. Pressing inbox / outbox ... gets me
the right view for about half a second. Then the browser-view re-appears.
Any suggestion ?
...Outlook shows all messages as "attachment"
I have an problem, that Outlook Express shows all the messages as
attachement. Nothing else on preview panel, but "ATT00013.TXT" type
attachements. Even if the email is surely text-only, this happens.
I've got no idea, how to fix this. Anyone got any ideas?
...Error message consistently shows and shuts down entourage
Operating System: Mac OS X 10.6 (Snow Leopard)
Email Client: Exchange
I get the following error message when I open entourage and then entourage closes itself down: Microsoft Sync Services has encountered a problem and needs to close. We are sorry for the inconvenience." Clicking the "More Information" button gives me the information I'll paste in at the end of this email. Please help me -- I googled the error but the answers were too techy for me to figure out. Right now I can't read/send emails or schedule meetings. Than...Cannot find macro
I was alerted when I was opening an excel sheet that there were macros. The
file was originally created by another person. However, when I went in and
tried to delete them, I did not see any macro listed. Where can I find these
New users wrote:
> I was alerted when I was opening an excel sheet that there were macros. The
> file was originally created by another person. However, when I went in and
> tried to delete them, I did not see any macro listed. Where can I find these
See the messages with subject, macro warning. They solved this problem
fo...how to alter the date within a macro
I was trying to create an archive function on a workbook.
I have a formula throughout the workbook that is based on
the current date using NOW(). I went in a recorded a
macro of replacing the NOW() with last years date. How
can I set this so that I can have the user push a button
to archive the sheet and have the year based on the
current date? I want to change the replacement to an
argument that gives the year -1 at the time of clicking
the archive button. The current recorded code follows.
Cells.Replace What:="NOW()", Replacement:="Date
(...automation, macros ...
I'm ok with xcel macros and vba and would like to jump into outlook
automation (fill in the greetings based on address, fill in
signature ...) Where is the 101 stuff? Where's a good place to see
examples? A good FAQ. Thank you.
You might start at http://www.outlookcode.com/article.aspx?ID=40
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
> I'm ok with xcel macros and vba and would like to jump into outlook
> au...Publisher 2000 Error Message when saving work
I have been using this program to publish a club newsletter for approz 1
year. Starting tonight the program will no longer let me save my changes to
a file - and gives an error message. I have tried reloading and restarting
the program. Have also used the command under Help to repair the file.
Nothing is working. Any suggestions? I appreciate the help!
Are you using the same Newsletter over and over? Bad idea...
What is the exact error?
How to troubleshoot a damaged publication in Publisher
Mary Sauer MSFT MVP
h...Blank Message Body in OWA
After bringing the patches up to date on our Exchange Server, we are seeing
blank message bodies when viewed with OWA. The text only appears when you do
a Reply or Forward on the message.
Running on NT4 SP6, Exchange 5.5 SP4
Have looked at KB314532 but problem still persists.
...Display a new notofication message when new email arrives
Hello the "display new notofication messasge when new email arrives" option
does not work on clients computer.
OS Win XP SP1
Outlook 2002 SP2
Both are English versions.
...how do I disable the EULA message each time an Office app opens
Each time I open an office app,ie WORD, Excel; the EULA message to Accept or
Decline appears and needs to be answered before the app opens. How does one
stop this from coming up each time?
..."Delivery Status Notification (Relay)" messages
When sending mails to external recipients I forward all SMTP mails via an
SMTP connector to a smart host.
When a user sets "delivery receipt requested" in Outlook and sends a mail to
an not existing external recipient (e.g. domain does not exist) the Exchange
bridgehead server sends a "Delivery Status Notification (Relay)" message to
the user. In the same second our SMTP smart hosts sends an NDR e.g. that the
domain does not exist.
Is there any way to tell Exchange not to send a Relay delivery status
notficiation when sending mails via smart host to e...Outlook Macro using SendKeys in OL2007...
We have a macro that worked great until installed with OL2007. It sends
some keys to a custom form to check a few checkboxes, etc. We did add it to
the toolbar so we could click it, but it doesn't send the keys any longer.
Partition Boot Manager and Large Drive Tools utilities!
SendKeys is never a good programming solution. In this case, the =
keystrokes are probably different. But you really you should be setting =
property values using the Outlook object model instead.=20
FYI, there is a newsgroup specifically for gene...Exchange 2003 Message Tracking #2
When I go into the message tracking center and select the exchange server
name of the server that has the mailbox that i'm trying to track message for,
it renames itself to another exchange server name. Message tracking is
enabled on the Exchange server that I want to search. The logs are in place.
The servername.log share is in place and the permissions are correct. The
server that I am trying to track is a cluster, that is the only thing that I
can think of. I seem to recall having tracked messages in the past and can't
think of anything that has changed. I've tried ..."Too many fields defined" error message
I received a "Too many fields defined" error message when
importing an Excel 97 spreadsheet into SQL Server 2000.
There are 256 columns in the Excel 97 spreadsheet, all
containing data. How do I correct this in Excel 97?
It's a bug. There's a bit of information in the following MSKB article:
BUG: Cannot Import Excel 97 Spreadsheet with 256 or More Columns
> I received a "Too many fields defined" error message when
> importing an Excel 97 spreadsheet into SQL Server 2000.
> There ...can't delete messages #4
When I try to delete a message in the inbox I get a
message 'The meswsaging interface returned an unknown
message. If problem persists restart outlook'. Restarting
dooes not solve the problem. I also reinstalled outlook
over the existing program without success.
Peter Z <email@example.com> wrote:
> When I try to delete a message in the inbox I get a
> message 'The meswsaging interface returned an unknown
> message. If problem persists restart outlook'. Restarting
> dooes not solve the problem. I also reinstalled outlook
>...I dont want to erase my messages on the server
I want to keep a copy of all my messages on the server and when I delete them
from my windows mail it dissapears from my gmail account, how can I change
Tools | Accounts | Mail | Properties | Advanced - Check: Leave a copy of
messages on the server.
Imperial Beach, CA
"AlexMV" <AlexMV@discussions.microsoft.com> wrote in message
>I want to keep a copy of all my messages on the server and when I delete
> from my windows ma...wildcard in filenames in macro
Excel 3007. I have a n application where I have several workbooks open at the
same time all controled from a "Main Menu" workbook.
The filenames are standard and always the same excepting for the first
character which varies. I am trying to write a macro's to 1) switch between
the windows and 2) to close the files when closing the Main Menu workbook.
Is there a way to reference the files within the macro no matter what the
first character may be in each case?
Any help or suggestion is greatly appreciated.
OK, OK!! Should be 2007!
> E...How to -> Start Excel from command line and run a macro
I have an Excel spreadsheet with a macro. What I want to do is to be able to
start this spreadsheet via a BAT file(mainly to schedule the running). But
the kicker is to run the Macro. I realize I may have to disable the security
to get passed the ENABLE/DISABLE prompt..or is there another way to handle
I have gotten close by getting EXCEL to load my spreadsheet but I am stuck
on the "right way" to handle the prompt and autostart the macro.
Any help will be appreciated.
Assuming that you have Microsoft Excel 2003, this might help:
Assistance > E...Can't change New Message Window Size
I have Windows Live Mail set to reduce the overall size. I did have New
Message reduced so it doesn't take up the whole screen. Somehow that got
changed and now it fills the whole page and decreasing the New Message window
box does nothing.
> Somehow that got changed and now it fills the whole page and decreasing
> the New Message window box does nothing.
Annoying isn't it? I always try to keep one spare open in case that
happens. Then all I need to do is close the problem window, close the
spare, and hope that the next window which opens will be in the..."Get/Change" Error message Safe Pay
We recently completed upgrading a customer from version 8 to version 10. We
get the following error message when we reload transactions in safe pay. "A
get/change first operation on table "ME_Void_Checks" failed accessing SQL
Any help appreciated.