How to Use One PST file on Two Computers?
I have a desktop machine with a pst file in my Outlook 2003. I would
like to copy this pst file to my laptop. How do I synchronize the same
file on 2 machines so I won't get duplicate e-mails? I use one premium
Yahoo e-mail account and several free Yahoo accounts with YahooPOPs..
Thanks in advance,
it is not possible by default to share PST files.
A list of a list of third-party synctools are also on this site:
On the Microsoft Office Marketplace site is a list of third-party messaging
http://office.microsoft.com...Let me use the Line Color icon on charts
It would speed up a lot of my work if I could use the Line Color icon on
Excel charts, the same way I am able to use the Fill Color and Font Color
However, when I highlight any chart object, like the Plot Area, Chart Area,
or a Series, the Line Color icon is disabled.
Stuart Bratesman, Jr., MPP
Muskie School of Public Service
Univ. of Southern Maine
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If ...VBA code to say Yes or No if any VBA code is present in ActiveWork
Using XL 2003 & 97
Would like hit Ctrl+Shift+V and have an answer either yes or no as to the
presence of Any VBA code in the Active Workbook.
I do know that about the VBA editor/Explorer or to press the Run Macro
button and get a list from various sources .
I would like to stay at the keyboard and process a series of macros
including one to let me know if I even need to evoke the VBA explorer.
There is no bootstrap macro to tell you whether you have macros
or not. If there were there would be no limit to virus writers.
David McRitchie, Microsoft MVP - Excel ...Query Based Address List using boolean "company1 or company2" possible?
Hello, I'm trying to make a query based address list for multiple
companies so that all those from company1 or those from company2 will
be included in the address list.
I've tried just adding both filters "company is exactly company1" and
then the next of "company is exactly company2" through System
Manager>Recipients>All Address Lists, Right click, click Filter
rules>Advanced Tab... but it yields no results, as it appears it's
and'ing them (if company = company1 and company=company2).
Is there a way I can make a filter to include both companies w...Print, Merged Cells, and VBA
I'm looking for a code that will help me with a print job
for a worksheet. There are a lot of merged cells and a
lot of "IF"s to be used in the VBA for range selection.
Thanks in advance,
...Strange Problem When Using M06
Before I purchased Money 2006 Premium, my home page was My MSN using
Internet Explorer. When ever I opened Internet Explorer, it would
automatically sign me in to My MSN.
Since I have purchased and install M06 Premium, everythime I am finish
using M06, and then open internet explorer, I am required to sign in to
My MSN. This has started when I purchased M06.
Is there a setting in M06 that needs to be set so that I do not have to
sign in to My Msn evertime I am finish using M06?
In microsoft.public.money, Tom wrote:
>Before I purchased Money 2006 Premium, my home page was My MSN...Use VBA to update Access table or Query from Excel
Can I use VBA to update Access table or Query from Excel?
Thanks in advance
> Can I use VBA to update Access table or Query from Excel?
Of course, using ADO or DAO.
Jan Karel Pieterse
Thanks. I think ADO is what I want.
But I am not only want to export from excel to access.
I want to edit some data in access table.
For example, Access has a table "ProductList"
I want to use Excel to call the product by "Pro...Missing DLL file prevents me using PST Files?
Hello - I posted on here a while ago asking for help as following a company
merger I cannot use PST files in Outlook 2000 (Windows NT machine).
I have been told that work have removed a DLL file which is causing this.
Do any of you have experience of this? If so any idea what DLL file I need
to add back in?
Do you mean that the corporate IT removed the DLL so you can't use PSTs? Do
they have a good reason for this?
"Carl Jarvis" <firstname.lastname@example.org> wrote in message
news:email@example.com...Windows 7 Newsgroup
I have tried to find the windows 7 Newsgroup in this list of Newsgroup where
this one on Vista is, but I do not get a hit. Is there one in this group
that I can add to my list and use to ask some questions?
Also, a second question: Windows Vista has a lot of pretty and nice
graphics, and pretty colors, etc, but it is very difficult to find some
thing there when you are lost and the folder systems is extremely
complicated sometimes. I use Vista now, have had it for about two years
now, and I still have difficulty finding the logic of the folder system
sometimes. I don...VBA and Scheduled task in Outlook
Hi, how can I:
a) pull the query from somewhere and send it by e-mail automatically. E.g. I
want to take a temperature table from
where 2009/7/10 is the date of yesterday put it into an e-mail and send it
automatically each day at 8 o'clock?
b) if this is not possible, how can I send an e-mail with the attachment
c:\Documents\query20090710.xls each day at 8 o'clock?
my boss wants this automatized, I know how to write the VBA code for Excel,
but don'...Using CListCtrl #3
Does application get any notification message,
when List Item is losing Selection?
I need to apply some checks and want to prevent
deselection in some cases?
...vba select field
having a button on a form, is it possible to select only some fields
(all from the same table) of the current record instead of all fields?
I've tried this code:
Forse dipende dei dati nel record.
but it selects ALL fields in the form.
On 10.04.2010 18:01, remigio wrote:
> having a button on a form, is it possible to select only some fields
> (all from the same table) of the current record instead of all fields?
> I've tried this code:
> RunCommand acCmdSelectRecord
&...VLOOKUP in VBA
On the worksheet I can insert in a cell
=VLOOKUP(C5, Hobokee.xls!AcsLow, 2)
and it works perfectly, looks up the value in column 2 of the range named
AcsLow in the same workbook.
But elswhere I want in a macro to lookup the same table and assign the
result to a variable BalAmt.
BalAmt = VLOOKUP(AccNum, Hobokee.xls!AcsLow, 2) does not work.
It gives a function not defined error on Hobokee. If instead of Hobokee I
put Workbooks("Hobokee"), it gives function not defined error for VLOOKUP
which it changes to VLookup.
I have been overVLOOKUP in the Help file and see nothing wrong.
W...Anyone receive the email "The Golden Age of Windows 7 Forums"?
That was an editorial piece of work, eh? Long live newsgroups!
Anti-spam measures are included in my email address.
Delete NOSPAM from the email address after clicking Reply.
...How do you use AutoLayout?
I want to make my family tree on excel!
Excel is probably not the right tool for this. There're dedicated
applications available. Just search Google for them :-)
"K" <K@discussions.microsoft.com> schrieb im Newsbeitrag
> I want to make my family tree on excel!
To create a simple chart in Excel, you can use an Organization Chart.
Select Organization Chart, click OK
Click in a box to add a name
To add new boxes, click the Insert Shape butto...Loading a Form from VBA
Hi all, I'd like a module to open and load a form in my Access 2003
database... How can I do this?
Use the OpenForm method. Look in the Help file for details.
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
"Mike" <firstname.lastname@example.org> wrote in message
> Hi all, I'd like a module to open and load a form in my Access 2003
> database... How can I do this?
On Jul 18, 10:58 am, "Douglas J. Steele"
<NOSPAM_djsteele@NOSPAM_canada.com&g...Using stationary when Word is used as the editor
I am having a problem with stationary when using word as the email editor.
What is required is for a logo to be placed as a backgroun image in the top
right hand corner. this works fine in outlook using this code:
background-position: right top;
However when Word is used as the email editor the background image is no
longer placed in the top righ...Excel VBA/Macro programming for beginners
I know a bit VB 6.0 programming. Will it help me to write exce
vba/macro(same thing?).can anybody help me by providing some fre
websites where i can have informations/codes for VBA/macro.
Please tell me how could i make a *command Button * in a cell in th
sdebu_2000's Profile: http://www.officehelp.in/member.php?userid=430
View this thread: http://www.officehelp.in/showthread.php?t=118812
Posted from - http://www.officehelp.i
Try David McRitchie's "getting started with mac...Files Ofiice 2003 using Vista operating system
Where are my pab or pst files in Microsoft Office 2003 when using Micrsoft
Vista Home Premium? Or do they have another name or location
Hondaman95 <Hondaman95@discussions.microsoft.com> wrote:
> Where are my pab or pst files in Microsoft Office 2003 when using
> Micrsoft Vista Home Premium? Or do they have another name or location
The PAB is obsolete and you shouldn't be using one. The PST's default
Brian Tillman [MVP-Outlook]
"Brian Tillman" wrote:
> Hondaman95 <Hondaman95@discussions.microsoft....Turn pc speaker on/off with vba code
Is this possible?
I found something here on how to do it withVBScript. You can probably modify
it to work in VBA
> Is this possible?
I'll have a go
(I need to improve my web searching skills)
"Barb Reinhardt" wrote:
> I found something here on how to do it withVBScript. You can probably modify
> it to work in VBA
> ...importing Netscape 7.1 to Outlook 2003
Is there a way to import mail/address book from Netscape
7.1 to Outlook 2003? Please help if you can.
Tracy <email@example.com> wrote:
> Is there a way to import mail/address book from Netscape
> 7.1 to Outlook 2003? Please help if you can.
Simple? Probably not. You have to transfer your messages from V7 to NS V4
and then use OL to import them from V4. See
http://www.slipstick.com/emo/2004/up040415.htm. I had seen an explicit
description of what to do on a web page somewhere, but I can't find it now.
...Personal Address Book #7
My boss inadvertently deleted his personal address book while cleaning up
some files in his My Documents folder. When he checked for it in the
Recycle bin, it was already gone.
I went to Tools|Services and it showed that it was there, but he couldn't
access it for some reason. So we tried to "Add" it again and it said it
couldn't add it because it was already there. So, I clicked "Remove"
thinking I'll just start over. However, now when I click "Add" there is NOT
an option for "Personal Address Book." How do I get it back?
S. Jacks...Using table valued parameters to delete and update a table
I know how to insert into a table using table parameters, but how do you
delete/update with them?
The same way you would use a regular table to perform delete/update:
MERGE INTO TargetTable AS T
USING @TableValuedParameter AS S
ON T.keycol = S.keycol
THEN UPDATE SET datacol = S.datacol;
WHERE EXISTS(SELECT *
FROM @TableValuedParameter AS T
WHERE T.keycol = TargetTable.keycol);
SET datacol = (SELECT T.datacol
FROM @TableValuedParameter AS T
WHERE T.keyco...remove attachments using exchange server 5.5
in my company we receive our mails over an Exchange Server 5.5.
I would like that all the attachments, with a specified extension (i.e. exe,
com, scr, etc...), will be removed from the e-mails.
Can I do that directly in Exchange or I need a third-party software?
Thanks a lot,
I believe you need a 3rd party software like NAVCE
"Luke" <firstname.lastname@example.org> wrote in message
> in my company we receive our mails over an Exchange Server 5.5.
> I would like that all the a...Do you shut down your Macbook Pro when you are not using it?
Operating System: Mac OS X 10.5 (Leopard)
Or is it better to leave it on for weeks?
This is a question to which there is no definitive answer -- You'll get a
somewhat different response from just about everyone you ask :-)
IMO, there is very little reason for anyone to leave *any* computer powered
on 24/7/365, whether it be a laptop or desktop system. If it isn't going to
be used for several hours -- such as over night -- shut it down. At the
least, shut down/restart once or twice per week.
Modern operating systems do a certain amount of ...