Creating a group of cells. Need Help Please.
Havn't used excel in a while and I need to create a group of cell
corresponding to an input of a min and a max.
Here are the details. On one sheet I have a box where you enter th
min and a box where you enter the max. In another sheet I want
column starting at A2 to output (MIN,A2+1000,A3+1000,....MAX) ho
would I do this
Thundersixx's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3055
View this thread: http://www.excelforum.com/showthread.php?threadid=50207
Name the...How to create a CustomerID field for custom entities
The customerid field is used in opportunity and case and it allows you
to select an account or contact, Great.
I want to create this field in a form for a new entity i have made,
but i cant work out how.
Customer is special composite type which is not available for custom
entities in CRM 3. You will need to add two separete lookup fields for
account and contact.
uMar Khan :: MS CRM MVP
CRM Freelance Consultant
Email :: imumar at gmail dot com
Blog :: http://umarkhan.wordpress.com
MVP :: https://mvp.support.microsoft.com/default.aspx/profile/umar.khan
&...Combining cells to create a formula
I have two cells that I want to combine to have a working formula
B1 = sum
B2 = d3
b3 = =b1&"("&b2&")"
D3 = 10
The result in b3 is : sum(d3)
How do I get this to result in the actual value in D3.
I know I can simply write =D3, but the actual reason for combining the two cells is more complicated than explained here.
I think you are perhaps looking for the Indirect function
would return the value contained in D3
As you copy down, the formula would alter to 4, 5 etc. represent D4, D5 etc.
R...error sending from 5.5 to 2000
When a user sends from an exchange 5.5 mailbox to a user in exchange 2000,
they receive the following error:
The message was undeliverable because the recipient specified in the
recipient postal address was not known at this address
The MTS-ID of the original message is: c=US;a=
The same user on the 5.5 server can send to other users on the 2000 server.
I looked the error up in technet and got 3 kb articles with only 1, kb295377
being anything close to my problem. I checked the entr...Not allow entering repeated references in a column
If you don�t mind ... I will send it :) .
As I don�t know your e-mail, I will give mine, which is
Just send your e-mail to my e-mail box and I will send the file.
ritinha's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1566
View this thread: http://www.excelforum.com/showthread.php?threadid=27195
...create a mass of mailboxes
hi and thanks in advance for your help,
I've an exchange 2003 and I have to create a great number (3000) of account
I want to use a script to create them starting from a xls or csv file.
There are same script that create the account in a progressive way but I
can't use them.
Is there something different to use?
Try this link and refer to the section "Active Directory tools and
application programming interfaces"
"lucadb"...Creating a template using Publisher
I need help creating a neighborhood directory template using Publisher and
merging an Excel spreadsheet into it. It keeps printing multiple pages of the
first page after I merge.
What version Publisher?
If you have 2003 use the catalog merge for your directory.
Otherwise you need to setup your page as though it is labels. Determine the size
of the area you need for each entry, select labels in page setup, type the size
you determined in the page setup. Adjust the gaps and margins when you are ready
to print (2000 and bel...How do I send a welcome message to a new created mailbox automatically?
My exchnage send a message automatically but I need to change the message
where do I change it?
On Tue, 21 Jun 2005 16:35:53 -0700, "Ron" <email@example.com> wrote:
>My exchnage send a message automatically but I need to change the message
>where do I change it?
Exchange doesnt do that unless you have something scripted.
If you are referring to the welcome message in Outlook, its called
welcome.msg , but I dont think its been used since Outlook 2002.
So where would I plug in the script? Also I searched for welcome.ms...Creating a "Do_Not_Reply" e-mail address
I need to create a firstname.lastname@example.org address that any user that I give
permission to on the domain can send as by putting the above address in the
"From:" field of their Outlook client and the external recipient will
receive this and only see that it came from the do-not-reply address and not
the send on behalf of user. Also what would be the best way to block or not
receive the e-mails even if an external user does reply to it?
On Fri, 13 Apr 2007 20:56:22 -0700, "D-a-n_L" <email@example.com>
>I need to create a firstname.lastname@example.org addr...Creating a Microsoft Words document from an existing Excel spreads
I need your kind guidance on how to create a new microsoft words document
using an existing excel spreadsheet? At present, I have an excel spreadsheet,
say "data.xls" containing data for example 6 fields such as COMPANY NAME,
DATE, ITEM1, ITEM2, ITEM,3 & QUOTATION TOTAL. Under these 6 fields are some
records of my customers.
COMPANY NM DATE ITEM1 ITEM2 ITEM3 QUOTATION
---------------- ------- -------- ------- --------
ABC Limited 3 Apr xxxxx xxxxx ...Can I create sub-functions in a cross-functional flowchart?
Trying to create a template for my organization to map processes to. Goal is
to map the organization to the 'function bars' in Visio's cross-function
flowcharts. However, I would like to create some 'sub-functions' for lower
organizational elements (i.e. divisions under a department). Is this
...How to get paper size from dmPaperSize returned from GetDevMode?
For example, dmPaperSize returns 1 which is DMPAPER_LETTER, how do I
calculate the paper size like in this case 8.5"x11"?
There are so many paper sizes, is there any function call to calculate
based on the return value of dmPaperSize or mapping between the value
of dmPapersize and actual size?
The reason I asked the question was because dmPaperLength and
dmPaperWidth are 0 for some printers.
Also, my HP laserjet returns as a color printer (dmColor = 2) from
GetDevMode call. Anyone knows why?
...Publisher file made in Publisher 2007 won't open in 2007
I produced an 8.5 x 11 brochure two days ago in Publisher 2007. I was able
to save, resave and reopen the file many times during the day. When I tried
to open the file today, I get the "Publisher cannot open the file" error
message. I've tried to open the file on two different machines with
Publisher 2007 and get the error message both time. One has XP Pro, the
other has Visa Home Basic. It's a 1.6 meg file. I have a smaller publisher
file of a bumper sticker (40 kb) which was made a couple of weeks ago which
opens with no problem.
This is the second time I ha...publisher 2003 #38
Have just updated from publisher 1998 to 2003 via proffesional office 2003
and have found the "save as" function is terribly slow (as apposed to 98 ) ,
opening "my computer" is also slow ??? can any one help with this issue ??
That could be a multitude of things. And I'd even guess that most are not
> Have just updated from publisher 1998 to 2003 via proffesional office 2003
> and have found the "save as" function is terribly slow (as apposed to 98 ) ,
> opening "my c...Printing Newsletter in Publisher 2003
I have Publisher 2003 on an XP OS and trying to print a newsletter with 2
pages per tabloid size paper. I was able to do this OK with Publisher 2000.
It seems that the 2003 version does not have a "Book fold" option for the
layout. The Print Preview looks OK and shows page 6 and 1 for the layout.
For layout I choose "Booklet". What I get is page 6 and 1 on 1/2 of the
11x17 paper. Help!
Gary are you printing to a laser printer???
If you are, you are running out of printer memory.
Have a look in the properties of the printer driver, and change the settings
from Vector...Publisher 2003 & IE 8
I created a web site www.fera.org using Publisher 2003. Lately people using
IE8 do not see the menues along the left side, or the bottom. People using
Chrome are just fine. Is the a compatibility issue between IE 8 & Publisher
There is a compatibility issue with IE8 and Publisher 2003 and 2007. Any
design elements that are 'grouped' together, which includes the Publisher
wizard built navbars, do not render when you view the web page in IE8 . The
fix in general is to ungroup the elements. There is both a manual fix to
these issues and a Service Patch that has been issue...Linked graphics into a Publisher 2000 document
I have a 400KB document (withgout graphics). I insert two
JPEG images each around 200KB into the document. I figure
the resulting document should be around 700KB. Result? An
I delete the images (document is now 400KB) and instead
insert the images using the "Link to File" option.
Graphics Manager confirms that the images are linbked into
the file. The size should not be more than 500KB. Result?
An 11MB file.
Question is how can I insert images into a Publisher 2000
documentr without the file blowing up? And why does it
Richard wrot...Cannot reinstall Exchange 5.5 on Small Business Server 4.5
Our Small Business Server 4.5 crashed yesterday and could only be
started by doing a repair of Windows NT. Unfortunately, this left the
Small Business Server programs partially installed. Now, Exchange will
not start. It has the message "A connection could not be made to the
Microsoft Exchange Server". I tried to reinstall Exchange, but get the
message "This component is already installed and cannot be modified".
Microsoft Exchange does not appear under Add/Remove Programs, so I
cannot uninstall it either. Any suggestions would be greatly
obxgi...Ex5.5 to Ex2003 intra org migration
I have migrated from E5.5 to E2003 intra-Org migration and chose the option
SID migration via ADMT during migration .
I 've notice that both source domain and target domain accounts have been
added to mailbox and public folder resources which doesn't appear to be a
problem at the moment. However in the near future when I do decide to remove
the source domain would I be left with "zombie" source domain accounts???
In addition, granted that I chose to migrate SID history what will be the
result when the source Doman is remove. Will there be any performance impact
??...web preview not same as publisher view
Reading past postings it appears others too are having serious problems with
Web preview in both 2002 and 2003. I think the problem is that text handling
within text boxes in normal Publisher view simply does not reflect that as
seen in Web Preview (currently Explorer 6) On a totally blank (wide setting)
webpage, using standard Times New Roman 12pont (no italic underline or bold)
I typed six lines of Mary had a little lamb into a 3.85x3.029cm text box with
all margins set to 00. I outlined the box with a 1/4pt line Whereas the
text just fitted into the box in Publisher view, in Web ...Replication partner exch 5.5 crashed
We recently installed exchange server 2003, had it coexisting with exchange
5.5 . We used the pfmigrate tool to create replication of public folders,I
had also moved around 75% of the users mail boxes to the 2003
server.Unfortunately Ifound out that the exchange 5.5 server has crashed and
now we cannot send or receive emails because earlier the mail flow was from
2003 to 5.5 and internet and vice versa.
How can I remove the 5.5 server and set the 2003 server to receive emails
Also I do have a backup of the 5.5 server , can I restore the 5.5 mail box
to t...New Named Range Created Each Time Data Imported into Excel via Macro
I have noticed that each time I import data into an Excel spreadsheet
via a macro, a new named range (for the same range) is created. This
does not pose a problem, but after a while, I'll have a huge number of
named ranges that will never be used. Why does Excel name the range
and how can I stop this? I noticed in the recorded macro, there was a
line .Name = "drd_5". I commented this out to see what would happen,
but it just renamed the range "ExternalData_5". The next one was
You could refresh with differen...Creating a worksheet in Spanish
Is there a way to create a worksheet on MS XP Pro running
Office 2003 Pro all in Spanish?
All valid formulas -except the ones from the Analysis Toolpack- will
automatically translate to the language of the Excel it's opened in. So any
spanish speaking Excel will translate formulas to spanish, no matter which
version it was written in.
The rest, text constants and such, has to be typed or pasted. Excel will not
translate this herself.
HTH. Best wishes Harald
"Kent" <Kent@discussions.microsoft.com> skrev i melding
news:ACCCBA3A-53B4...5 steps to create a publication,the workplan
I need to know at least 5 steps to creating a workplan in pulisher.
1- turn on computer
2- open Publisher
3- File | New
4- File | Page Setup
5- Design your thing
6- File | Save your thing
oops thats 6
"thinking" <email@example.com> wrote in message
|I need to know at least 5 steps to creating a workplan in pulisher.
This newsgroup is dedicated to solving problems with MS Office Publisher.
Not doing your class assignment.
"thinking" <firstname.lastname@example.org...Publisher 2000? #2
Is there a place where I can still get version 2000? I've been looking, but
all I can find are updates and the 2007 trial. My computer can't run 2007.
*If* if can be had, try something like eBay. (I wouldn't buy software that
way but that's just my preference.) You may find you have better luck
finding a leftover copy of Pub 2003 from some online retailers. (I actually
prefer that over 2000.)
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"Jason" <Jason@discussions.microsoft.com> wrote in me...