sending email #3
Having a problem with outgoing mail, seems to not be
going anywhere? Running Exchange 5.5 sp4, with Outlook
2002 clients. A client clicks 'send' the message goes to
the sent items folder, but the message never makes it to
the outbound mailbox. All services are running, the ques
are empty, but the "out" folder in imcdata has tons
of 'messages' dated since yesterday afternoon. Any help
on how to get these to "GO" ?? Thanks in advance for any
I would suggest turning up logging on the Information Store and the Internet
Mail Service...Leading Zero #3
A value in text format, e.g. 07654 in an export csv file looks just fine in
Notpad. But when the file is opened in Excel, the leading zero is gone. Is
there a way to add the zero back to all the values under the same column
...ING Direct #3
Thinking about opening an account here. Will it link to my Money file?
Thanks for your reply.
(I'm not at my home computer or I would check it out myself)
ING Direct no longer links allowing you to connect and update from
within Money. To update you have to go into the ING Direct Web site
and download your transactions to Money.
On Thu, 26 Aug 2004 08:46:32 -0700, "Scott W" <ScottW2000xx@Yahoo.com>
>Thinking about opening an account here. Will it link to my Money file?
>Thanks for your reply.
>(I'm not at my home computer or I would check it...more than 3 conditional formats #2
Is it possible to add more than 3 conditional formats to a particula
Any help would be much appreciated.
Message posted from http://www.ExcelForum.com
No, you'd need a macro to do the formatting with >3 conditions.
HTH. Best wishes Harald
"abailey >" <<email@example.com> skrev i melding
> Is it possible to add more than 3 conditional formats to a particular
> Any help would be much appreciated.
> Me...ANN: HTTPMP
HTTPMP is MAPI transport service provider used to access HTTP mail service accounts
(commonly Hotmail). HTTPMP could be used with MAPI compatible client applications
(such as Microsoft Office Outlook) to send/receive Hotmail messages in much
the same way as POP3 transport.
1. Sending/receiving messages
2. MIME encoded messages
3. HTML, RTF and text formatted message body
4. Messages with attachments
5. LAN and dial-up mail service account access and polling
6. Auto dial and auto hang-up
7. Fast asynchronous Internet operations
8. Internet connection configuration page
HTTP...How do I find the inside page in the 3-panel brochure.
I am trying to make a 3-panel brochure and all that seems to be available is
the side shown in the brochure options. When I print, it prints both sides
yet I can see no way to access the inside part. Thanks.
View, status bar... this will allow you to change page views, you will see the page
tabs at the bottom of the screen.
I am not sure I know what you are asking. Are you saying you are printing the
brochure sight unseen?
Mary Sauer MSFT MVP
"springmtn" <firstname.lastname@example.org...Report names in listbox
I recently upgraded to Access 2007 and am having some trouble with the
changes. I have a form with a listbox in which I would like to display the
names of all the reports in the database. I've tried using the following as
the rowsource for the listbox, but in form view nothing is displayed. Does
anyone know how to do this?
WHERE (((Left([Name],1))<"~") AND ((MSysObjects.Type)=-32764))
ORDER BY MSysObjects.Name;"
I think you made a slight typo. Try (((Left([Name],1))<>&quo...Rank #3
I Have a list of about 50 differnt numbers. The numbers are constantly
changing. I need to figure out who many points behind the highest score is
each individual cell.
So in column B i want to say that a1 is 9 points behind the leader. A2
would be 14 points behind the leader.
in B1 put:
and drag down.
"John" <John@discussions.microsoft.com> wrote in message
>I Have a list of about 50 differnt numbers. The numbers are...value from field not accepted within onlineform (3.0 -> 4.0)
We just tried to update our running CRM 3.0 to 4.0
there where nearly no problems! (1 report was not upgradeable)
We where very happy.
but right now a real problem was discovered:
the fields: longitude and latidude from the contact form are no more accepted.
Enter a value beetween ....
But the values do perfectly match within the range
When I delete the values I can save the form.
When there is any value in the fields it causes the error: Enter a value ...
Best regards for any help
...copying formulas #3
This is probably a simple question for most of you, but I have an exce
file that contains approx. 400 sheets, with a summary sheet. How do
copy a simple formula to read Cell B1, but the next sheet needs to rea
Cell B2 and so on. Example: Sheet #1 is the summary, then sheets 2-40
have a title taken from the summary, so if I do a typical copy formula
it keeps reading Cell B1. Hope my question is clear!!! Thanks
Ladkins's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3252
View t...How do we close an invoice in version 3.0?
In version 1.2 we had an Action on the toolbar to close the invoice.
Now we have nothing.
I tried customizing the form and adding the statecode, but that field
is Read-only and so it didn't help.
We mass-print all of our invoices and need them to be closed (not
deleted) once they are paid.
I did not see Invoice Paid on the Actions menu once the invoice was open.
> In version 1.2 we had an Action on the toolbar to close the invoice.
> Now we have nothing.
> I tried customizing the form and adding...Indirect and Address Functions to Determine Schedule #3
I am struggling with writing an Excel formula that I would greatl
appreciate some help on.
In theory this sounds quite simple. I have a table which shows th
progression it takes, in months, to move from one 'level' to the next.
Another larger table shows how a number of 'starting' individuals woul
progress through their levels based on the progression table mentione
[FONT=courier new]Progression Table[/FONT]
Level One 1
Level Two 2
Level Three 3
# of People Jan Feb M...i cannot send any emails through my CRM 3.0.
i cannot send any emails through my CRM 3.0. The strange thing is that i can
only send emails to myself, but not anyone else.
what should i check and where to detect the problem?
Check the SMTP configuration on your CRM server. There is a good chance you
chose the "default" SMTP setting during the setup and this requires SMTP to
be configured on the server itself. You can run a "Repair" installation and
it will allow you to change the SMTP config.
MVP - Microsoft CRM
"Maria" <Maria@discussions.microsoft.com> wrote in message
new...include more than 3 data series as columns in combination chart
I am making a combination chart and am only able to include the first 3 data
series with the column chart part. The rest of the series are all included
with the second series which has a much larger value.
On Tue, 26 Jun 2007, in microsoft.public.excel.charting,
Cindy <Cindy@discussions.microsoft.com> said:
>I am making a combination chart and am only able to include the first 3 data
>series with the column chart part. The rest of the series are all included
>with the second series which has a much larger value.
Ignore "combination" charts, you don't need the ...Trendline Equation #3
MS Excel allows users to create a trendline on a plot
based on a number of points. One option to display is the
equation for the trendline that was created. How can I
extract this equation?? I know copying and pasting the
equation to a cell works, but I'm assuming there's a
better way to get the equation.
Use the LINEST function. For more on how to use for functions other
than linear graphs see Bernard Liengme's
If you must get the coefficients from the trendline, search
google.com's archive of the XL n...custom header #3
I would like to know how to set up a custom header which shows the data in a
perticular cell (i.e. - C9 shows the number 100, so I want the header in all
the pages,except the first, to show "100".
One way is to use a macro.
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Dim myHeaderStr As String
Dim iCtr As Long
myHeaderStr = Worksheets("sheet3").Range("C9").Value
For iCtr = 2 To Worksheets.Count
Worksheets(iCtr).PageSetup.LeftHeader = myHeaderStr
(I used c9 on sheet...J2EE to CRM 3.0
Does anyone know how to get a J2EE app to access data held in CRM 3.0?
CRM exposes two public webservices, one for the businesslogic and one for
the metadata. You should be able to connect to those webservices using J2EE.
Jeffry van de Vuurst
"Simon Morris" <SimonMorris@discussions.microsoft.com> wrote in message
> Does anyone know how to get a J2EE app to access data held in CRM 3.0?
> Simon Morris
Thanks for t...Importing Records in to CRM 3.0
On a monthly basis, I import a CSV into the Leads area of CRM. This worked
well in 1.2 where I was able to select the "Target" field(s).
When I tried this same technique in 3.0, I noticed the "Target" field
contained the target field info, but was disabled thus not allowing me to
change if I want to.
Is this new in 3.0 and if so, is there a work-around
I guess the target fields which are disabled must be mandatory fields for
the lead. In V3 it was enforced that mandatory field has to be mapped and so
this restriction. If right source field is ...Union Query with 3 tables
I'm trying to use a Union query with 3 tables to combine the following
fields. Not all customers have a territory or broker; however, I would like
al lthe customers listed in the output. Thanks for any help
Customer Number from table 1
Territory Name from Table 2
Broker from table 3
What you are looking for is not a UNION query. A UNION query merges like
data from multiple record sources into a single result set. In my
experience, it's most common use is to normalize a poorly structured database.
I believe what you want to do is create a query that links your Customer
t...3 Personal Folders
I have 3 copies of the same "Personal Folders" folder. They are all 3
exactly the same. When I right click on one of them to close it, the option
is greyed out. How can I get rid of the extra two copies?
To remove extra PST(s) from the folder list:
Outlook 97 or Outlook 98/2000 (Corporate Mode)
- On the Tools menu, click Services.
- Highlight Personal Folders service you want to remove and click "Remove".
Note: Standalone users require 1 Personal Folders Service. Those connecting
to an Exchange server normally do not use a Personal Folders file when mail
is kep...Help with calculation #3
On sheet2 I have a list of dates where A1 is 01 Jan 2004, A2 is 01 Feb
2004 etc through to 01 Oct 2005, against each date is a column of
figures. So A1 is the date and B1 is the volume.
On sheet1 I want to have a formula that will calculate the total volume
between 2 dates selected by the user, where D7 is the earliest date and
D9 is the latest date. So after they have input the dates the volumes
between those dates will be totaled and shown in E10.(They will only be
able to input dates for the 1st of the month - so as to match the data
held on sheet2.)As you appreciate there will be more tha...Publisher cannot open the file #3
I upgraded Office Small Business Professional 2000 to SBP 2003. Now I cannot
open files created in Publisher 2000. Please help - would have never
bothered to upgrade had I known this was coming!
Are you running Norton Antivirus by chance?
MVP Microsoft [Publisher]
"Publisher 2003 Upgrade" <Publisher 2003 Upgrade@discussions.microsoft.com>
wrote in message news:55771BEE-74C1-4D58-9B89-2514A06C0B3E@microsoft.com...
>I upgraded Office Small Business Professional 2000 to SBP 2003. Now I
> open files created in Publisher 2000. P...Out of Office AutoReply #3
I would like to ask you a question regarding one function of Outlook Express
Since I got a mail from someone with the subject: Out of Office AutoReply
Of course I sent them mail before and they just out of their office and I
think they did some setting so that the system can auto reply to the sender
So do you know how to make it?? Thank you very much!
If you are in an Exchange environment (ask your administrator if you do
notknow) you can set the Out of the Office Assistant which is located under
If you are not in an Exchange environment you can c...IMAP and Outlook 2003 #3
Microsoft claims you can configuring Microsoft Outlook to connect to an
Internet Message Access Protocol (IMAP4) server.
I have set up the account in Outlook, but it works poorly. Articles in
the knowledge base seem to admit that it works poorly. Is Microsoft
attempting to force the use of Exchange?
Has anyone had sucess with IMAP and Outlook?
If so, how?
Which server did you use?
Darren <email@example.com> wrote:
> Has anyone had sucess with IMAP and Outlook?
Outlook 2003. in my opinion, a poor IMAP client. It works, but it's not
really production quality. I unde...CRM 3.0 walkthroughs
Anyone knows where to get CRM 3.0 Walkthroughs using .NET 2003 and 2005?
If you haven't already done it, download the CRM SDK from
You find a lot of additional samples in the internet. beside my own site
(link below), look at
to get a list of CRM community sites.