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...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...Help with a Monthly Report Design and Layout
I have a bit of a challenge in front of me with a requested monthly report
that will translate a list of departments that have not approved their
monthly numbers in our databases.
SELECT tblMonthlyData.DEPTCODE, tblMonthlyData.FACILITY, tblMonthlyData.Month
GROUP BY tblMonthlyData.DEPTCODE, tblMonthlyData.FACILITY,
ORDER BY tblMonthlyData.DEPTCODE, tblMonthlyData.Month DESC;
Generates a list of departments witho...Historical aged trial balance #6
Hi can anyone tell me the store procedure used to extract a Report
Reports-Sales-Trial Balance-Historical aged trial balance
Because the management want that report to be in Excel format
you can extract the report to excel format however u'll not get it in
a readible format. You need to some formating. To extract the report,
print the report to file and select tab delimited. This will give u in
excel format. You can write a small macro and sort the things out to
make it readible.
On Jun 22, 9:04=A0am, Thirumal <Thiru...@discussions.microsoft.co...Outlook keeps asking for password
Server is SBS 2008 with SP2.
Clients running Vista SP2.
In the last couple of days (possibly after server updates were applied, but
not sure) every time users open Outlook they get a dialog asking for a
password. If the user enters their correct password the dialog just comes
straight back again.
On looking at the password request box, I notice it is quoting the external
remote domain name "remote.accordconsultancy.co.uk" not the internal network
name "accordserver.accordconsultancy.local". Can anyone explain what I need
to do to stop this annoying ...Trying to set up account, geting nowhere FAST!
From: "Lenora" <email@example.com>
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...Microsoft Excel Help
Why are they called arguments when creating an Excel
function? i need to no for a Excel test! what makes them
if you mean the 'parameteres' of a function how would you call them
"martz" <firstname.lastname@example.org> schrieb im Newsbeitrag
> Why are they called arguments when creating an Excel
> function? i need to no for a Excel test! what makes them
...Help with Now()
I am creating a spreadsheet and I need to have a cell and that record
the date and time each row is entered seperately.
The problem I have at the moment is whenever I add a new row of data i
updates the previous rows time?
does any one have any suggestions on how to stop this happening?
sydolly's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2712
View this thread: http://www.excelforum.com/showthread.php?threadid=46697
Now() is a volatile function and will change ev...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...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
...Help with Raw Stock Data Collection
Is it possible to have Excel search through 1 minute raw data and be
able to determine if the price moves between a certain boundary for a
certain time then it will be classified as "Type 1". And if it is
increasing for a certain time then it will be "Type 2" and likewise
for when it is decreasing.
I want Excel to be able to automatically search through the raw data
and determine what is the type of state without myself having to
manually pinpoint it on the chart then going back and doing a manual
search and calculation in Excel. Only issue is that the exact number
determi...DB Mail is is not working. Need help please.
I have try stop and start the db mail by executing the SPs below but no luck.
Does anyone has seem the error below and how to fix it.
Thanks in advance for your advise/help.
EXECute sysmail_help_queue_sp @queue_type = 'Mail';
queue_type length state
I just wrote a check to the IRS, and in the Expense Catagory I indicated
"Taxes : Federal Income Tax". Yet in the Income/Expense report, this
payment is not included in my total federal taxes paid for this month. I
should note that the check was written from an Investment Account. If I
write the check from my checking account, the amount correctly shows up in
the Income/Expense report.
Any ideas as to why it works differently, depending on which account I pay
the tax from?
In microsoft.public.money, Tom wrote:
>I just wrote a check to the IRS, and in the Expense Cat...Calendar/Dates Help
I have an excel spreadsheet that lists every date in the year, with a
particular code in the next cell.
Monday 3/01/2005 11M 22M 32M
Tuesday 4/01/2005 11T 22T 32T
Wednes 5/01/2005 11W 22W 32W
Thursday 6/01/2005 11H 22H 32H
Friday 7/01/2005 11F 22F 32F
Saturday 8/01/2005 11S 22S 32S
Sunday 9/01/2005 11N 22N 32N
Monday 10/01/2005 11M 21M 33M
Tuesday 11/01/2005 11T 21T 33T
Wednes 12/01/2005 11W 21W 33W
Thursday 13/01/2005 11H 21H 33H
Friday 14/01/2005 11F 21F 33F
What I need is to be able to search by the code eg "33T" and have all the
dates listed for ...Urgent help with CStringArray
i need to return a CStringArray from a class method, but CStringArray (and
CStringList also) doesn't have a copy constructor!
I want avoid memory allocation within the metod because I don't want to
force the class user to deallocate pointers... this is the piece of code:
const CStringArray MyClass::MyMethod()
return StrArray; // this will generate a missing copy constructor
"Gaetano Sferra" <email@example.com> wrote in messag...vlookup help #3
I cant figure out the proper syntax for the attached workbook. Th
first 8 options on worksheet two work perfectly ( ie when checked, the
appear on worksheet 3) I dont know how to apply the formula of th
first 8 options to the rest of the checkboxes.
Can someone please help me figure out how to do this? Thanks i
Attachment filename: start order2.zip
Download attachment: http://www.excelforum.com/attachment.php?postid=46674
Message posted from http://www.ExcelForum.com
Right-click on the sheet tab for the Options worksheet.
Select View ...Bill Pay Help
I just signed up for Bill Pay (I have Money 2005), I'm not sure how to
coordinate Bill Pay with my Bills list and my checking account register. It
makes a separate Bill Pay register, but won't allow me to merge it with my
checking account (as Help suggests). Tech support was completely useless, in
fact it seems they're in a hurry to get us off the phone.
...Just Help Me
Hello All . . .
Please answer the questionary in the following URI
Thanks a lot . . . :D
Post the question here, and we might.
(replace somewhere in email address with gmail if mailing direct)
"CorfuVBProgrammer" <firstname.lastname@example.org> wrote in message
> Hello All . . .
> Please answer the questionary in the following URI
> Thanks a lot . . . :D
...Help revising slow code
I am using the following code to remove all the lines in a worksheet that
have a zero value in Column H. Because there are thousands of rows in the
worksheet, this loop takes forever! Does anyone have any suggestions for
doing this more quickly? Thanks!
Dim Firstrow As Long
Dim LastRow As Long
Dim Lrow As Long
Dim CalcMode As Long
Dim ViewMode As Long
CalcMode = .Calculation
.Calculation = xlCalculationManual
.ScreenUpdating = False
Say i have multiple sheets dated 04/01/10 to 04/30/10, each contain names,
say A, B, C, D, etc... but these name does not appear in the same order in
each sheet. Now data is in time format in front of A, B, C, D, etc.
Eg. in sheet 04/01/10
like this data in other sheet till 04/30/10.
Now in a new sheet i want this data to be collated in time format in front
of the individual sorted in Alphabetical order. Also it should give me the
Sum of the data.
Is it possible and how?
Thanks in advance for the help!...I need help with windows xp home edition.
I currently have windows 7 prof. installed but I would like to reboot and
install windows xp home edition instead. ( for my own reasons ) I have the
windows xp home edition disk but when I reboot with it in my dvd drive it
just freezes. When I am running windows 7 and I put the disk in, it won't let
me click on install windows xp. If someone can help me, I would greatly
appreciate it. Thanks
you had best check and see if you can locate all the drivers for all your
hardware, using XP, if the pc was supplied with 7, you may be out of luck
trying to get hardware drivers.
&q...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" <email@example.com> w...Autofilter help
I have 4 columns of data with an auto filter on - all ok
I then reduce my selection so I finally only have one row of data - all ok
Not ok: Problem: Is there an easy way that I can copy the data in the top
row of the filter, to another worksheet page - so if the filter is changed
so top line shows new result - still copies over the data in the top row of
Bearing in mind that the top row could be I.E. Originally Row 8 or 108
depending on the selection.
Autofilter Line = 1 2 3 4
eg Result of A/F a a a a <== copy the result of this line to