Writing a Macro
I am creating a form in Microsoft Word 2003. There is an area that requests a
physical company information, including;
City, State, Zip:
I would like to make it so that when a box labeled 'same as physical
address' is checked that the information that has been entered will autofill
to corresponding fields labeled Billing Information, with the following
City, State, Zip:
Can anyone help me with this?
See the Repeating Data page of Greg Maxey's website ...Max Customers Accounts in CRM 1.2
One of our client who is evaluating CRM asked for number of Customer
Accounts Limit of MS CRM 1.2. We know that MS is targeting CRM for small and
Medium size orgainzation but can it support customers of an orgainzation to
Can some one tell the max limit of Customer Accounts. ?
There is no defined maximum.. The key is sizing the SQL server appropriately.
Especialyl with CRM not supporting clustered SQL servers.
I know there are companies out there that have implemented (or are in the
process of implementing) installs for > 1,000 users.
MVP - Micr...read/write on two accounts
I have in exchange my mailbox and access - read/write - to another account
which we use for people to send general question to NJPIES and anyone can
read/reply to it.
What rights do I deal with so that people can read/reply BUT not delete the
When I reply, the reply - Sent- always goes out from my account. I will
like to reply and the SENT - be sent from that account so that any other
user can look at the history. sort of like news groups. Any ideas?
Which version of Exchange and Outlook? I'll use 2003 for...error value in axis
I am trying to plot a chart for varying number of weeks. I use the formula
=IF(J63=0,NA(),J63-1) to stop with zero th week starting from the week I
define. I also use similar formulas for getting data i.e
=IF(ISERROR(VLOOKUP($K64,$A:$D,2)),NA(),VLOOKUP($K64,$A:$D,2)), where k64
indicates week number.
The problem now is the data line stops with 'NA' values as expected, but the
axis which contains week number shows 'NA' after the week numbers. Any ways
to fix this.
Now you need dynamic names (aka named ranges) that know where the numerical
data ends, and use these names a...Excel
Thanks in advance for any assistance.
On some machines, when a user opens an Excel file from SharePoint and
checks out for edit and -does not- use the local drafts folder, you
see a dialog with "File Conversion In Progress", then "Converter
Failed To Save File" message, but the file is checked out to the user
and will not open in the Excel.
A kind-of workaround, is to use local drafts for the Check Out, but if
the user tries to launch the file via the link in SharePoint, the
"Converter Failed To Save File" message is displayed.
Both machines have SP1 and the la...Custom E-Mail Stationary
Question about a Custom E-Mail Stationary. I recently bought a custom
stationary for Outlook 2007. It has two pictures and some text. When setting
up the stationary it does not show the pictures and only shows a red "X". It
seems that the path of the picture is incorrect. I cannot contact the company
who created the custom email stationary.
...need help replying to multiple email messages
I sell things on the internet, and when I receive say 5
emails for prospective buyers, I would like to be able to
highlight all five of those and repsond to all of them at
the same time instead of having to cut and paste five
addresses individually. this has to be possible -
anybody know how to do it?
...Filters *SOS* Filters *SOS* Filters *SOS*
1) On formLoad, I need to show only those items which are unassigned.
2) I need for the end-under to select only the items they are assigned to.
3) I need an option to select "ALL" so I can view all items.
Any insight offered would be appreciated!!!
On Wed, 29 Aug 2007 16:24:01 -0700, valdaiway
>1) On formLoad, I need to show only those items which are unassigned.
Use a query to put a criterion on the field that defines the assigned status.
I assume you know how that information is stored in your table; nobody here
does, ...How do I customize the context menu?
I'd like to customize the context menu in excel (ie - to add and remove commands from the "right-click" menu), but I've been unable to find out how to do this. It does not seem possible to add or remove commands from the context menu via the "Tools -> Customize" menu as the context menu is not visible there. Any information anybody has on how to do this would be must appreciated. Thanks!
The commandbar is actually called "Cell".
Here are two subs that show how to modify it. The first
will add a smiley-faced button that calls the subroutine nam...Last Calculated Value
I have a spreadsheet written in Excel 2006 for Windows. It has a
function written in Visual Basic.
When I open it using Excel Mac 08, it opens in an empty sheet, and I
need to arrow to the sheet that's used, where a column has #NAME? for
the cells using this function.
When I open it with Numbers 08, I get "Last calculated value used" as
a warning. The numbers from the calculation I had at work are in
I infer that those numbers are saved, but that Excel Mac won't show me
What good is having Excel for Mac if it's not compatible with...customer data import failed to import the address info
I use the intergration manager trying to import a bunch of new customers.
The source csv file has the customer id, customer name, address, phone,
email, address id, ship to address id, bill to address id etc.
After the importing, I found the address ID is created but the address is
So I went to table import to import the address but it says the address ID
is already existed.
Then I ran the table import again and name the address ID differently and it
seems working and now how can I update the statement id, ship to id and bil
to id address field with table import?
I also wanted ...Form Assistant Customizations
Hello, It appears that the form assistant is not customizable through the CRM
Interface, is that correct? If so, does anyone know of which files it refers
to so that they could be modified manually (I just need to be able to add
Any ideas are appreciated. Actually if anyone has any knowledge about how
that page actually works, like the data source it uses to load its drop list
values and fields that would also be handy information. Cheerio.
There is no support for modifying the form assistant. Any changes w...How to write a table of contents in word
Hi I have problems to accommodate my table of contents in word.
1.1 Intorduction into
1.2 Motivation und objective
1.3 Structure of the
The first item is given in my document. I want to create further sub-items.
The problem is that the page numbers 5 in 1st and 2nd line ...format cell with maximum value
I have a list of number, say 10rows by 10 columns. I want to specify a
conditional setting for each cell so that if the cell has the highest value
in its row, the cell will be coloured red. So I will get 10 cells that will
be coloured red. How do I do that?
Use conditional formatting. If your data starts in A7, then in A7, Format >
Conditional Formatting. Use the drop-downs and text box to create your
If cell value is equal to =MAX($A7:$J7), then set your format appropriately.
Copy the format through your entire table.
"Frank Drost" wrote:
> I have ...How do you interactively write to a CEditView Window
(Newbie): I am trying to output status and diagnostic information to a
CEditView Window and allow users input annotations to the same window. The
User input is handled by Windows. How do I output to the window? How do I
ensure that program output is appended to existing text? DrawText erases the
screen and outputs to (0,0). What is the magic? (Please)
On Thu, 17 Apr 2008 10:34:00 -0700, skidmarks
>(Newbie): I am trying to output status and diagnostic information to a
>CEditView Window and allow users input annotations...Insert Functions
I need to insert the current time and date into excel when a barcode is
scanned from an ID card. It requires the [ "ctrl" + "shift" + ";" ] for
which I can't find an ansii code for the latter or how to input the
combination.. Any ideas how I can put this into the code so it will output
to excel when the card is scanned. Also, it would be nice at the end of the
code to get the focus to go to the next row, first column after a scan, to
be ready for the next card. Any help is greatly appreciated.
David A. Powell
in VBA why not use something...XML atribute value
Asking for XML atribute value
I m lost when I wanna ask for attributes value’s
my xml file is:
<?xml version="1.0" encoding="ISO-8859-1"?>
<MIGversion>...Print Customer Statement (or similar report) w/o closing billing c
Print Customer Statement (or similar report) w/o closing billing cycle
Is there a way to print a customer statement or similar report before
closing billing cycle?
None of the reports available would show/print a statement.
Anyideas or suggestions?
...How can I stop Excel from autoformatting as DATE?
I have a cel in which I am trying to enter a PO# of 10- 8348. Even
though the cel is not formatted to adhere to a Date formatting (it is
set to General), whenever I exit the cel, the data converts to
I don't want it to do this! I can't find where in the Autoformat
potions I can turn this off.
Short of turning the machine off, the only thing that comes to mind is to
format the cell (before you enter the stuff) as Text. Format - Cells -
Number - Text. Or precede each with an apostrophe.
mvpearl omitthisword at verizon p...Printer Driver Function
This is a multi-part message in MIME format.
I want to create a "print driver function" for print-to-email
I create a document in Excel, or Lotus 123 or any other program which =
has the ability to print. I preview it to make sure it is OK. I select =
as a printer: "print to email".=20
Then properties button pops up and when I press it I have a choice of =
file formats, dpi and compression. The idea is to p...alter function
Hi, using SQL2005. I want to replace a function and can't because the
function is being referenced by an object. I have tried to drop it first and
then create the function. This has the same error result.
Is there a way to ignore any referenced object and drop a function (and then
re-create it). Alternatively any way to ignore referenced object and alter a
Any ideas or recommendations appreciated :-)
Havv you created a UDF with SCHEMA BINDING option?
"Jonathan" <Jonathan@discussions.microsoft.com> wrote in messag...Excel Versions #2
I can't seem to open excel 2000 files with Office 95
version. Anyway around this problem. Thanks,
From the menu, File > Save As, then in the "Save as type" drop down (at the
bottom of the dialog) choose "Microsoft Excel 5.0/95 Workbook"
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"
"Mike Campbell" <email@example.com> wrote in message
> I can't seem to open excel 200...vlookup for words content when there are duplicate values
Can somebody help me here.
Thanks in advance.
When I vlookup Material 1 to Material 2 for the Project No, I get
the vlookup Project No. as 222-56 for all the duplicate Material
How formula to use so that when there are duplicate values in
Material2, I want to have vlookup searching to match Project No.
containg "AA" as 1st choice ? (if no Project No. containing "AA", then
looks for its content "AB" and subsequently looks for "AC" if there is
ColumnA ColumnB ColumnC
Material 2 Duplicate? Project No.
224410 duplica...Customize Outlook Today...
After updating 3 users to Windows XP Service Pack 2, their "Customise Outlook
Today" button no longer works.
I have ran through the KB article 820575 and it did not make any difference
You can edit the registry to make changes to Outlook Today.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Author, Google and Other Search Engines (Visual QuickStart Guide)
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutio...Help SOS
I just upgraded my BDC Nt4 server installed with exchange
5.5 to win2k and during the upgrade I selected the role
for this server to become a member server in the new
Active directory. After upgrading the os, exchange
services all fail to run. the user which use to log on all
these exchange services is the domain administrator
account. I tried using system account to log on but failed.
Please help, thankyou SOS
Do you have an Active Directory domain?
"daniel" <firstname.lastname@example.org> wrote in message
> I just upgraded...