I have created a template in word which I call through a VB script from
excel. The excel data is populated in the word every time I run this script.
Everything works fine and the data get populated.
I have a header in the template which is represents one of the fields in the
excel sheet. The header shows the correct linked value for the first 10 pages
but then on shows the variable name instead of the value. I have no idea why
it does that?
can someone help
The code is as follows:
For iCurrentRow = 1 To iLastRow
If ActiveSheet.Range("B" & iCurrentRow...3 Hole Punch
Is there a was I can see where my three hole punch is going to be placed? In a brochure that I am doing I don't want some items to be right in line of my punch holes?
Strike a guideline where the holes will be, don't create anything beyond the
guideline. Normally it will be about a half inch, but I'd measure if I were you.
Mary Sauer MS MVP
"Jason" <email@example.com> wrote in message
> Is there a ...CRM 1.2
i would like to have all documentation of crm 1.2 (implementation guide, user
guide, etc.....) in french version only.
is there someone who can help me?
Thanks to reply
You can read all information at
> i would like to have all documentation of crm 1.2 (implementation guide, user
> guide, etc.....) in french version only.
> is there someone who ...Outlook issues after Exchange migration
We recently migrated Exchange 5.5 mailboxes to Exchange
2003 on a new domain. This was performed with the exmerge
utility in a 2 step process. Now there are 2 issues with
1) When a user types a recipient name into the address
field, the name autocompletes as normal. But when the mail
is sent, a message returns saying it is undeliverable.
However, if the user goes into the Contacts folder and
from there selects the same user to send a message to, it
2) If a user shares a calendar, specifying the user with
whom to share and the level of permissions, all users in ...No Send Button #3
I have decided I want to start using Outlook 2003 (after using Outlook
Express for years). I have the Office 2003 Professional Edition, which
I successfully imported my address book and email folders from OE.
I went through the steps of setting up an email account, tested it, says it
was successful; but I never did get the test email in Outlook. (I opened OE
and the test emails came in there just fine)
I tried to compose an email, and noticed there is no "send" button. Also,
when I go to File, New, the option of New Message is not there at all, the
I have CRM/SQl/AD on the same server. There are no
performance issues at the present time. I am unable to
review reports within CRM, but I did republish the
reports on the server using a ms utility. Has anyone
come across issues with CRM and AD on the same server. I
have two other servers running AD, how do i proceed to
remove the server from the AD. What will be the impact?
I have both a production CRM environment and a test CRM one. The production
one is split amoungst multiple servers to handle the load, but our test is
running entirely on one server.
I have W2K running Exchang...Taskbar issue
I'm hoping someone can help me with this long-standing problem with both XP
and Vista on separate laptops and every computer I've had (except I think
Win98). I'm thinking there may be no solution, but what it's worth a try.
With both of my machines, I have the taskbar (as well as other toolbars) set
out to maximum size - typically half the screen - and to auto hide. (This
makes a great program and file launcher)
The issue is that the operating system decides it wants open the taskbar on
its own from time to time on its own. Various things prompt this, ma...DST issue
I entered the catalog item:
<Feature Name="Item" CatalogItemId="Item:MS:sysgen_timesvc_dst" />
and confirmed that the device has the registry key:
HKLM\Software\Microsoft\Clock\AutoDST = 1
But the device still does not automatically adjust for DST. I set the
timezone to Pacific, set the time to 3/14/2010 at 1:59AM, waited for one
minute...and the time changed to 2:00AM instead of 3:00AM.
What am I missing?
which OS version are you using? have you updated it with the relevant qfes
which deal with the changing in DST starting day?
-...Formula/calculation returning a 0 instead of actual sum
I am using 2007 and I have a workbook that returns a "0" instead of the
actual sum. I have tried using @sum formula and just adding the cells
Sounds like your values are not "real" numbers. They may be Text values.
Another possibility is you may be in manual calculation mode.
Gary''s Student - gsnu200908
"Jenny Beech" wrote:
> I am using 2007 and I have a workbook that returns a "0" instead of the
> actual sum. I have tried using @sum formula and just adding the cells
...CRM 3.0 and Outlook2003
Someone can help me to fix this problem?
A couple days ago, the CRM's botton which being addin to the outlook is not
working, and error messages are shown up when outlook is starting up:
"(There is a problem communicating with the Microsoft CRM server ...... An
error occurred loading Microsoft CRM functionality. Try restarting Microsoft
Outlook. Contact your system administrator if errors persist......)" . The
web-accessing for CRM is working.
How can I fix this problem?
Thanks a lot for your help.
...multiple instance of CRM on domain
We have a situation where two divisions want seperate instances of CRM. It
is important to note, each division has it's own domain.
While I know we can manage that, my question concerns the exchange router.
Since the email for both divisions come through the same exchange server (and
through a third domain), my assumption is there would only be one exchange
Has anyone done this before and what are the potential issues I may need to
address to make this work?
This will probably answer your question (or some parts of it anyway):
http://blogs.msdn.com/crm/archive/2006/10/0...Outlook/EX Email Issue
I'm running Windows XP with XP Professional. I cannot send email but I can
recieve it using Outlook. There error says that Outlook was unable to access
the SMTP server. I cannot access my email at HOME through the web email. What
I can do is send/recieve email using Outlook Express AND I can access my
email through my web email client outside my home. My ISP (SBC) says its not
them and I'm somewhat inclined to agree with them? They say I could have a
corrupted kernel32.dll file. I have turned off my Norton, deleted my account
and set up a new one and re-installed XP professiona...HTTP/1.0 503 Service Unavailable after logging into OWA
I could use some urgent help with a problem I'm facing.
My company is currently running Exchange Server 2003. We have one OWA
front-end server configured for our entire global company. We have multiple
OWA sites on this server to service all locations that current hold an
So we have an OWA site for AMER, UK, Ireland, and KL.
Currently all OWA sites are working fine, except for our KL OWA site. Users
in this domain can browse to the logon page just fine, but after
authentication the page then displays HTTP/1.0 503 Service Unavailable rather
then taking them to t...Solver add-in #3
Hi, I've been fiddling with the Solver Fantasy Football example on here.
In my example (it's using soccer league data - but similar except
there's no need for the team data on rows 110-136). I've added an extra
column for each players club but I can't work out how to add a
constraint such that I restrict the numbers of players from any one club
to only 2?
I hope that makes sense - I've got the solver to pick the team with
maximum points but it has 5 players from the same club. I want to
restrict it to ...Cube on CRM
I was wondering if I am able to use SQL Server Analysis
tools to create a cube on MS CRM?
Am I able to access the MS CRM database directly from SQL
Server Analysis Tools
Kindly assist pls
We are running GP 9.0, using Windows 7, just installed Adobe 8.0 and are
unable to send documents to PDF from GP - the PDF option remains grayed out.
We have folowed the KB articles that are available, no success. Do we need to
install Adobe 9.0 due to running Windows 7? Is GP 9.0 compatible with Adobe
9? Thank you for any assistance..
I have a client using Adobe 9 on Windows 7. However, they are on GP 10.0
It is working succesfully.
> We are running GP 9.0, using Windows 7, just installed Adobe 8.0 and are ...Possible Report Issue
Hi. I'm working on a database for a safety audit. The auditors would like to
be able to use some of the tables and subtables as a sort of checklist for
the audits. The table/subtable structure is as follows:
I decided to create a report that will output that data. However, the report
is only outputting information if there are ProgramRequirements already
entered for a given ProgramArea. Is there a way to get it to output the
ProgramArea and ProgramRequirement even if blank? Or am I going about th...Automate e-mail signature in CRM
It would be great to do automatic e-mail signature in CRM like Outlook
without using the E-mail Templates.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=0c42f6bb-a6e9-48d...Extender Install Issues
GP 8.0 Extender install - I'm encountering the following:
*Login to GP brings up screen: "Great Plains Extender needs to finish
installing. This may take a few minutes". It has an OK button and clicking
on this gets you into GP but it comes up everytime. How can we stop this
from popping up all the time.
*When creating a new Extender Window and I get select the Form, I get the
following error: "A remove range operation on table
'PT_User_Defined_Window_Keys' failed accessing SQL data." Procedure or
function zDP_EXT40101L_1 has too many arguments spec...Referencing cells #3
I've got two workbooks linked together. Workbook A gets information from
workbook B by referencing cells. This works well until someone enters a
column into the middle of workbook B and workbook A picks up the wrong
information from workbook B. Is there anyway to get workbook A to understand
that a column has been inserted into workbook B and that it just needs to
shift the references along one column?
(I apologise if this doesn't make very much sense!)
Use either Defined names or absolute references.
"Sel" <Sel@discussions.microsoft....crm callout #2
When i am writing code for callout postupdate ,Can u give the code for
comparing preimageentity xml and postimageentity xml
...How to find position of a MDI window frame in the main frame client coordinates?
Perhaps I am overlooking something very basic.
I have a FormView that I want to resize from within my
program to create place for additional controls if they
So I need to check the size of the view window, calculate
new size and position, then move the view window.
To make long story short - if I will have a code that
"moves" and "resizes" window to exactly the same size
the window has, I will be ready.
Under normal API it is accomplished by this code:
ScreenToClient(hDlg,(LPPOINT)&rc);...Issue with formula is Pivot table
I have the following formula in a pivot table:
First to the issues that I am experiencing. First, the formula wa
originally added as the one below but then updated to the formula abov
to correctly reflect what I was trying to accomplish.
This issue is the original formula appears in the very first cell o
the pivot table and then periodically through out the column. So, yo
see ...destroyed CRM with wrong Sitemap?
This is quite urgent as you could guess.
As I have no possibilty to test on a second system I finaly edited the
sitemap and loaded it up. CRM 4.0
Everthing seemed to be fine, but every time you start the webclient an
errormessage says: Applikation can not load to do a n error.
I tried to reimport the original sitemap, the following error shows up,
when I try to upload: Access denied
Any ideas how I could bring back my original sitemap
(I thought I just have to reimport - and thats it)
...Print a 2-sided document in Excel for a 3-ring binder?
How do I print a 2-sided document in Excel for a 3-ring binder? I have tried
everything I can think of, but the margins on the backside are identical to
the margins on the front and that doesn't work. The right margin on the back
needs to be like the left margin on the front in order to punch holes in the
document. Any help you can give would be great! I cannot be the only one
who needs to know how to do this.
You would normally set that option on the printer functions, File>Print>click
Properties next to printer name.