Exporting CRM Opportunity List to Office Excel 2007
We have CRM 3.0 Server.
Our users are using CRM Web Client to access their leads, opportunities,
quotes and orders.
Using the Export toolbar button in CRM, users who have Office 2003 installed
on their PCs are able to export opportunity lists to Excell perfectly all
right, however users who have Office 2007 installed are not able to do that!
Is this a limitation in CRM 3.0 ? Is there a workaround (If any)? Any
possible risks when using or applying this workaround (If any)?
"luai7" <email@example.com> wrote in message
news:6CADFDC5-8439-4B5F-955A-D6DBF...Publisher 2007 Merge Print Screen
This only happens in Publisher 2007. I do merges: in Excel, in Word,
& in Publisher. When the "print" screen comes up in Publisher, the
screen is so large, I have to push up as far as I can, and there's
just a sliver of the print button on the bottom - can't even see the
"print" word on the button. However, my cursor does react with it, so
I do print successfully. I just would like to know if there's a way
to make this one screen smaller. There's no arrows at any of the
corners, so I can't squeeze it down.
> When the...How do I use the Outlook Address Book in Word 2007
Our company used to use Groupwise along with Word 2007. I could do individual
envelopes using the address book on Groupwise. Now we have Outlook 2007 and
my address book was migrated to Word. But when I try to do an individual
envelope and click on the Outlook Address Book, it says there are no entries
in the address book. Do I have to re-do all my addresses in Outlook? Or is
there a way to access this address book?
Do you have a choice to use the Outlook Contacts Folder? Try that instead
if you do. Also, ensure your Outlook address Book Service is installed.
Milly Stap...Out Of Office Assistance #3
I am Running Active Directory 2003 and Exchange Svr Std 2003 on my Domain.
I have setup so users can use the Out Of Office Assistant tool.
The Out Of Office Assistance only works on Some user accounts and Not all.
All users can activate the Out Of Office Assistance using Outlook 2003 but
only a few users are able to send Automatic Replies back.
Is this a known issue?
If someone has a solution please let me know.
...Exporting Money 2006 to OA 2007--No New Fiscal Years
When I attempt to import MS Money 2006 data to OA 2007, none of the bank
transactions (~400) migrate, and the error log tells me:
"The financial date of a document must be within an existing open fiscal
In OA 2007, I find that only fiscal year 2002 has been created...hence the
Find an OA newsgroup? Not trying to be flippant, but there's next to no OA
experience that has been evidenced in this NG.
"cwfox" <firstname.lastname@example.org> wrote in message
news:E21A987D-B741-483A-B60F-0A9A58F47721@microsoft.co...Outlook 2007 doesn't understand vCalendar entries any more !?!
I occasionally need to copy/paste calendar entries from another calendar
application into my private Outlook. Until recently - using Outlook
2002/XP - this worked fine.
Since I switched to Outlook 2007 this does not work any more. Instead of
pasting a new appointment I only get a new appointment with no title, no
date, no other field filled except the comment field which contains the
entire (and - as far as I can see: valid!) vCalendar entry.
Can one somehow teach OL2007 to accept and properly interpret such entries?
I just learned that I can paste that calen...Word Pad 2007 Won't remember Font choice
WordPad 2007 on Windows 7 RC refuses to remember the font that I choose. I
can't see how to make a particular font default either. It constantly
reverts to default font which I don't like as it is hard to read. I can
change the font size and that stays changed.
I am using WordPad to copy excerpts from web articles and each time I copy
another excerpt and place it in the open document the font reverts from my
Verdana choice to the default one.
I recall having this same problem on Word 97 and my current Word 2002 on
other machines. I can't remember how I fixed the p...Excel 2007
I wanted to post a fix to a common problem I've seen. There are many posts
on the internet concerning this but I've only seen the true fix once. Here's
the problem, someone installs Office 2007 and then when they try to double
click on an Excel file, it opens Excel but the Excel file itself does not
open. So, you are left looking at the Excel 2007 screen, but it is blank
with no workbooks open (not even the default one that usually opens). Here
is the official Microsoft solution: http://support.microsoft.com/kb/924074 -
however, this only fixes about 20% of the case...Microsoft Publisher #2
Trying to open email attachment (newsletter) created with Mircosoft Publisher. File 'saves' from attachment to 'Downloadw' but will not open in Publisher. Message reads "Publisher cannot open file" with an 'okay' button. Also, unable to print that screen to send to original sender.
Are the versions of Publisher the same or is your version a later version?
Are you running that garbage software Symantec Norton AV?
"If you don't know where you are going,
any road will take you there!"
Is the attachment a .pub file?
M...Office 2007 and Vista
I am contemplating on buying a new updated desktop computer that has vista
as an operating system, what I am worried about is the ability to use my
current Office 2007 which is installed on a PC with XP on the new PC with
vista or am I going to have to buy a new version of Office?
Vista 32 bit or Vista 64 bit?
With Vista 32 bit no issue but with Vista 64 bit I would certainly go
for Office 64 bit.
One licence................one computer.
To use Office on both computers you will need to purchase another copy of
Gord Dibben MS Excel MVP
On ...Microsoft 2007
I am trying to share a workbook -
Toolbar, Review/Share Workbook - Each time, I get a message, the file is no
longer shared and will not let me save. Any thoughts?
I think another person of your shared workbook might have removed you from
the sharing. Otherwise the file has been moved to some other location. Save
the current file in your local system and try to open the Original File from
its actual location.
Remember to Click Yes, if this post helps!
> I am tryi...2 part protection in Word 2007
Can you proctect a single word doc on two levels? One level allowing users
to fill in the forms fields only. Second level allow track changes to only a
certain part of the document. When the user fills in the form fields, track
changes does not show it as a change but if a user makes any changes to a
body of text, it tracks the changes.
Thank you for the wisdom!
No, Word's protection mechanisms aren't that selective. Besides, if
you're using a protected form, the user can't edit anywhere except in
the form fields unless they turn off protection.
Regards,...RUS Issue 2003?
Having an issue with our Exchange that from what I have read, may be a RUS
issue?? What is happening is this. If we create a new user account and
mailbox, the mailbox is not appearing in the appropriate storage group nor
the email address in the GAL. When I check the advanced Exchange Tab on the
newly created user account and look at mailbox permissions, only SELF is
present. Normally, there is a whole host of inheritted permissions. The
account is also set to inherit email addresses from the global recipient
policy and does not. No addresses are present for the user.
If I ...Data Validation in 2007
Is there a way to make the Data Validation dropdown list dispaly
descriptions but when you select one it puts in the corrosponding ID
Name: Phone #
So when I'm in the cell and hit the drop down and Select "Bowers" - it
actually saves the phone number "360-482-7878" instead of "Bowers"
Not directly but in an adjacent cell you could use VLOOKUP to pickup the
Bernard V Liengme
Microsoft Excel MVP
r...EXCHANGE 2007 MESSAGE SIZE LIMIT
Hello. I am running an environment with Exchange 2003 and 2007. Our message
size limits are 50MB and have worked fine until 2007 was installed. Now, any
users on the 2003 box have only a 10MB limit, even though it says 50MB in
System Manager. I have also set the parameter on the command line on the
Exchange 2007 server, but no dice. Users on the 2007 server work fine.
I'm stuck ... any ideas?
Have you checked message size limits on the Connector?
Are you using an Edge server as well?
MVP - Exchange
NEW blog location:
---...Access 2007 Switchboard buttons stop working
Environments tested: Windows7, WindowsXP, Access 2007, Access 2003
Access data project (.adp) run in development mode in all tests. SQL Server
2005 back-end database.
Trusted locations set up for all tests. The trusted location is the folder
where the .adp resides, sub-folders included.
Default file format: Access 2002-2003.
I have a .adp application with a standard switchboard form as the main menu
navigation. The buttons on the main switchboard form are used to launch
forms, stored procedures, macros, and other child switchboard forms. The
switchboard navigation buttons a...collapse a specific mail folder from a macro in Outlook 2007
My Outlook 2007 archives emails to a "archivel" folder tree structure
that is parallel to my mailbox folders.
I've written a macro that switches between a folder and its archive
As a safety measure, I want the "archivel" folder collapsed altogether
when I switch back to the non-archive folder, so that I don't confuse
its folders with the normal ones - any Idea how I do this?
Thanx in advance.
Dim names As Collection
Set names = New Collection
Dim cf As Folder
Set cf =...E-mail ID generation issue
"I created a few new mailboxes, but when I look at the
users properties in Active Directory Users and Computers,
nothing is listed on the Email Address Tab. I also
manually updated the RUS in the Exchange Suystem manager.
It is more than 6 hours since the IDs are created, but
still the e-mail field in the AD property is empty. The
environment is Exchange 2003 in AD 2000 native mode.
Can someone help me pls?
Anything in your app event logs, such as msexchangeal 8331 errors?
See KB 837444 if so. SP1 fixes this but there's also a hotfix you can get
(free) if you call MS.
VS wrot...Microsoft Dynamics Metrics
We use GP 10 in a sales organization where reps’ are paid commissions.
Metrics is a cool dashboard application which needs more flexibility to its
data used in formulas offering the ease of customizing reports.
I would like my sales reps the ability to view their commission in a summary
report on their customers
A -> Z and not limited to 10 customers. Show customers, COGS, sale, profit,
total, and % of gross profit. Allow for date ranges, and a refresh. Opt the
sales rep to view either sales in Order status, or in Invoice/posted. A mini
P/L report specific to the ‘user’ logge...VBA in 2007 interface programming question.
I am looking to do 2 things:
1) Capture data typed into the cell as it's typed before Enter is pushed
2) Create a box under the cell(like when you start to type in a formula and
it provides the formulas that match what you type)
Can someone point me in the right direction on what I should be looking for
and I can figure out the code from there.
Macros do not run when you're in edit mode. You's need to position a
textbox over the cell and have the user type in that.
Maybe something here might work for you:
...With Due Respect, 2007 .....
With due respect, 2007 did include many improvements.. Faster
editing/formating, extended conditional formating, better wizards,
Be aware that some of the formating may not be compatible with 2003
versions... I actually lost much formating from 2007 during save. So
if you share worksheets/books, make sure they are compatible before
saving if someone will be using older versions... Just a note..
Mhz's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35980
View this thread: h...Referencing worksheet issue
I have a workbook with 50 sheets (named 1-50 )and would like to create a
summary sheet that displays the value of a cell (say A1) on each sheet. Is
there some way to force an incremental increase in the sheet number as I
drag a cell downward? I am not familiar with constructing macros, is there a
way to do this without a macro, or with a simple macro a beginner might
I'd like it to look like the following.
Thanks in advance for the assistance,
Starting in A1:
=in...Issue with ADP form bound to Stored Procedure
I have an application that I support that is a Microsoft Access Database Project. It uses Access as a front end to a SQL Server database (SQL Server 2000). The current version of Access used in production is Access 2000 (Office 2000). My application site will be receiving new workstations next week that run Access 2002 (Office 2002/XP). When testing with the new version of Access we discovered an issue with one of the Access forms being bound to a Stored Procedure as its data source. It uses the following code to do this
Me.RecordSource = "dbo.proc_frm_Input
Me.UniqueTable = "d...Active Sync with Exchange Server
I am trying to sync my pda pocket pc with our exchange server.
The Exchange Server is 2003, SP1.
Outlook Web Access and OMA are working fine.
If I start the sync I get the error HTTP500.
What can I do?
Check out http://support.microsoft.com/?kbid=886346 and
http://support.microsoft.com/default.aspx?scid=kb;en-us;323077 in the
...Windows 2003: Issue user certificate on behalf of a user
I'm working on an application where we are going to use User Principal Name
Mapping (http://technet.microsoft.com/en-us/library/bb742438.aspx) to map
incoming requests on our application to windows accounts. From what I
understand, this will require user certificates issued by a CA within the
I've got a test Windows 2003 R2 domain up and running and have the CA
running as well.
What I can't figure out is how to issue a certificate for a user without
logging in as that user and using the web enrollment app. Is there any way
for a domai...