synchiing two computers?
Is there a way to synch Outlook on two computers?
I end up with some email on my laptop and some on my desktop - it would be
nice if the two could be synched so that I could have all of my email on
Take a look here, it may help:
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, Bill Andersen asked:
| Is there a way to synch Outlook on two computers?
| I end up with some...Print W-2 and Reporting of Magnetic Media
Hello all, we have an issue where we have independent contractors and they
have their employee's (we are processing payroll for our contractors).
When we print W-2's it lists us as the employer to their employees. How can
we establish the contractor as the Employer while still maintaining all the
printing of W-2's and reporting with W-2 magnetic media.
anyone ever do this before.. as far as I can tell not really an option...
Just have to generate manual W-2's for each of the independent contractors
"Brian" <firstname.lastname@example.org> wrote in message
news:...Compare two cells in two different files and return answer
I am attempting to compare two text cells and if they both exist, I want to
bring in a "yes" answer. If they don't, bring in a "no" answer. Here's an
example of text.
Col A Col B
Col A Col B
So, what I want to do is say in File 1 take cells A1 and B1 compare them to
File 2 and search Col A and Col B and if there is an exact mat...Print Distribution Details on Miscellaneous Check Print
Anyone know how to print the details of distribution on the Check while
printing the Miscellaneous Check in GP
The check format needs to be modified in Report Writer to add those
East Coast Dynamics
Do you have a solution.
"Frank Hamelly, MCP-GP" wrote:
> The check format needs to be modified in Report Writer to add those
> Frank Hamelly
> MCP-GP, MCT
> East Coast Dynamics
...Pivot table for two different data variables
I have the following table
Name type Cost overhead
amy C1 23 12
bob C2 129 17
cat C2 36 45
doo C2 100 32
I owuld like to create a pivot table that looks similar to:
the standard pivot table. (Please ignore type for now.)
name Data Total
amy Sum of overhead 200
Sum of cost 12
bob Sum of overhead 130
Sum of cost 23
cat Sum of overhead 90
Sum of cost 19
doo Sum of overhead 87
Sum of cost 34
Total Sum of overhead 507
Total Sum of cost 88
But with overall total (overhead + cost) for ...autoshapes on chart print in wrong positions
I have a problem in Excel (2003 v.11.8220.8202) to do with how charts are
printed when they have autoshapes added to them. I have an example file that
I could send through. The shapes - arrows in this case - have been added as
autoshapes on the chart but when you do a print preview or print some of the
arrows move up in relation to the rest of the chart. This ruins the look of
I have tried a number of different printer drivers and adobe distiller
driver but they do not seem to affect the output of the chart.
Try grouping the objects. Click ...COUNTIF (?) on two criteria
I have a spreadsheet that logs work activities and records team
members' completion of project units.
Column B records team member names. Column C has project unit status -
'pending', 'beta' or 'completed'.
It's easy to set up a formula to count how many units are allocated to
each team member - =COUNTIF(B1:B1000,"Joe"). But what I need to do is
set up formulas to count how many units Joe has completed, or has
pending or at beta, and this means assessing data in both columns -
which COUNTIF won't do.
This doesn't strike me as an especially...Server side rules not working after SP2 update
I am running Exchange 2003 Ent SP2 on a Windows 2003 Ent server.
Clients are all Outlook 2003 SP2 on XP Pro SP2
I have many rules created within several User accounts to move incoming
email into public folders. This worked fine until I applied Exchange SP2.
Now all these rules act as if they are client-side and require Outlook to
remain open to function. When I create a new rule to move an incoming email
into a public folder I do not get a pop-up stating this is a client-side
rule. Rules moving email into other folders within a mailbox remain
server-side. Only the rules moving ema...Two IF Statements with two answers
In cell J9 I need a formula that would do the following:
If G9="Yes" then F9, If G9="No" then -f9
Note: G9 has a drop down list with Yes, No answers.
If there are no other alternatives that yes and no
> In cell J9 I need a formula that would do the following:
> If G9="Yes" then F9, If G9="No" then -f9
> Note: G9 has a drop down list with Yes, No answers.
Positioning the Vertical axes:
I have a chart where there are two axes. The first implementation produced
the two scales on the right side, one inside, the other outside the chart
area. Unusual, but luckily it fits well the chart.
I tried to duplicate the feat with another dataset (similar in structure)
and did not even get the second scale to show right, left or center (data
plotted with two different scales allright).
Where is the info to control these functionalities?
On Wed, 29 Oct 2003 17:48:13 +0100, pl.carry <email@example.com> wrote=
> Positioning the Vertic...plot two groups of numbers on one series of xy coordinates.
how to create a plot from separate x and y values. i.e. y values do not
correspond to the same set of x values. example x1= 5, y1=10; x2= 8, y2=15
I can read your question 2 ways;
A) you data looks like this
Select the data and make an XY chart
B) you have two sets of data
Make an XY chart of the first data series
Select all the data (including headers) for second set, and use Copy
Click the chart to activate it
Use Edit | Paste Special .... indicate New Ser...Document not printing as formatted
Documents do not print as formatted.
Saving prior to printing does not help.
Both alignment and font size change when document prints.
Seems to happen when view is changed in view menu, or when selecting
Occurs with existing and new documents.
The changes occur randomly.
OS is Mac 10.3.5
Printer is Epson C84
...Can internet side ISA to internal SSL web sever be proxied with Kerberos Protocol translation to exchange OWA on a different server?
In a Windows 2003 domain. With Exchage 2003 and ISA 2000. Is it possible
to have internet web connection from ISA go to internal IIS web server that
has SSL, then proxy that connection to internal Exchange Server OWA.
In other words use the existing web server's certificate to force
authentication for web client and set up a proxy for web access between web
server and Exchange OWA which is located on a different box then the IIS web
SSL credentials could be passed with Kerberos protocol translation to
This would be for a non-production, small test domain use...Printing Members of Distribution List and Email addresses
We just recently migrated from Exchange 5.5 to Exchange 2003. Is there an
easy way to get a print out of members of a distribution list and their
email address? Used to be a bear in 5.5 so I'm hoping MS made it easier in
Exchange 2003. Thanks for your help.
You'll need to get this information from Active Directory now. I wrote a
small and basic script to do this a few years back which you can find here:
I'm sure you can modify this to suit your needs, or have a trawl around for
more ad...two variables
I have a query that asks for collcode, collcode2 and booth. On any given day
an employee may be collcode or collcode2. I would like to know how many
times a certain emp has been paired with another employee. So how do I ask
if an employee has been collcode/collcode2 and who the other person was? I
hope this question makes sense.
Thanks for any help
SELECT CollCode, CollCode2, Booth
SELECT CollCode2, CollCode, Booth
SELECT CollCode, CollCode2, Count(CollCode) AS TIMESPAIRED
GROUP BY CollCode, CollCode2
IF y...Find two PCI instance but load Init() one time
I'm developing a stream interface driver for my PCI device under WinCE 6.0
and this driver works very well currently. Now, I got a problem when testing
two the same PCI devices with my stream driver.
The registry can find two PCI instances (i.e. PCI\Instance\mydrv1, PCI\
Instance\mydrv2) but system only call my XXX_init() one time. Does anyone
know what the problem is?
The following information is my registry setting:
"Dll"="myd...Postcard printing #2
Is there any way to print 8 standard size postcards on 11x17 paper?
Assuming you want to stay within the 23� stamp size you could do it with a
size of 5"x4" and have an overall margin of �".
First do a Printer setup for 11"x17" card stock.
Create a single work area of 5" width and 4" height.
(You can select the smallest margins of your choice here)
Pour forth your artistic creation of the card.
(The following is for Publisher 2000)
Now to print it (them)
Page options button
Select "Print multiple copies"
Select "C...Format worksheet to view only the print area cells in Excel
Simple I know but have stumped everyone. How do I format a worksheet to view
only the selected print area in the working area. In other words I do not
want to see any other columns or row numbers - just a gray background which
makes the worksheet look like a clean piece of paper or form when you open it
Here's one way to accomplish that effect:
1) Fill all cell outside the print area as grey.
2) Hide the row/column headers.
3) Lock the scroll area of the worksheet to just the print area.
Let me know if you need help with any of these steps.
----------------------...Comparing two lists for matches
I am trying to do the following:
There are two sets of supplier lists - A List and B List. I need to
compare the two lists. Source A is my master. Source B is a subset of
that but has contact information for all the suppliers. Hence, my goal
is to retrieve the contact information from Source B and match it to
the suppliers of Source A.
The above can be easliy achieved using a vlookup funtion. But the
problem is that some of the supplier names in the two lists are not
exact matches. Hence, vlookup does not catch it. For instance, a
supplier is listed as ABC Inc. in A list and as ABC, inc....Compare two lists of names
Can you compare two lists of names where one list is last name first and the
other is first name last?
try this formual:
=RIGHT(TRIM(E2),LEN(E2)-FIND(" ",E2))&" "&TRIM(LEFT(TRIM(E2),FIND(" ",E2)))
it will convert First name last name to last name, first name or Visa versa.
then you can compare your lists.
> Can you compare two lists of names where one list is last name first and the
> other is first name last?
...Two copies of all Mailboxes
Using my sbs2003 srver with exchange 2003 installed - I notice two copies of
all users mail box in the list of mailboxes using outlook 2003 on the same
server. When I try to close these I get an error syaing mail boxes in use. I
cn not remove them. Can you tell me how to remove these so I have just on
mail box visible per user?
...Report-not required to print if field is null-concatenated field q
Please tell me how to configure the field in a report not to print if the
value is null (simple concatenated field in query (ie [age 2] &" "&years
old). The age field is not always entered, so in the report it reads "years
old", which does not look good!
In ControlSource property for field, try
=NZ(ColumnName,[Age] & ' years old','')
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
> Please tell me how to configure the field in a r...How do I create a chart on two axes with two lines and a bar
I am trying to compare two final stock prices to the average volume.
So, teh left axes would have the numbers for the stock prices, and the
right axes would have the volume. The two stock prices would be lines
using the left, and the volume a bar using the right. I can do one line
and one bar, but I can't figure out two lines.
Can anyone help?
Forget the built in custom types. It's better to build your own. Create your
chart using all the data, to produce a chart with three line series all on
the primary axis. Select the Volume series, and on the Chart menu, use Chart
Type to ch...how do I display last two digits of a SSN in a separate column
I am trying to create a formula to take an existing list of 8 or 9 digit
numbers and display the last two numbers in a separate column. Is this
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
> I am trying to create a formula to take an existing list of 8 or 9 digit
> numbers and display the last two numbers in a separate column. Is this
Use a formula
=3Dright(A1, 2...Combining Text and numbers from two cells
i have a cell with a number such as 6000 (a1) and another cell with a
text aaa- and i would like to combine them in another cell to make
aaa-6000, could somebody please help me with a formula?
koba's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28639
View this thread: http://www.excelforum.com/showthread.php?threadid=492631
A1 = 6000
B1 = aaa