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...Test Mail...Please Ignore #2
Testing NNTP Client,
Please ignore message
...error messages 03-03-10
Operating System: Mac OS X 10.6 (Snow Leopard)
Email Client: pop
Was syncing entourage with mailme when i got an error message. I clicked it off and they kept coming...at one time I had 20 on the screen. I had to close the program and then turn off my Macbook Pro, then turn it on. I cannot use Entourage without this happening...opened it and one popped right up.
On 2010-03-02 22:09:33 -0500, email@example.com said:
> Was syncing entourage with mailme when i got an error message. I
> clicked it off and they kept coming...at one time I had 20 on the
&...Junk E-Mail Lists Error in Outlook 2003 with Exchange 2003
I have seen several people post about this error message that comes up
in Outlook, but so far I haven't seen anyone respond. I am running an
Exchange 2003 server with SP1 and my client is Outlook 2003. I
installed IMF a few weeks ago, and it appears that this message
started soon afterwards. I have now uninstalled IMF, but am still
receiving the message. My end users are getting frustrated, as am I.
There also appears to be an error in the IMF deployment guide about
adding a registry key to increase the list size in Exchange. It
states to "right click System", but there is n...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...Error while Archiving email
I am getting error while trying to archive email from Exchange Mailbox to
archive file. Here is the error
Error while archiving "Inbox" in store "Mailbox-<user name>". Unknown error
I created new archive file and tried to archive I keep getting same error. I
tried this from different workstation too. I am administrator on local
machine and running Windows 2000 pro with SP4 and Office XP with SP3, my
email is on Exchange 2000 server with SP3.
Any help on this is greatly appriciated.
When I open outlook I get a Timeout error.
I can ping the exchange server.
try to expand timeout time . There is an option in an advanced menu for that
"Wesley Steele" <firstname.lastname@example.org>, iletide �unu yazd�
> When I open outlook I get a Timeout error.
> I can ping the exchange server.
> Any ideas.
...Drop down menu #2
Is is possible when you have a drop down menu, to have excel short list the
menu as you type in more charcaters of the text. For example a have a list
of several hundred customers. I start inputting the first few letters of the
customers name, I would like that list of several hundred to be shortened to
only include thaise customers that begin with the letters I have typed in.
Think this previous post by Debra Dalgleish would be of help:
"Although data validation doesn't support autocomplete, there's a sample
file here that provides a combobox from which you can se...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...Associated external Account #2
Just got some of our exch2k users migrated to another org exch2k3. Found
that associated external account rights which never seen before in 2k. Wish
to know the purpose of this account and when is the best time to use it.
Please help and thousand thanks.
Granting Access to External Accounts
"Elton Seng Yan Thung" <email@example.com> wrote in message
news:enFBAvpwFHA...virus scanning #2
I really get prompted for "requesting virus scan", and I don't know ho
to disable it; the warning is located beside ready, in Excel bar
Gerbatin's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1523
View this thread: http://www.excelforum.com/showthread.php?threadid=27651
What antivirus software do you use?
I think/hope the solution will involve a setting that you can toggle in that
program. (maybe you missed an option???)
The antivirus program doesn't have t...2 questions about Exchange Server 2000
1. How, or where, do I find out where Service Pack level I have installed? I
see that I downloaded SP3, but I can't tell if it was ever installed.
2. Clients have Outlook 2000. Inbox is open. Last message is selected. No
new mail. Then, if you click on a different message, you get the "new mail
has arrived..." message. It seems to only deliver new mail when you change
1. In Exchange System Manager, highlight the Servers container. It should
show you all servers in the right pane along with their service pack level.
2. Sounds like something is b...Turn data #2
Is there a way to turn the data in an Excel spreadsheet so that what is on
the top is now on the side and what is on the side is now on top?
I need to export my spreadsheet into Access but, I can't get it to format
correctly in its current orientation.
~Make a backup copy of your data to work from (just in case, so you
don't lose data)
~Highlight the entire range of data; click >Edit >Copy
~Choose a new location, on a different sheet perhaps; click >Edit
>Paste Special and select the Transpose box; click OK
Does that do it for you?
thank you so much. You are a genius...Pivot Table fields #2
Is there a way to format multiple pivot table fields at
one time and have them refresh that way, rather than
having to select each column and choose the format
I think the solution for you is to open the Pivot Table
Toolbar and select the Field Settings icon. This sets the
format for all results for that particular field.
One limitation that I haven't found a way around is
getting a preferred column size to "stick" and not reset
after a table refresh.
>Is there a way to format multiple pivot table fields at ...Only 1 taskbar button when i open 2 excel documents
Hi all. When i open 2 excel documents i have only 1 taskbar button on the
taskbar even though i did not choose the option to group similar taskbar
buttons under taskbar properties. Hence when i want to switch between the 2
documents i need to go to window and select them. Hence how do i solve this
so that i can have 2 taskbar buttons of the excel documents on the taskbar?
Thks in advance.
Tools>Options>View, check Windows In taskbar
"inenewbl" <firstname.lastname@example.org> wrote in message
news:6F715432-2EB2-47AC-B737-56D63F37537A@mi...Business Cards #2
I am trying to create business cards using Microsoft Publisher 2002 on XP. Where would I find the template for Avery 8397, or for any of the Avery business card products.
In page setup, select business cards, click Change copies per sheet and adjust the
margins to fit your template.
Avery has blank templates for downloading, choose Cards, there will be a list to
select from. Your number was not among them but generally business cards are pretty
Mary Sauer MS MVP
http://office.mi...2003: LDAP Error
I have just installed Outlook 2003 and get an error
message when typing names in the to: or cc: or bcc:
The error header reads "Microsoft LDAP Diectory"
The message is "LDAP Directory is unavailable (52)"
Thanks in advance.
Check the settings of the Address Book. Tools -> Address Book.
"Dave" <email@example.com> wrote in message
> I have just installed Outlook 2003 and get an error
> message when typing names in the to: or cc: or bcc:
>...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.
--...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
...Trouble using resolution for Outlook error
I am recieving the error in Outlook mentioned on the following page:
The instructions say to resolve the issue for an existing installation,
specify the *.pst file by using the Mail icon in Control Panel. First of
all, I do not know what *.pst file they are referring to. The following
directory on my machine:
C:\Documents and Settings\Nathan Sokalski\Local Settings\Application
Contains the following *.pst files:
I am ver...Outlook Express Error message #8
The following message comes up each time I try to send email thru Outlook
Your server has unexpectedly terminated the connection. Possible cause for
this indles server problem, network problems. or a long period of inactivity.
Acct. 'IMAP.aol.com', Server:SMTP.aol.com Protocol:SMTP, Port 25, Secure(SSL)
No. Socket Error 10061, Error #OX800CCOE.
Try posting this in an Outlook Express news group - this is not one of them.
Outlook is a part of Microsoft Office and is what this group supports.
Outlook Express is a part of Internet Explorer and has its own news groups.
Y...Error During Send/Receive in Outlook 2003
When i try and send/receive in outlook 2003 it sends out
my mail fine however when it gets to receiving or updating
the inbox i come up with the following error:
Task 'Microsoft Exchange Server' reported error
(0x8007000E) : 'Out of memory or system resources. Close
some windows or programs and try again.'
I do not have any windows open. Below are the few things
that i have tried already.
-make sure no windows are open
-finaly restarted the computer and still no luck.
Well Hope to get a solution.
What are you system specs ? CPU...Macro Recorder #2
I have a very basic question( I think). When you are recording a Macro how
do you stop and then restart where you left off? For example I have a
repetitive task that moves columns from one spreadsheet to another. The
problem is that there are about 40 columns I am required to move.
As I record the macro can it be stopped and then restarted if I have to
close Excel and return later?
I can't find the answer to my question documented anywhere.
You can stop it, but when you start again it will create a new subprocedure,
you can go in and copy/paste the second after the firs...2 mirror files with :1 and :2
Not sure how, but have 1 excel file, lets call it FILEA.xls and when I open
it, it opens a FILEA:1 and a FILEA:2 workbook. Any change made to FILEA:1
gets repeated in FILEA:2 and vice versa. Looks like some sort of mirroring,
or changes being tracked, but track changes is turned off. Any help is
you've opened two windows of the same workbook (from the window /new window
menu) - just close one and then save - this should solve the problem
"DJR" <DJR@discussions.microsoft.com> wrote in message
news:F0F6BDF5-9DC2-486E-947C-ABBB6C4544...Date Range #2
Can someone please assist me with the following issue:
I am currently using the formula noted below to direct
another application ( Bloomberg ) to select prices from
the previous 6th business day.
My question is> Is there any way to revise the formula to
exclude US holidays for successive years (i.e. for 2005,
2006...) without having to manually change the date
entries each year, in the formula?
I'd recommend listing...