Collection tracking lite
I have a customer that is interested in tracking their
contacts with customers on AR collections. I know that
the Collections Management Module in Great Plains will do
a great job of that, but they are looking for a very
Is anyone aware of a third party developed enhancement
that will just give someone a place to make notes, etc.
regarding their collection effort?
Thanks for any information you may have.
This may be too obvious, but why not use the notes function already built into
Great Plains. That way all accounting system users can read the notes, add to
them as...Using mouse wheel in VB editor
Just tried using the mouse wheel to scroll within visual basic editor in
excel but it wont let me. How can I turn this feature on. I am using Excel
Thanks in advance.
This is a known problem with the latest MS mouse drivers. You
can either install version 4 of the drivers (current version is
5), or use FreeWheel, and freeware program at
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"fullers" <firstname.lastname@example.org> wrote in message
ne...Send to certain person using specific email account
I send an email to a certain receipient but don't want to use the
default email account.
Is it possible that when I send to them (plain text) , that it will
choose the other account I want to use to send it? Please advise how I
set this up.
I do not believe that this can be achieved automatically through standard
use of Outlook as you need to manually specify the name of the account to
send from if different than the default.
However, it would be possible using the Outlook object model. An Addin would
need to be developed that monitored each mail item prior to sending. If the
d...Use exchange from a trusted domain
I have domain a and domain b. Domain a is all set upp with exchange etc.
Domain b was bought, and they don't have exchange. I have trust between the
domains and file sharing and authentication are ok.
What we want to do is, make users on domain b and let them use the exchange
(on a seperate storage) on domain a.
The users on domain b must logon to domain b, but need to have mailbox on
Domain a are running on win2003 and exchange 2003. Domain are running on
win2003 with forest and domain ready for exchange.
thanks in advance,
Thi...Office 2003 Service Pack 3--subsequent problems opening Publisher
I run Publisher 2003 on Windows XP. On June 13, I updated my system with
Office 2003 Service Pack 3 so that I could open Word documents with the file
ext docx. Subsequent to the Service Pack 3 installation, whenever I open a
Publisher file (which I created), I get the following message: "Publisher has
detected a problem in the file you are trying to open. If you are certain
that this file came from a trusted source and does not contain harmful
information, click OK." What is causing this and is there a way to stop this
Error message when you...Service Products Tracking.
We run a workshop repair service, what is the best way to track customers
products, as it seems unfeasible to add products when booking an over the
counter repair order in CRM.
I would like to track repairs against machine manufacturer to do simple
reporting like reliability against brand etc.
I would recommend the following as the product you sell is a service I would
create the service as the product i.e. create product Start-up costs, hourly
To track brand reliability I would create one or more custom entities which
contain the brand and maybe even their products. T...Using Access 2003 on client to see Sharepoint 2007
Testing a Sharepoint environment and I can easily manipulate and run the
database from Access 2007, but when I try to use Access 2003 it wants me to
save the database to a location. The Access 2003 has the compatiblity pack,
but it seems to not work when I download it.
So the question is using Sharepoint 2007 and posting the Access 2007 format
to it, can a user go to the sharepoint site and use a 2003 Access database
that has the compatibility pack and open without having to download it?
Message posted via http://www.accessmonster.com
Send check for $500.00 to: David A Jenn...date tracking
I am entering clients into a 2007 Excel spreadsheet. How do I make the entry
turn color when 14 days have passed?
This is a multi-part message in MIME format.
As part of the "client" entries, do you enter the date the client was
entered? This would be the key in doing this task.
In a cell on the worksheet you could enter the formula for today's date
like this =TODAY().
Then use the con...VCard issue #2
This is a weird problem, but when I send a vcard to
someone, it shows up in my sent items as a vcf file, and
has a vcard icon on it, but when the recipient gets the
VCard, it shows up as msg file, with an envelope icon as
the attachment. When I open it, nothing is there - it's
empty. I can't find anything regarding this problem on
google or MS's website. Anybody have any ideas? Is it a
problem with Outlook? Do I need to do a detect and
repair, a reinstallation? Thanks for your help!
Does the same happen when you send a message to yourself? Is he/she able to
see it w...Merge code issues with Publisher 2003
It seems whenever the data source is altered, the merge code fields have to
be reinserted in the Publisher document. Is this normal?
The data source starts in Excel and is then saved as a .txt file to retain
number formatting on final merge.
...How Use ShellExecute with a CMemFile
I need to store files of various types (such as .doc, .xls, .jpg, .pdf,
..wmv, ...) in a database. Upon retrieval of such a file I have the file as
data in memory in a CMemFile. I need to then "display" the file in the
aproriate application. If I were to write the CMemFile to disk and create
an actual file I could then, of course, use ShellExecute() to launch , say
Word to display a .doc file.
However, I would much prefer to avoid the overhead of writing the data to an
actual file and then dealing with having to detect when the User is done and
cleaning up the file I had ...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...Using INDIRECT within functions
I learned a bit from JLathman in a previous post but tried to use the same
methodology with this formula (also learned from this Group to get the last
entered value in a column) without much luck.
The original formula was this with 2009 sheet being static:
Trying to make it dynamic I tried the following without success:
=LOOKUP(INDIRECT("2,1/(" & O1 & "!$H$3:$H$65536<>"")," & O1 &
Did I miss something or are...How to use count for calls per hour
I am trying to create a pivot table and chart that will show me the # of
calls per hour by day for a range of dates Aug 1 - Sept 19. My data looks
like this where each line is the date and time of the call:
How do I get a count of the # of the calls per hour by day?
8/1/08 12:48 AM
8/1/08 1:53 AM
8/1/08 2:36 AM
8/1/08 3:24 AM
8/1/08 3:37 AM
8/1/08 4:04 AM
8/1/08 4:44 AM
8/1/08 4:55 AM
8/1/08 4:58 AM
8/1/08 7:02 AM
8/1/08 7:28 AM
8/1/08 7:43 AM
8/1/08 7:47 AM
8/1/08 7:56 AM
8/1/08 7:58 AM
8/1/08 8:13 AM
8/1/08 8:33 AM
8/1/08 9:07 AM
8/1/08 10:28 AM
8/1/08 10:38 AM
8/1/08 10:44 AM
8/1/08 ...Recommendations Please: Software That Can Backup Outlook While It is Open/Running
As the subject says. There are lots of packages that will backup the pst,
etc. once Outloook is closed, but some products claim to do it while Outlook
is open. Any suggestions on products that actually do this and do it
properly? If the product can safely backup over the network to a server and
can do incremental/update backups throughout the day, I'd really like to
hear about it.
...How export all mailbox-enabled users from the GAL using Outlook?
We have a user which, for administrative reasons, needs to export all
mailbox-enabled users in the GAL now and then. They just need all the
names. Is there a straightforward way for them to do that?
We don't want to give them any special permissions and want to avoid
server scripting. Ideally, they should be able to export it to a CSV
file or any text file.
> We have a user which, for administrative reasons, needs to export all
> mailbox-enabled users in the GAL now and then. They just need all the
> names. Is there a straightforward way fo...SQL 2008 running on a VM using all allocated memory
I've got a sql2008 server running on a VM. There's 9GB of physical RAM,
which 7GB have been allocated to SQL Server. But when i look at task manager,
i see that the SQL server is actually using all 7GB, which is pegging the
memory usage of the overal box at above 90% used. We're mostly a sql2005
shop, and none of those servers are doing this. I have sql2005 running on
VM's, someone actual servers as a named or default instance, and some even
clustered. None of them have this problem. Is this a normal thing with
sql2008 only? Any insight would be greatly appre...Anyone use Promys CRM software integrated with GP Dynamics?
Our company is considering using Promys as a CRM to create quotes and
sales orders for the sales team. I am concerned about the integration
with GP and what the pitfalls may be. Is anyone here currently using
Promys with GP Dynamics?
...Loading Text File to TextBox using LoadFromFile
I'm creating a form that allows the user to pick a txt file (dialog) and
then display the path and contents on the form. The code has been cobbled
together as I found the pieces that worked, so bear with. I got the file
picker working and displaying the file name on the form, but the file
contents won't display. I had a feeling the problem had to do with importing
a namespace (see the error in the code when I tried "Imports System.IO") or
with a missing reference.
Using Access 2003.
References: VB for Apps, MS Access 11 Obj Lib, OLE Auto, MS V...Can't use openURL or access internet on some locations
I have previously raised a question where openUrl threw an exception in
a specific office location. However the problem I have now is that the
application just freeze when I call openURL. It seems as it is waiting
This only happens at one company so far the company does have a proxy
but so do I at work and I have no problems.
I have also tried the Microsoft TEAR sample and it behaves the exact
same way, it says "Opening internet...Connection made" and then it just
stops. If I run it on my computer it gets the webpage and everything
I have tried to set t...Software and Database Shapes for Microsoft Visio
For those that may have missed them
A set of Microsoft Visio stencils containing shapes for creating Express-G,
ORM, Jackson, and ROOM notation diagrams.
...unable to send outbound mail using outlook
I've enabled the smtp virtual server on our new exchange server and have our
domain's mx record pointed to it. I've redirected our clients to point from
our ISP's mail server to ours, but outbound mail is not working. when i tried
to telnet to our server and do a "mail from: " of a local account, it's
saying invalid address.
Is there a separate setting to enable using this SMTP virtual server for
Sorry... my mistake. I simply enabled message relaying and it works now.
> I've enabled the smtp virtua...Using XSLT to transform XML prior to loading into Dataset
I am trying to transfor an XML document prior to loading into a
Dataset. My problem stems from the known bug in Visual Studio that
prevents loading a well formed XML because of duplicate child names:
Anyway, I want to transform the XML using the XSLT to get around this
problem, but I am having a tough time coming up with a way to apply
the XSLT before loading it into the dataset. Any help and sample code
Thanks in advance.
The XslTransform class has an overload of the Transform m...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 ...Reply to emails uses the contact primary email not the sent from e
We have encountered a problem with MSCRM when replying to an incoming email.
The email must be resolved to a contact record (either automatically by
recognition of a unique email address or manually) in order to reply.
When the reply is sent, it is sent to the default (primary) email address
for the Contact and not to the email address that the customer sent the
original email from! There doesnt appear to be any way to select an
alternative email address.
Has anyone come across this problem before? If so, any advice on how to
proceed? (We dont really want to overwrite the primary ...