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 <email@example.com> 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
&...Multiple copies of email in "Forward to"contact
I am running Exchnage 2003. My CEO has a conatct in our organisation that
refer to his blackberry contact. I have set the forwarding to also keep a
copy in his mailbox.
What happens is that three copies of his forwarded email hit his blackberry
account! Only one hits his internal mailbox.
What I ahve determined is that the front end Exchange server seems to be
creating the additional copies. Is this how its meant to be (don think so cos
its such a nuisance and my CEO keeps complaining about it).
How do I tell the front end server that this guy's mail server is the one
that...Fractions Number format
Is it possible to do a custom number format for cells such that fractions
are displayed. I'm guessing not because there'd be a limit on what fractions
you could display, but I would probably only be interested in showing a half
as the little 1/2 (alt,0189 I think) rather than .5
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.478 / Virus Database: 275 - Release Date: 06/05/03
There are a limited number of fractions that can be shown under
Gord Dibben Excel MVP - XL97 SR2 & ...printing multiple copies of Sigel GmbH
I have made a tent card in a small size of 5.588cm x 4.191cm for a swing tag,
using Sigel GmbH in the "other labels" section. It prints one copy
perfectly, leaving room on the page for at least about another 5 copies
(which is what I want), but when in the print page section it doesn't give me
the option to print multiple copies on the page. This will be an enormous
waste of paper if I have to print the number of copies individually on each
What is the product number for this label? I cannot find this size label on my
Mary Sau...Copying Data in a cell in one sheet to a cell in another sheet
I've run into a problem trying to copy data from a cell
in one sheet to another. I have a spreadsheet
called "rating" which contains a number of formula that
calculates a final number. I also have a spreadsheet
called "Final" that copies over the information
from "Rating". In "Final", I'm trying to copy a number
from "Rating" into a particular cell. I put in =Rating!
G89, but it won't work. When I press enter, a window
pops up "Update value:Rating". I press enter again and
in the cell where I want the number ...Copying dbx files from a CDR back into Outlook
My computer was recently hijakced and I had to reinstall
everything. I did however save all of my folders in
Outlook onto a CD Rom and I do not know how to transfer
them back so I can use them. Also I had an animated
version of outlook where you could choose loads of
diffent stationery and I cannot seem to find that upgrade
Can you help me?
Tee <firstname.lastname@example.org> wrote:
> My computer was recently hijakced and I had to reinstall
> everything. I did however save all of my folders in
> Outlook onto a CD Rom and I do not know how to transfer
> them back so...Some Excel formatting functions taking a long time to work #2
Excel 2000 SP3
When I use some formatting functions for the first time in a
session, such as bold, increasing font size etc, it takes up to 30
seconds to work. Meantime Excel is locked up until it completes that
formatting call. I suspect faulty DLL?
Has anyone experienced this? How to fix (other than a complete re-
Any advice appreciated.
On Nov 5, 8:39=A0am, Piri <wiremu.pare...@hotmail.com> wrote:
> Excel 2000 SP3
> When I use some formatting functions for the first time in a
> session, such as bold, increasing font size etc, it takes =A0up to 30
> secon...VBA to put a copy of worksheet on the desktop 05-13-10
In my workbook XYZ I have a sheet ABC. With a button on sheet DEF I can
refresh sheet ABC. When the code finishes it job I want to add the actual
date (short European notation dmyy) and time (f.i. 241110 16.31) to the name
of the sheet (which becomes ABC 241110 16.31) and after that make a copy of
that sheet in a separate workbook and put that workbook as an icon on the
desktop of my computer. Is this possible? If so, please help me with the
necessary code. Thanks in advance for your assistance.
...how to make macro work even a sheet is hidden.
I have macro assigned to a button in Sheet 1 which goes to sheet 2.
Press a button to Refresh and then PRINT preview
It does work in normal state.
I do not want the user to see the Sheet 2. I hid sheets from
but the macro is not working when sheet 2 is hidden.
how to overcome this error
"can't execute code in break mode"
the macro code is
Application.Run "'Latest 2009Payslip.xls'!Sheet2.HURows"
...How to save Japanese characters in CSV format of Excel ?
I would like to know, how to save the Doubly-Byte characters.For example,
Japanese in CSV of Excel.Here are the steps, I tried.
1. Open Excel
2. Copy pasted the Japanese charactesrs in a cell.It is displaying the
3. Save as CSV(Comma seperated file)
It is saving as ??????.
Thanks in advance for the info.
...Can i use conditional formating on a cell when it contains a formula?
I am trying a "conditional formatting" on a cell that contains
formula, but it didn't work.
"If cell value is equal to 0 then font - white" This doesn't work,
If i use this condition on a cell without formula it works just fine.
sit's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=262
View this thread: http://www.excelforum.com/showthread.php?threadid=26784
are you sure your formula returns an exact zero?. Could you post the
formul...Date format 04-11-06
Is there a possibility that the dates used in all the entities are not in
the default format mm/dd/yyyy but in dd/mm/yyyy.
I already adapted the Organisatonal settings, that only adapts the journal
but nog the dates of an appointment.
Does anyone have an idea?
...Boot Ini Problem
I am getting the following error message:
Invalid Boot Ini Booting from C:/Windows
So I research this problem and create a new Boot Ini file and when I reboot
I still get this error.
I have not attempted yet to do a repair using my XP media, is this what I
need to do to fix this problem? Or is there a less painful way to fix this?
Maybe this will help. You will be interested mainly in the Bootcfg
"AIANDAS" <AIANDAS@discussions.microsoft.com> wrote in message
news:9E04022F-4DC2-...copy chart from Excel to Powerpoint
I am trying to copy a chart from Excel to Powerpoint, but the button is
grayed out and it won't let me copy it.
You can convert the chart to a GIF (a picture) with my Excel Objects converter.
> I am trying to copy a chart from Excel to Powerpoint, but the button is
> grayed out and it won't let me copy it.
...Help! charts disappearing, new charts crashing powerpoint
When i open a presentation the charts vanish...i have restarted, they come
back. I try to edit a chart, and it crashes powerpoint after a few clicks.
What can I do...whole afternoon going crazy!
If you are using v 2007 there is a hotfix which is meant to cure some chart
john ATSIGN PPTAlchemy.co.uk
Free PPT Hints, Tips and Tutorials
> When i open a pres...Copy and close code
I have a worksheet which uses an indirect formula to search through a series
of files/sheets based on an address to return a value from cell AE20. Once
the data has been copied for all the previous days I would like a copy/paste
values to occur to replace any of the values returned by the formula. In
AU10:AU381 there is a 1 or 0 for each row. 1 meaning that a copy/pastevalues
can be performed (decided by if the date is < today), and zero if i need to
keep the formulas.
Is it possible to have a copy/paste values code for only sheets 2-4 which
works when the file is...IM Add New Batch
GP 10 on 2003 Terminal Server.
How do you create a Payables Batch in the IM in preparation for importing to
the Payables Transaction destination? Alternatively, how must GP be set up to
ensure that the “Add New Batch” rule works correctly?
With the Add New Batch rule set the IM crashes (see my post Integration
Manager 10 Crashes). Additionally the characteristics of the Add New Batch
rule do not match the required information which I understand to be Origin
and Checkbook ID.
I figured there might be some default settings for Origin and Checkbook ID
in the setup somewhere but was not a...copy values generated by conditional formula in one sheet to the other work sheet as values
I have data generated by conditional formulae in work sheet1 in
columns A to J. If the condition is satisfied the cell will display a
realnumber, if the condition doesn't satisfied the cell will display
Now I wanted to copy the cells which have the real numbers in
sheet1 to sheet2 as values(as we do with paste special and paste the
values) Do we have any formula or other method to copy the cells in
sheet1 to sheet2. can anybody helpme out in this issue.
Thanks and Regards
Select your range to copy
edit|goto|special|c...Formatting in CSV
I create a Comma Separated Value file (csv) from my VB application,
then open that file with Excel.
Excel recognises the commas, and splits the records into separate
fields as expected. Can I set properties for rows or columns or cells ?
Like bolding, or font size, etc.
RobertLees's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26580
View this thread: http://www.excelforum.com/showthread.php?threadid=486488
Even though the .csv file contains no fo...Format List Box!
Can I format a list box which has a query,so if one of the fields called
[Spelling] had the word "Spelling" it will change the colour of the font for
Thanks for any help....Bob
It's not possible with the native Access ListBox control. Instead, setup a
Subform control to resemble a ListBox and use ConditionalFormatting to
achieve the desired look. I think Arvin has a sample on his site here:
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can ben...How can I sum only amounts that are in BOLD format within a column
I need to get a total from a worksheet that has hundreds of amounts in it.
However, I only need the total of the amounts that were marked with have BOLD
font. Please help me I don't have much experience with EXCEL.
Thank you very much!
W a n d a
try this for column D
x = Cells(Rows.Count, "d").End(xlUp).Row
For Each c In Range(Cells(2, 4), Cells(x, 4))
If c.Font.Bold Then mysum = mysum + c
"Wanda" <Wanda@discussions.microsoft.com> wrote in message
news:89A268A6-...Exchange 2007 CCR after reseeding storage group copies
We have an Exchange 2007 CCR cluster that sits on two Windows Server
2008 Enterprise nodes. Due to problems with one node, I evicted it
from the cluster and rebuilt it, reinstalling Exchange using the
custom / install passive node setup. I used 'Update Storage Group
Copy' (with the option selected to 'Delete any existing log files in
the target path') to reseed the active databses. It seemed to go OK,
and the storage groups status in the Database Management window became
'healthy'. However, when I tried to move the clustered mailbox server
on to the new node f...Moving exchange 5.5 to a new server exchange 2003
Good day all... how do I move exchange 5.5 to a brand new
exchange server 2003. The new server will be in a new
organization. Any info would be greatly appreciated.
Microsoft MVP - Terminal Server
>Good day all... how do I move exchange 5.5 to a brand new
>exchange server 2003. The new server will be in a new
>organization. Any info would be greatly appreciated.
...open outlook new email form from a crm form
It would be great to be able to open a New Email form (outlook form) by
pressing a button on the Contact, Account or Opportunity etc. form in CRM.
Customers like to use outlook for email and currently there is a disconnect
in that if you are on the opportunity screen and you would like to email the
Potential Customer (and have regarding on the email linked to the Opprotunty)
you have to leave the screen and start a new email in Outlook and lookup the
opportuninty you already have open again to populate the regarding if you
want to use Outlook. You could use Email button, but browser ema...Named range using conditional formatting
I have a named cell called Econvert which contains the conversion rate
from Dollars to Euros. I am creating a template for others to use and
I need to add a conditional format for when users forget to divide
their inputs by the Econvert.
For example, if they enter a salary number as $40,000 I want them to
divide this number by Econvert so that the end result is
=$40,000/Econvert. I would like the cell to become red if they forget
to divide by Econvert which is why I think that conditional formatting
Any ideas? Thanks in advance.
You could create a UDF and use that in the ...