We have a file in csv format with about 1200 columns and over 2 million rows. It is 3.8 gb and too large to open in Excel. We need to be able to filter on several columns at once to conduct specific searches and are stymied trying to find something that will work. Any suggestions?
I have a spreadsheet I am trying to build as template for a budget. In one tab I have listed all our customers and the budgeted amount of income per month. Included in that tab is a column showing the type of income for each client (which income account) by month, it could be one of 6 different...
This has gotten especially bad since we started using Google Apps and hosted our email on Google. Email replies from some companies do not get coded properly or something and do not show up in Outlook. The header shows receiving the email from the proper party but nothing shows in the text. If I...
I'm perplexed. Suddenly my Outlook 2003 won't send my email. I receive everything fine. When it attempts to send it just acts like nothing is in the Outbox, but there are currently 11 emails in my outbox.
I want to format my hard drive on my laptop. I don't need most of the programs or files and have copied anything I need. I primarily use it only to surf the web or to connect to my pc at work using logmein.com. I open My Computer and click on the "C" drive, than go to File\Format. It keeps...
Using Outlook 2003. For some reason I frequently get the following error message when I attempt to reply to an email.
Your message did not reach some or all of the intended recipients.
The following recipient(s) could not be reached:
'abc@cebridge.net' on 6/30/2006 7:59 AM...
Using Outlook 2003. I accidentally deleted an entire Distribution Group when I meant only to remove one member. Clicked in the wrong place. I don't see the deleted group in my Recycle Bin. I had several hundred members and recreating it will be a major pain. Am I stuck or is there a way to find it?
Using Outlook 2003 with Business Contacts Manager. Whenever I compose a new email and click"To" to select a name, it automatically opens to "Accounts" list on the drop down instead of to Contacts, which is where I have most of the contacts. Is there a way to make the default open to Contacts...
I seem to totallyy forgotten how to do this and can't find it on any search. How can I reset Windows Media Player 10.0 as my default so that all audio files I play off the internet automatically play there?
I really like the Junk Mail filter in Outlook 2003 and how easy it is to right click and send a specific email to Junk Mail, and add it to the filter simultaneously. What I haven't been able to figure out though is how to do this with more than 1 email at a time. Is there a way?
I am using a VLookup in Excel to auto-fill in info on purchase orders when entering just the p/o # on another sheet as new inventory items are added for that p/o. Problem is I need the formula down the entire column but until a p/o # is entered on the new sheet it shows the error message "#N/A"...
Is it possible to do a VLook-up in 2 columns? No problem with 1 column but need to return a value from table array where columns B and C in one spreadsheet match identically to columns H & I in other spreadsheet.
The help menu tells me what level 1 and Level 2 attachments Outlook will block, but can't find any way to change the settings. I receive .xls and others no problem, but now can't get any .mdb files. Is there a way to change this to allow them to be opened or even visible?
What is the quickest way to view what are currently unpaid invoices by customer? I can go to reports-sales-statements and print statements that show a total amount but it looks like the total billed, not the total open. I choose unapplied only but it still shows just the total? AM i missing...
A consultant originally set up my print format for my checks and invoices in GP Dynamics. Unfortunately both need adjustments to the layout of how they print. I believe this was set up within GP and not an external Report Writer. Where is this located within GPD and how can I make adjustments to...
Received check #1 that included some payments not belonging to me, so applied all the valid payments and have money left. Check #2 from same customer deducted those erroneous payments from check #1, so not enough cash to apply to valid payments. What is the right way to handle this in RM? Cash...
Why is it that Outlook seems to arbritrarily decide sometimes to select the fax address instead of email address? In Outlook 2002, when creating an email I begin to enter an addressee and normally Outlook recognizes the name and pops the email address up there for me. Sometimes it will pop up...
Invoice is entered and mailed. Month later payment comes and realize I underbilled. Can I correct the original invoice? Do I create a new dummy invoice for the difference? Do I use some debit memo to adjust this?
I have about 20 invoices that were entered and printed. I know they printed as some of them have been paid. However, I am unable to find any of them when I do an inquiry by document # or in the smart list under Receivables Transactions. If I try to use that same invoice # again to re-enter the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.