How can I insert a cell reference in a footer (eg for variable foo #2
Any ideas on how to do this?
I'm trying to create a template with the doc reference number in the footer
However, I'm trying to avoid users having to edit the footer (because this
just wont get done).
Private Sub Workbook_BeforePrint(Cancel As Boolean)
.PageSetup.LeftFooter = .Range("A1").Text
This code should go in the ThisWorkbook code module.
(remove nothere from the email address if mailing direct)
"wngg001" <firstname.lastname@example.org> wrote in message
news:8A0F9D9E-269F-45CF-A6E3...I can send but not receive emails in outlook
I have just installed Outlook 2003. I can send emails but cannot receive
them. I have confirmed my internet settings with my ISP. If I return to
Outlook Express which was installed with Microsoft Works I can still access
my incoming mail from there
Do you receive any errors when trying to receive?
"TeeJay" <TeeJay@discussions.microsoft.com> wrote in message
>I have just installed Outlook 2003. I can send emails but cannot receive
> them. I have confirmed my internet settings with my ISP. If I return to
>...CRM 3.0 Reports:Error when trying to open reports on client m/c
I am unable to access CRM Reports from any other machine except the CRM
Server (Physical) box. I logged in as different users on the CRM server and
was able to open and see all of the reports based on roles. But I am not able
to view reports from any of the client machines. I am accessing Reports
through a web-client.
Upon trying to access reports through a client machine, I get the message "
error has occurred. For more information, contact your system
administrator". This does not tell me anything
I do not see anything unusual in the Web server (CRM Server), or the
Da...How do I install when "file ZF561407.CAB can not be found"
...Problems with MS-DateTime-Picker 6.0
My userform has a Multipage control on top. My
Microsoft Date-Time-Picker 6.0 Control is sitting
on "Page 1" of the Multi-page control. If I change
to "Page 2" and try to access the ".Value" of the
DTPicker control, it will return an error value.
(It is returning the year 1899).
What is wrong here? Does the DTPicker need to
be on the visible page to be used?? Are there any
other things I should know about this DTPicker control?
You could assign the DTPicker's value to a public date variable in its
Be...Need to populate a Report with several records
In short, I have one report containing 5 records from the same table. The
individual records are layed out to support proper printing. I need to
populate each record with from the same table. I can not give them all the
same pointer to the table or I get 5 copies of the same record. How can I
populate those 5 records with 5 records from my table?
I think you need to have a group by in your report. Thus you will get 1
group of data for each of the 5 that you are refering to as 5 records.
> In short, I have one report containing 5 records from the same t...Report Load Error via CRM
I am loading a very basic report that had a complex query but works
fine when running it in VS2005. When I attempt to load the report via
the CRM 4.0 GUI, I get the following error message:
An error has occurred.
Try this action again. If the problem continues, check the
Microsoft Dynamics CRM Community for solutions or contact your
Microsoft Dynamics CRM Administrator. Finally, you can contact
This report does not have any parameters at all, and the most intense
thing are embedded select statements which I have done on other
reports. I have instal...Owner draw buttons : 2D look...Can it be 3D?
i created owner draw buttons in my application. but the feel and look
of these buttons is not the same as the CButtons. i mean when i click
on the CButton, it gives a 3D feel as the text shows some offset and
the button gives a pressed look. but in the owner draw buttons, there
is no such 3D effect i can see. can we make it possible?
> Priyanka here...
> i created owner draw buttons in my application. but the feel and look
> of these buttons is not the same as the CButtons. i mean when i click
> on the CButton, it gives...Crystal Report error: information is needed 02-03-04
After reinstalling CRM I get this error when I try to get
a report. I know there is information since I'm just
asking for the user list.
Information is needed before this report can be processed.
Information is needed before this report can be
Any Ideas? Thanks
Also recieved this error, and have logged an issue with
MS, no resolution yet.
One tip they did provide, remove any underscores ("_")
from the server name. This has resolved the issue for a
lot ...EXCEL.exe has generated errors
For an knowned reason, the following message
recently started to display when clicking on
EXCEL on an Windows 2000 system.
EXCEL.exe has generated errors and
will be closed by Windows. You will
needed to restart the program. An
error log is being created.
Attempts have been made to repair, deinstall
and reinstall Office 2000. However, the above
message still displays with trying to bring
Can anyone help?
This WebPage by Chip Pearson provides a good place to troubleshoot.
--...distribution group / delivery report exchange 2003
an originator from outside my exchange 2003 organisation
is sending an email to a distribution list,
but he never receive a delivery report
global config, message format for domain * (is ok)
[x] delivery report
[x] non delivery report
"Ronald" <email@example.com> wrote:
>an originator from outside my exchange 2003 organisation
>is sending an email to a distribution list,
>but he never receive a delivery report
Did he request one?
MCSE+I, Exchange MVP
MS Exchange FAQ at http://www.swinc.com/resource/exch_faq.htm
...What does the "E" in 5E
I am used MS EXCEL to perform a scatter plot. When the information was graph,
Excel provided me with the formula 5E - 71e^0.085x. What does the "E" in 5E
The E is the way Excel represents 10 to the power. So 1.2E3 is 1.2X10^3 or
1200 and 1.2E-3 is 1.2 x 10^-3 or 0.0012.
remove CAPS in email address
"College student" <College firstname.lastname@example.org> wrote in
>I am used MS EXCEL to perform a scatte...Can not create Matrix Item please Help RMS 2.0
Can not create Matrix Item please Help
When trying to create any new items I receive error message
This is the message
(-2147217864) Row Cannot be located for updating. Some values may have been
change since it was last read.
Manger still creates standard items but still receives message with out this
number in message -2147217864
...default mail format based on domain
After 20_ years of Eudora and Thunderbird (in that order), I'm looking
at Outlook for the first time (we're moving to an Exchange backend,
so...worth a look, for obvious reasons). In Thunderbird, if I want to
set a default HTML format for emails sent to a certain domain, I can
specify that. For any other domain(s), plain text.
Is there an easy way to do that in Outlook (I'm using 2007)?
Basically, I want emails sent to my enterprise domain (i.e., my place
of employment) to be in HTML or perhaps RTF, but mail sent to other
domains to be plain text only.
Again, I want ...too many arguments I think
Hi, I am new to the forum and not too experienced in Excel. I wrote
this argument that does a calculation if a cell in the C column is 0.
IF(C17=0, SUM(H9:H16)^(B1/A1), IF(C18=0, sum(H9:H17)^(B1/A1), IF(C19=0,
sum(H9:H18)^(B1/A1), IF(C20=0, sum(H9:H19)^(B1/A1),
sum(H9:H20)^(B1/A1)))))))))))), but when it gets to C17 it gives an
error, it highlights the 'sum' argument, I think I have put too ...Outlook CRM Client!
I tried installing Oulook CRM Desk Client on one of my laptop which is not
an member of domain. It fails to connect to CRM website[i tried using ip as
well as computername but in both way it fails to connect to CRM Server] and
errors out whenever i start outlook.
I am using Windows XP [SP2] + Outlook 2003 Professional [SP2], any
Installing CRM Outlook Client on a machine which is not a member of domain
is not supported.
..........But someone has posted a workaround. I'm pretty sure it's not gonna
be supported by MS.
Search for "Outl...Microsoft CRM Exchange
From previous listings I came across the fact that the email router or
Microsoft CRM Exchange Connector sends and receives emails to and from CRM.
Also that we can receive an email in outlook then click the Promote E-mail
to CRM Activity button to move it into crm.
Where is this button located. Should I be working on the server where CRM is
installed to get this working?
You will only have the Promote button if you have installed Sales For
Outlook (or a third part add-in)
This will be on the client pc, not (definitely not!) the server
"Gautam" <email@example.com>...Is there a work-a-round i can use for making a datagrid....
Hey all, I am trying to make a datagrid on a form that the user would input
info, and once completed, it would be put in correct area's of the workbook.
I cant use a datagrid as job doesn't alw downloads for net so i cant get the
update needed to alw me to use datagrids( see post sugj: "Missing Control In
Addin") is there a way i can use a text box or some other box or tool to do
When you say "form", do you mean UserForm or worksheet set up to look like a
data input form? If a UserForm, then yes, you can use TextBoxes, but you
didn't supp...MS Query #4
First, does someone know of a document that provides
details on MS Query functions and their syntax. For
example, I know I can use left, right, etc. What other
functions exist? I want to do some parsing on some data
fields and need to determine the length of the field and
the place where certain characters are located within
that field. Thanks.
ODBC query syntax is determined by driver, not by Excel. Usually it's like
the syntax, used in database system, from where you get data. P.e. the
syntax for FoxPro/VisualFox ODBC query is much like to syntax, you use with
queries in F...Change Default When Selecting New Message From Form
Whenever I select New -> Choose Form, it defaults to "Organizational
Forms Library" (which is empty). How can I make it default to "User
Templates in File System"?
I've been looking for a way to do that for years, but have never found =
one. FYI, there is a newsgroup specifically for Outlook forms issues =
"down the hall" at microsoft.public.outlook.program_forms or, via web =
interface, at =
Sue Mosher, Outlook MVP
Author of Con...Display of CRM data in SharePoint
Is is possible to allow non-CRM users the ability to view CRM data on
SharePoint without using the CRM external connector?
Microsoft would require you to have a license per user I think
Microsoft CRM MVP
"Rick M" <RickM@discussions.microsoft.com> wrote in message
> Is is possible to allow non-CRM users the ability to view CRM data on
> SharePoint without using the CRM external connector?
> -Rick...Want to remove Public Folder store/replicas but see many logons
I would like to remove a Public Folder Store from a server in my
all-Exchange 2003 environment. We have had two Public Folder Stores, but
I'd like to use one of those Stores for a Private Store for mailboxes and
also because replication between the two servers is problematic. (It's only
a few hundred megabytes of infrequently-used data.)
I removed the replicas for all Public Folders in the ESM (View Public
Folders) then removed replicas for Free/Busy, OAB, and Organization Forms
after right-clicking and selecting View System Folders.
Still, users showed up under the &q...Multiple e-mail account in MS Outlook 2003
I have 4 e-mail accounts set up (all from the same server) and can send from
all accounts but I only receive mail for the default account. Any
Does each account use the same account properties? (e.g. same mailbox name,
userid, and password.)
"Crazy Squaw" <Crazy Squaw@discussions.microsoft.com> wrote in message
>I have 4 e-mail accounts set up (all from the same server) and can send
> all accounts but I only receive mail for the default account. Any
...Can anybody tell me what is wrong ...
I am trying to practice multidimensional array in a managed class using
If I tried to compile the following codes, I would get the under mentioned
c2440 error message. It is only practice. You may notice that I am not using
or constructor here. Can anybody tell me what is wrong and how I can rewrite
that line right?
Thanks a lot.
using namespace System;
using namespace std;
__gc class Month
public:...scanner can't read barcodes on paper
My barcode scanner can't seem to read barcodes that I printed out.
I will not barcodes on receipt either.
any suggestions will be great.
I had the same problem. I only had this problem with certain barcodes. When I
looked at the ones that the scanner wasn't reading, I noticed that they all
used lower case letters. As soon as I changed the letters to upper case I was
able to scan the labels.
> My barcode scanner can't seem to read barcodes that I printed out.
> I will not barcodes on receipt either.
> any suggestions will be g...