Use of Pop3 accounts for external email
We've been using a pop3/smtp account to recieve our external email. I've
heard that using those is a bad idea for a buisness.
I don't understand it that much and wondering what are the issues with pop3
and what is an alternative to recieve external mail if not using a pop3
We have Exchange 2003.
The issue is the company can't archive all user's mail. You know, company's
email is representing the company, so the company should keep it as archives.
With POP3 email will be moved from server to the client. Instead, you can
use IMAP, Exchange Server, or ...defining accounts receivable default accounts
We would like the ability to have limitations on the accounts that can be
selected for accounts receviable for a sales order transaction or receivable
transaction. Currently you can select any account number for the RECEV trx
type. We would like to define allowable accounts receivable accounts to
avoid our current out of balance condition. This would limit the
possibilities of reasons for ar trade to be out of balance to gl. This is a
very hot issue at many clients in trying to reconcile ar to gl. This could
also apply to AP!!
This post is a sug...Changing to Combination-chart from existing chart
I have made a Line-chart containing 8 different series. I
now want to change 2 of the series to Bars, but in the
How do I proceed to pick the wanted series and transform
them to bars?
Right click a line series that you wish to change. From the popup menu
select Chart type and pick bar.
> I have made a Line-chart containing 8 different series. I
> now want to change 2 of the series to Bars, but in the
> same chart.
> How do I proceed to pick the wanted series and transform
> them to bars?
> Reg...What GL Account does the Adjust Cost Process affect?
We did an Adjust Cost for an Item. In a Journal Entry, a Debit is charged to
the Inventory account but on the Credit side the Account is blank. What
account should it be used for the Credit side? FYI: We don't have (use)
Inventory Offset account.
Thank for your help.
It's using precisely the one you are not using: Inventory Offset.
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
> We did an Adjust Cost for an Item. In a Journal Entry, a Debit is charged to
> the Inventor...EzPaste-xl2ppt Excel add-in, automating the copy/paste of charts and data
This is to notify about the release of EzPaste (http://
www.EzPaste.net), an Excel add-in intended to completely automate the
transfer of charts and data from Excel to PowerPoint.
EzPaste identifies automatically all the charts and the tables defined
in the active workbook. The user then selects which of them he wants
to paste to PowerPoint=AE , and EzPaste does all the work, would you
have to paste one or one hundred tables/charts at once
Even if you have to paste the selected range or chart, EzPaste does it
with the click of a button
Sorry if this message is a bit advertising, b...Static Chart Data Range
Excel-2007, simple line chart:
I have a chart that displays several columns of data for rows 2:84. Whenever
I insert a new row #2, the new data range for the chart is now 3:85. How do I
keep a static data range for my chart (2:84) whenever I insert new rows into
I have tried editing $A$2:$E$84 to A2:E84 and then saving the changes ...
but it is an excercise in futility, it always reverts back to $A$2:$E$84.
I would recommend creating a blank row 2, and hiding it. Then, when you
insert a new row, you'll be inserting within the boundaries, instead of
moving ...Trying to set up account, geting nowhere FAST!
From: "Lenora" <firstname.lastname@example.org>
Subject: Understanding what Microsoft Communities
Date: Friday, September 14, 2007 5:41 PM
Hello out there!
What is Microsoft Communities all about? Is it something that comes with no
charge when you get Microsoft Vista? This is the 4th computer I've had
(besides ones at work). First a Compaq that I loaded everything I could
from work, the computer guy gave me stuff...did work at home, brought it
back to work, and visa versa.
Second was a re-built computer that was given to me by a man in the town we
had moved to...out of the g...Need help grouping charts
I have identical charts which occur on multiple sheets. Is there any wa
to group them for editing?
When I group the sheets themselves, it seems to deactivate the charts
I tried doing it with a macro as an alternative and then flipping th
sheets one by one and keying the macro, but I get a message box with:
"Run-time error 1004", "Unable to get the ChartObjects property of th
Does anyone have any ideas
Izzy's Profile: http://www.excelforum.com/member.php?action=getin...Chart to show Portfolio Value over time?
I'm using Money 2003.
I would like to be able to see the $ value I have in my
portfolio over time. So that I can weep.
Money does have a chart view that allows you to see the
PRICE history for a given stock over time - but not the
dollar value of your investment in the stock over time.
In fact, I can't seem to find a view at all that shows you
the net value of your portfolio/individual stocks changing
The best I've been able to do is to use the "Net Worth"
report and unselect all the other accounts. This has
insufficient granularity (months instea...viewing a user's email account
I have been charged with reviewing a user's email activity / mailbox for a
possible impropriety. Is there a way to do this from exchange, or better yet
what is the best way to accomplish this steathfuly?
On Mon, 23 Oct 2006 18:20:02 -0700, Rossel1
>I have been charged with reviewing a user's email activity / mailbox for a
>possible impropriety. Is there a way to do this from exchange, or better yet
>what is the best way to accomplish this steathfuly?
I really hope that the users' employment contract provides for this
...Multiple accounts #3
I have 2 Hotmail and 1 MSN accounts set up in Outlook
2002. It shows that it sends and receives all 3 accounts
successfully, but when I go to the Inbox of the Hotmail
accounts, there aren't any messages.
It says it send and received fine, but problems occur when you set up more than one HTTP account, so it is recommended that you only use one per profile
...Data labels for Excel 2007 Charts
I have charts that are based on dynamically populated data. I need the
data labels for all of these charts to appear with 0 decimal places.
The dynamic data populates with 2 decimal places (X.XX). Is there a
universal setting I can apply to the worksheet or even the chart
itself, so I do not have to go to each data point/data label and set
the formatting to 0 decimal places?
...change exist chart to be dynamic
How can I change an existing chart to be dynamic? In series I saw a name
in y axis only but no name of x axis. How can I create a series for x axis?
Thanks in advance
You need to understand how dynamic charts work. There are tutorials and
links to more on this page:
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
"Daniel" <Daniel@discussions.microsoft.com> wrote in message
news:FF77A61A-58A9-4629-90E1-20742E6...modify description field in reports
When I print my PO's I can make the part # field in the view report screen
wider but when i print it, it defaults back to the regular size. The
problem is it cuts off my part numbers on some of my long numbers. Is there
a way to overcome this?
you must modify the po.xml file directly.
<email@example.com> wrote in message
> When I print my PO's I can make the part # field in the view report screen
> wider but when i print it, it defaults ...Interactive Chart Examples
I once was given an Excel file (protected of course - D'Oh!!!) where the
person had charts that were interactive.
There were various series and you scrolled thru a scroll bar to select the
series you wanted. It would change the chart as you
Can anybody point to samples that folks have done to do this. Previous
posts have given a few links but I
was hoping that someone has an example That I could use so I do not have to
develop one from scratch.
Homer J. Simpson
Have a look at these examples,
Series and data
http://peltiertech.com/Excel/Charts/Dynamics.h...Renaming Accounts in CRM
We are trying to change the account name in CRM, In the Account Name
field when we chnage it, it goes through all cases and makes the owner
of the case the person that changes the account name. Is there a way
to have it not go back through all of the cases ?
What you describe is not CRM functionality. Either you didn't describe it
correctly, or there is some custom process performing the unwanted action
I think you may mean when an account owner is changed, all the account's
cases ownership also changes. Now that really is a pain!!
"Rcw01" <firstname.lastname@example.org> w...Accounting prediction tool for wages with excel?
I have a series of employees (with different payrolls) and a series of
accounts (with money coming in and going out during the year). I
would like to develop a tool where I can assign employees over certain
periods on specific accounts, to forecast the evolution of the
- Mr. X is paid from January to April from account A and from May to
December from account B, his monthly wage is xx.
- Mrs. Y is paid from January to June from account A and from July to
December from account C, her monthly wage is yy.
- Mr. Z is paid from January to August fro...How do I get a chart to display backwards/forwards?
I have stock data. Row 35 is the nearest day. Row 36 is the next day, etc.
When I chart the data using a 2 axes chart (custom), the chart doesn't
display backwards. The nearest day displays on the left side of the chart,
not the right. How do I change that?
Double click on the axis, select the scale tab, and check "Values in
> I have stock data. Row 35 is the nearest day. Row 36 is the next day, etc.
> When I chart the data using a 2 axes chart (custom), the chart doesn't
> display backwards. The nearest day displays on the ...Outlook 2003 account problems.
There are 2 active accounts in this Outlook 2003 setup.
1. Connects to an internal Exchange 5.5 server - this server does not have
internet access and is only used for internal email between employees (set
as Default account in Outlook)
2. Internet email account hosted by an outside vendor.
Here's the problem. When you create a new message and use a combination of
email address that points to an internet email (Ex. email@example.com) and
addresses from the global address list (firstname.lastname@example.org), then select to
use the internal Exchange account to send it, everything works fine. But if
the ...using domain account for Exch2003 services
In Chapter 3 of the MS Press Training Kit "Implementing and Managing
Microsoft Exchange Server 2003", there are instructions for changing the
Exchange Services to run under a domain account (with appropriate group
memberships and rights) rather than the default Local System account for
security & auditing purposes.
However, I could not start the services after making the change and reviewed
several articles stating that only the Local System account will work - KB
Articles 271920, 239762, etc.
Is the training kit wrong, or is there a way to do this?
thanks in advance,
...Display various currencies in Account listings
Anyone have a solution that makes sense, I would liek to
simply list the correct currencies according to the
Accounts. Example: I use a Foriegn Bank, the local
currency is Euros, I also use my Home Bank which uses
Dollars. When I do a listing of the Accounts, I get a
display of all amounts in Dollars or Euros and would like
to see both. Working abroad! therefore; it would be nice
to acutally see what is what.
Or should I see Microsoft as on a one track mine set,
that it only happens in America!
if you have any supportive info please let me know.
Thanks in advance
...Pivot Chart Bar Width
Is it possible to stabilize the width of the bars when using a Pivot Chart?
When there is very little data to chart - based on the values I select from page data pull-downs - the bars are really fat. Other times they are thin. I would really like to have a standard width.
The bars are based on a percentage of the spacing between categories.
If you have fewer categories, the bars get wider. If you decreased the
bar width (by increasing gap width on the Other tab of the format series
dialog), they'd be much further apart.
You can't adjust these automatical...SPC Control Charts
Does anyone know if Excel can create SPC control charts?
I can not find them anywhere.
Not as a basic chart type. You can roll your own.
> Does anyone know if Excel can create SPC control charts?
> I can not find them anywhere.
...Time-based floating bar chart
I have a problem similar to "Kaixi".
I have data for elapsed times of backups, and I'm trying
to chart the beginning and ending time of the backups for
each server. The only problem is that each server may
have more than one backup job, so I need to chart the
elapsed time from the earliest start time to the latest
end time, with gaps shown where there is no activity.
The data looks like this:
server start-time end-time
abc 08:00 08:30
abc 08:00 08:45
abc 09:00 09:30
def 09:00 09:10
def 0...Visio 2003 Organizational Chart 2002 Compatibility
This is a multi-part message in MIME format.
I have an organizational chart created in Visio 2003 Professional, and I =
have saved the chart (with synchronized pages) in the 2002 file format.
My problem is that when a Visio 2002 Standard user opens the file, the =
pages are no longer synchronized, nor can the 2002 users expand and =
collapse subordinates. Is this the norm, or what am I doing wrong here?=20