Chinese antique #2
trwKzfjVvqO6aHR0cDovL3d3dy54ang1ODguY29tCrXn08qjunhqeF81ODhAd...Cash Sales Entry #2
How to do a cash sales entry?
You mean a cash-basis accounting type of entry or a sales transaction
where you are receiving cash (as opposed to check or credit card)?
New User wrote:
> How to do a cash sales entry?
...Save email as word doc #2
Does anyone know how to save a Email message to a word
document. When tring to select "as save type" word
document, in the save as documents screen there is no
choice to save as word doc. Is there a way to activate it
in outlook 2003, the option was avaliable in earlier
You should be able to do this when you set Word as your e-mail editor and
then reply on the message.
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-Backup and Restore
-Create an Office XP CD slipstreamed with Service Pack 3
"Tec" <anonymous@discussio...Converting Lead Notes and Activies information into Opportunity re
The Lead Activities (phone calls, emails, task, appointments, fax, letter)
and the Notes created while working on a Lead do not "convert" into the
Opportunity. To get this information, you have to go to Closed Leads or
drill down through the Originating Lead link. I've read that this will be in
2.0 but in the meantime, can anyone suggest a simple workaround. I would
also like to hear about the best way to do this, simple or note. If I create
new fields in the Lead form and map them to new fields in the opportunity
form, the activity functionality is reduced to that of ...Diagram show blank as zero value when based on a formula
When a chart is based on a formula e.g. =IF(A1=0;"";A1*B1) then the chart
will show the blank value "" as zero even if you whant to plot gaps or plot
the empty cell interpolated. Yes, I know Excel say empty cell and the cell is
not empty when there is a formula. Is there anybody who have found a "work
around"? I often have formulas that generate zero in the result but I want to
plot the result as if it was empty.
I found the reply myself in a question from another user similar to this issue.
I will use NA() instead of ""
Thank you that works!
&q...Lead to Product and Lead to Competitor relationships
While browsing MS CRM logical DB Diagrams (http://www.microsoft.com/
dynamics/crm/using/sdk/DBDiagrams.mspx) for Sales Entities, I have
found many-to-many relationship between Lead and Competitor entities.
In SQL Server I made a diagram with the following tables: LeadBase,
ProductBase and CompetitorBase and then I added tables
LeadCompetitors, LeadProduct (these tables contain no data in my
case). You can see my diagram below. I saw many-to-many relationships
between Lead & Product and Lead & Competitor. As far as I understand,
these relationships must support functionality for adding ...Microsoft Outlook #2
I do not know how to backup Outlook. I would appreciate
it if someone could explain how. I am worried that I
could lose all of the contact and calendar data.
...help with matching if #2
The formula worked very well.
As you can see I am totally a noob to excel. And I have another noo
problem needed to be solve. can someone please help me once more.
Quetion #2: per say, I have a table of data, and I would like to exce
to return the matching values from the table to a2.
[ ]|Y1 |Y2| Y3|
A4 will return the matching values from y1,x1=.54
Thx for the help everyone.
augustus's Profile: http://www.excelfor...how to Sum last 10 values of a dynamic column excluding zero
hi, i have this formula =SUM(OFFSET(P2,MATCH(1E+30,P:P)-1,0,-10,1)) which
sums the last ten values in column P, i was hoping someone could amend it
slightly for me. As column P is dependent on other entries the entire column
has 0 in it which makes this formula ineffective, i can't put an IF formula
into column P because then that wrecks other formulas that need column P, so
i need to work in a way of excluding zero into the forumla above.
Also, the formula does not work until there are ten values in the column, is
there any way to make it work and count the values up until ...Printing labels #2
I have created a holiday gift label in Publisher. I do not however need to print a full page for each relative. Can anyone help direct how to print a specific number of labels as opposed to a full page.
What version of Publisher are you using???
This is the ugly way of doing it.
I use Publisher 2000.
I take a piece of 8�"x11" (in A4 country, use A4) and some Scotch Temp tape
and cover the labels I don't need.
Vancouver, USA - One of the great cities in one of the 45+ countries in
"Ed Heff" <email@example.com> wrote i...default file locations #2
Application: Excel Version: 97
We have a shared file out on our server that sales accesses daily. On
one computer when saving, it wants to save to his "my documents"
folder on his local computer and not to the original location on the
network. This just started happening on his computer. If I go to
another computer and open and save it, it saves it to the correct
network location. Any help would be greatly appreciated.
Just a guess, but are you sure that the user is hitting File|Save and not
In xl97, file|saveAs will want to save to the default folder--not the folder
I closed the shapes toolbar (perhaps its called a "stencil"?). I can't get
it to come back. It was located at the bottom of the main window. I closed
it intentionally to maximize the main window size, but i can't seem to figure
out how to get it back. I can get Shapes Windows to appear behind or to the
left of the main window, but I can't get them to adhere to the bottom of the
window (like toolbars do).
What version of Visio are you using? With 2003 if you grab the "Shapes"
window by the title and drag it over your document to the v...Missing mail folder #2
Today my machine did not start properly and I seem to have lost a mail
folder in Outlook 2003 I have used the Inbox Repair Tool and it did find
errors, but hasn't repaired the missing mail folder. Its not in recycle bin
Im sure I've not deleted it and I need the emails. Help please.
yar <firstname.lastname@example.org> wrote:
> Today my machine did not start properly and I seem to have lost a mail
> folder in Outlook 2003 I have used the Inbox Repair Tool and it did
> find errors, but hasn't repaired the missing mail folder. Its not in
> recycle bin Im sure I&...Keeping one of 2 cells always zero
Hi all of you,
I have such a requirement. There are 2 cells in which the user ca
input values. However, one of the two cells must always be zero fo
valid inputs. Is there any way to do this?
I was thinking of setting other cell to zero when user enters value i
one cell or prohibit user from entering value in a cell till the othe
is made zero but I don't seem to figure out how to do this.
Is a macro the only way out (trapping a worksheet change?)? Is i
possible to use someother functionality like data validation. I woul
also like to impose restrictions on the non-zero cell of values betw...XSL question #2
I have an sample xml below.
I want to do a distinct on the code node and the programDescription.
I want the output to be like in a tree structure.
So i would like to have
PRG004 >Crazy Training 2> MAT01
Any ideas it musn't be in a tree but it could be in a table structure
<?xml version="1.0" standalone="yes"?>
<?xml-stylesheet type="text/xsl" href="email.xsl"?>
<programDescription&g...Receiving e-mail #2
I was wondering if anyone could help me with this. On my
outlook at work. I can send e-mails to those outside the
company but cannot receive e-mails from outside.
Any advise would be great.
On Sun, 8 Aug 2004 22:02:39 -0700, "Crissy"
>I was wondering if anyone could help me with this. On my
>outlook at work. I can send e-mails to those outside the
>company but cannot receive e-mails from outside.
>Any advise would be great.
You need to ask your System Administrator at work if this is po...MAINTAIN pst files #2
>i know that there are 2 utilities that come with office that can scan and
> something else to my pst file.
> i have outlook 2003 and have no idea where i might find those files.
> can anyone lead me to the right place?
> Thank You
> windows xp
I am opening a common delimted file in Excel and formating 2 fields as "text"
to retain leading zeros. They appear correctly in Excel. I then need to
save as a "csv" file and retain the leading zeros. How can I do this? The
zero's always drop off in the csv file when retrieved again in excel.
do you need to save the csv every time, if you save I agree it will remove
There is no perfect solution to this but if your file format is standard,
you may consider preparing a excel template with the repeate, concencanate
and left and right formul...Default Font #2
In Outlook 2003, I find the font too small.
Where do I go to change the default font of the messages I create?
DNS SYSTEMS LIMITED
Try Tools > Options > Mail Format - Fonts
"Paul Ingram" <email@example.com> wrote in message
> In Outlook 2003, I find the font too small.
> Where do I go to change the default font of the messages I create?
> Paul Ingram
> DNS SYSTEMS LIMITED
>...Watermark in Excel #2
Can a watermark be added to an Excel worksheet?
>Can a watermark be added to an Excel worksheet?
...My Custom Line-Column 2 axes Chart dsn't work with +6sets of cells
I created a custom Line-Column 2 axes chart with 6 columns and it worked
fine, showing two different Y axis. Then I tried to do the exact same process
with a larger data set, with 10 rows again, but this time 12 columns, and it
doensn't work - it repeats the 12 columns twice, instead of recognizing that
I want the 2 sets of 12 on top of one another, like 2 layers, each with a
different Y axis. Any ideas on how to avoid this? I think it may be a flaw in
the software because, literally, when I delete half the cells and run the
same process, it works... it just doen'st seem t o kno...Fill leading zeros
I have a SELECT statement that I want to fill leading zeros in one column and
trailing blanks in another column up to xx characters. For example
SELECT CAST(EmployeeNumber AS varchar(8))
If the EmployeeNumber is 1234 I want to output 00001234
SELECT CAST(LastName AS varchar(15))
If the LastName is SMITH I want to output SMITHxxxxxxxxxx where x = space
Could this be done by casting a CHAR(15)?
> SELECT CAST(EmployeeNumber AS varchar(8))
> If the EmployeeNumber is 1234 I want to output 00001234
SELECT RIGHT('00000000' + CAS...Generate Leads/Accounts/Cases from a public website?
My employer asked me to investigate using a public .Net website to help
generate information to be used in CRM. Specifically, he'd like our website
to have webforms that, when filled out and submitted, would generate leads,
accounts, or cases depending on what our needs are (I suspect generating
leads would suffice for now).
Can anyone point me in the right direction on how to accomplish this? I've
found it difficult to find information online concerning this.
We're currently using CRM 3.0 although I'd be interested to know what
differences would be in...Lead Number
I want to count the number of lead in the database with reports, but
don't known how to do ? If anyone has an idea ?
You won't be able to accomplish this by using the Report Wizard. You need to
use the SRS BI tool for Visual Studio.
> I want to count the number of lead in the database with reports, but
> don't known how to do ? If anyone has an idea ?
On 14 ao=FBt, 16:01, SS <S...@discussions.microsoft.com> wrote:
> You won't be able t...zero value
How do you add a zero in front of a number in excel without it disappearing?
Precede it with an apostrophe or use a custom format like 0000
which would display 0123 if you enter 123 in the cell
"Jimmy" <Jimmy@discussions.microsoft.com> wrote in message
> How do you add a zero in front of a number in excel without it
>How do you add a zero in front of a number in excel
without it disappearing?
if the number remains constant ...