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...outlook contact view
Normally while viewing inbox window in the left hand lower
area I have a contacts list. Somehow it got deleted from
view and I cannot find where to open it again.
thanks for the help
You must be using Outlook Express, as Outlook does not have this option. In
Outlook Express, go to View | Layout and check the Contacts box.
For future reference, please note that this newsgroup is for support of
Outlook 97/98/2000/2002/2003 from the Office suite of products. Outlook
Express is actually a separate program despite the similar name.
For help with your OE questions, try an OE newsgroup such as...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...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"...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
&...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" <firstname.lastname@example.org> 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 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...Creating a "Do_Not_Reply" e-mail address
I need to create a email@example.com 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" <firstname.lastname@example.org>
>I need to create a email@example.com 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 ...Subform in Datasheet View
Is there a way to have the datasheet view of a subform *not*
show the "button-like" row that shows the field names?
No there isn't. If you create a continuous style form, you can eliminate
the headings. You can modify a continuous form so that it looks like a
Microsoft Access MVP
"tbl" <hateThatSpam@invalid.net> wrote in message
> Is there a way to have the datasheet view of a subform *not*
> show the "button-like" row that shows the field n...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
...Tr again: Modifying Calendar's "reading" view in 2003
In Outlook 2003, Calendar allows me to show the event's content in a
"Reading" pane at the right or bottom of the calendar. But the layout of
the Reading pane wastes a lot of space. Can its layout or content be
No, the content can't be modified.
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 Solutions Center: http://www.slipstick.com...Can I set my custom views on Pivot table
I want to get Pivot table data on my invoice, is it possible to set custom
views so that I can get Pivot table results on invoice format, I've tried
views that offer excel but it doesn't offer custom views
...Contact looses Post Office Box field when synchronized to Outlook
When I sync contacts from CRM 4.0 to Outlook, the Post Office Box field from
the contact gets empty.
Anyone has the same issue?
...How do I view all Global Catalog Servers in Active Directory
Is there a way to view and confirm all the Global Catalog Servers in Active
Directory? I'll appreciate your help.Regards.
On Sat, 6 Aug 2005 08:21:01 -0700, "Buchi"
>Is there a way to view and confirm all the Global Catalog Servers in Active
>Directory? I'll appreciate your help.Regards.
You could in the DNS (dnsmgmt.msc) under the _msdcs folder for your AD
domain. or nslookup (ls -t SRV ADdomain.com) or look via Sites and
Services or use repadmin: (repadmin /showreps YourDC). The result wi...How to view the same email message at the different PC users
My husband & I use the same PC(Windows XP) but have an
individual user accounts. We have several email addresses
for individual usages and shared usages and all enable to
receive and view by Outlook 2000 inbox. We have noticed
that the emails came in while I'm on Outlook (or
minimized at the bottom) can not view when my husband
goes to his Window user and open the Outlook. And vise
versa. We want to be able to look at all emails that came
into the Outlook inbox at both Window user's Outlook
inboxes. How can we do that?
...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 ...hacked contacts
I ahve had this before but it happened again yesterday,for some reason an
email was sent to all my contacts within windows live mail from my mail
account.This email was an http web address,which when copy and pasted sends
out the virus within their mail accounts.Thankfully my contacts deleted
it.How can i stop this happening.
I have since changed my password in case the account is hacked.
On Fri, 9 Jul 2010 02:53:26 -0700, coltmanneil wrote:
> I ahve had this before but it happened again yesterday,for some reason an
> email was sent to all my contacts w...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" <firstname.lastname@example.org> 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" <email@example.com...Delegates cannot add contacts?
I've created an OU for external email addresses, shared
across the company. Within that OU, I've created a nested OU for
specific delegation. I've delegated management of the OU to a
specific contract manager.
My dilemma? From what I've been able to determine, no one except
an Exchange admin can create new contacts.
I've installed the Exchange admin/management tools on the appropriate
Is the problem that you have delegated permissions within AD and are no
"Mike" <newsgroups@manco...Rule to automatically mark header to download based on contact list?
Is there a way to do this, or an add-in?
On Tue, 26 Apr 2005 04:44:35 -1000, rmc <firstname.lastname@example.org> wrote:
> Is there a way to do this, or an add-in?
What version of Outlook are you using?
Ben M. Schorr, MVP
"Ben M. Schorr - MVP" <email@example.com> wrote in message
> On Tue, 26 Apr 2005 04:44:35 -1000, rmc <firstname.lastname@example.org> wrote:
> > Is there a way to do this, or an add-in?
> What version of Outlook are you using?
>...tasks entered in taskpad don't appear in task folder
All of the tasks that I have entered via the taskpad do not appear in
the task folder, what am I doing wrong or do I have the wrong
What view are you using on your Tasks folder?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.
"John Keith" <email@example.com> wrote in message =
| All of the tasks that I have...Creating PDF files in MFC
I want to create PDF files in MFC. Does anyone know how should I do
Thanks in advance.
Check out the following
> I want to create PDF files in MFC. Does anyone know how should I do
> Thanks in advance.
Here's another to try out:
"Shahoo" <firstname.lastname@example.org> wrote in message
> I want to create PDF files in MFC. Does anyone know how should I do
> Thanks in advanc...