I have information in a text delimited file. It is names
and addresses. I need to get it into excel or access so I
can make labels -- can someone help me with this?
Excel can open it directly. In the File - Open dialog, change the file type
to txt . If your file has the .txt extension, the import wizard will start
automatically. Tell it it's delimited, that the field delimiters are
commas. If you're not sure about that stuff, open the file in Notepad and
check it there.
mvpearl omitthisword at verizon period net
--...Re: Extracting Exchange User Data From AD 02-24-10
If you do not like scripting, you can try GAL Exporter or Fast User
Manager & Reports from IMIBO - http://www.imibo.com
> "Ringholz, Blake" <email@example.com> wrote in message
>> Hello All -
>> I need to get an Excel Spreadsheet that lists everyone first name, last
>> name, email address, job title, etc pulled from Active Directory. Is
>> there an easy way to do this?
...Adding/updating totals from one worksheet to another
I have created several worksheets within one file. I
have a summary worksheet and multiple detail worksheets.
When I update the detail worksheet I want the totals to
be updated in the summary worksheet. How do I do this?
Thanks for your help.
Ila, something like this in your detail sheet ='Detail Sheet 1'!A1, and
easy way to do this is to click in your summary sheet where you want the
total from one of your detail sheets and put = then click on the detail
sheet and click on the cell you want and press enter
Always backup your data before trying something new
...import comma delimiter, outlook says funtionality needs to be inst
I have office XP standard for students and teachers which includes outlook.
Outlook was installed years ago using these disks. Now I'm trying to import
a comma delimited file to outlook using the import/export wizard. When I
select import from "comma separated values" I receive a message that the
feature is not currently installed. When I say to install it the outlook
translator starts and asks for the Microsoft Outlook 2002 disc. Microsoft is
looking for the installation package OUTRET.MSI . I looked at all the
folders but this folder is not on any of the 3 di...Adding 'Dial-Phone' Button
I have a client that wants to add a Dial Phone button to
the contacts screen. I have several questions. Can this
be done? Can this be done with the current demo version?
Where would I even begin to add something like this?
You need to start reading the CRM sdk to understand how to add or modify any
For example, you could add a button to the CRM contact form which when
clicked calls the phone number of the contact.
search on msdn.microsoft.com for Microsoft CRM
"BJF" <firstname.lastname@example.org> wrote in message
news:0f2501c3a9f9$5b6ae9b0$a301280a@p...Missing Exchange tabs in AD #2
I installed exchange 2003 in a DC. I know this is not the most secured
way but we want it that way. I also installed the Management tools in
the same server. However i dont see the exchange tabs in AD and all i
see in Exchange task is "Remove Exchange attributes". I tried
reinstalling management tools but still didn't work.
email@example.com <firstname.lastname@example.org> typed:
> I installed exchange 2003 in a DC. I know this is not the most secured
>...cell to have comma-delimited values based on text
I have a table called "220_reference" with a column name "Part Number" having
a sample value of below:
4047122(All Dash no.), 4057222(All Dash no.), 4058222(All Dash no.),
4060122(All Dash no.)
The entire value is in one cell representing the "Part Number"
column(defined as general type so text I suppose).
Simple enough. But what I need to do is take any number that has "(All Dash
no.)" after it and search through a column in another table to retrieve any
rows that have that number(text) in it. The other table name is "220" with ...Clone an appointment to a new date
I am trying to clone an appointment to another date, is there an easy way to
do this other than copy and paste each individual part?
Select the appointment in Day/Week/Month view (press Esc if you go into edit
mode) copy (Ctrl+C) , then paste (Ctrl+V) on the new date.
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com/
Outlook Tips by email:
EMO - a weekly newsletter about Outlook and Exchange:
mailto:EMO-NEWSLETTER-SUBSCRIBE-...help with adding rows
Im using http://www.rondebruin.nl/mail/folder3/row.htm.
To mail all the rows on sheet1 row by row. I need to add all th
numbers in each row before it is sent,
so the the numbers in the row are all sent and the last cell is th
total some thing like this
test1 test2 test3 test4 test5 test6 Sum
1 1 1 1 1 1 6
There is 14 test total so it will be a lot longer line then this als
im looking to add a msg to the end depending on the out come of the su
94 to 100 you got an A ....congrats
87 to 93 you got a B ....good work
81 to 92 you got a C .... may...Adding a column if two ranges match
A B C D
1 Participant Volume Group 1 Group 2
2 name 1 3 name 3 name4
3 name 2 4 name 5 name 20
4 name 3 1 name 6 name 150
5 name ...
I am attempting to add coulmn B based on which group the participants are
I have a master list of the tot...configuring publlic folder appointment items
Is it possible to configure a public folder that contains appointment
items so that entries cannot overlap?
i.e. I want to use a public folder for the booking out of a meeting
room and if I tick the box for "All Day Event" then I would like it so
no one can make another entry for that day - or if some one books it 9
to 11 then no one else should be able to book it for the same time
am I making sense?
No, that's one of the limitations of using a pf as a resource, can't
automatically decline, no free busy etc.
James Chong (MVP)
MCSE | M+, S+, MCTS, Security+
msexch...adding holidays to calendar
I seem to be able to add holidays for the current year to my calendar using
Tools/Options/ Calendar Options - but how can I add holidays for NEXT year
(and subsequent years?) Even if I select a date in 2008 before adding the
holidays, it simply puts them in this year again so I have two copies in
2007 but none in 2008. Can you offer a solution please - I'm sure it must
be a simple thing I'm not seeing...
Outlook 2003 SP2
Just make the current year a recurring event.
"Jeff" <email@example.com> wrote in message
news:M9adnV3vsPV6LrHbRVnyjwA@eclipse.net.u...how to direct keyboard input to a CWnd added to CDialog? #2
I have added a CWnd object to a CDialog for the purposes of drawing inside
the CDialog. I would like the CWnd object to respond to keyboard input.
Any input not handled by CWnd should then be handled by CDialog. Can anyone
explain/illustrate how this is done?
Thanks for all suggestions and help.
...text is deleted from delimited file?
I am using Excel to build CSV files for MySQL database population. I am
running into an intermittant problem with text being deleted when I
reopen the file in Excel and when I import the file into MySQL. If I
open the the text file with notepad, the text is still there. I have a
file with 100+ rows and it only happens on a few of the rows. It's not
happening in the same character space on each row. Any ideas?
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/
I ...Web Amin for Mailboxes and AD Accounts
We are looking for a tool supporting our users(customers) in maintaining their Mailboxes and AD Accounts via a web browser ?
Does anybody know or has experience with a product called hostedExpress ???
many thanks for any recommendations
EggHeadCafe.com - .NET Developer Portal of Choice
You could try using Citrix, with published application mode -> AD
users and computers. Then with webportal people could login, with that
added benefit of their windows logon having the relevent permissions
for specific OUs and delegation.
A bit expensive though ;)
geor...Formula for adding Columns #2
Please help ...I'm going mad... How do I enter a formula to add colums
Thanks in advance
Your problem is not clear... pl. provide more information with sample data.
If you want to add A1, B1, C1 in D1 then use
=A1+B1+C1 in D1
> Please help ...I'm going mad... How do I enter a formula to add colums
> Thanks in advance
Do you want to SUM them then add them or just add rows across?, can you
explain a little more?
> Please help ...I'm going mad... How do I enter a formula to add colums
> ...Tab Delimited
I'm trying to add products using the Import Data tools but at the bottom of the page I get the following message
Your spreadsheet (data file) needs to be saved in the “Tab Delimited” format prior to importing your data
Can someone explain what I'm supposed to do (in Idiots language) because I don't have a clue what to do.
Go to the FILE menu, choose SAVE AS. At the bottom of the dialog box that pops up there is a white box that says: Microsoft Excel Workbook (*.xls). The box is labeled Save as type: Click on the down arrowhead at the right side of the white b...Adding Superscript Text to a Distribution List Name
We have a user who would like to add superscript text to a distribution
list name. He is currently calling it (BC)2, but he would like the 2
to be superscript and would like to get rid of the parenthesis. I
didn't think this was possible since you really can't put html in the
title, but he swears he has seen this before. Anyone have any ideas?
It's not possible.=20
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
and Microsoft Outlook Programming - Jumpstart for=20
Administrators, ...adding barcodes
is there someway to print a barcode on a form from a number located in a
particular cell on a form to another cell?
Yes, and in anticipation of one more question, it is done with fonts,
and there are different kinds of barcodes. You will find some links
on my Mail Merge page
You should be able to obtain free fonts without difficulty, or
if you prefer you can pay for them, the choice is entirely up to you.
I find it hard to believe that coding a lined barcode font from a
specification is difficult.
David McRitchie, Micros...adding Dll in MFC
im new in vc++ using mfc .. what i want to do is
add a .dll file into my project .. and accessing its
contents.. (just like in vb6 where you can add. reference .. ex: Test.dll)
and declare WithEvents.
thanks in Advance,
You need the dll's .lib and .h files to use the DLL properly and easily.
In vb6, the dlls you're using probably have TLB which are equivalent to .lib
and .h of c++
"gio lavilla" <firstname.lastname@example.org> wrote in message
> hello ..
> im new in vc++ using mfc .. w...[CRM 1.2] forget remove CRM licence before remove user in AD
I use CRM 1.2 and i have forgot to remove licence in crm before delete user
in Active directory.
Now, when i try to remove the licence, i have the error message
object not found
Check the object in same time in active directory and in database.
How can i do to use this licence with another user ?
I find the table (SystemUserLicenses), but i don't know if i can delete the
row directly in this table ?
Thanks for your help.
...Adding Excel Sheets
Hi, ive just registered and hoping for some help please. I am making up
rotas for work on excel and need to add sheets at the bottom (one for
each week and so on). How do i get the sheets to become automatically
filled each time i open a new sheet, hence saving me to copy and paste
Thanks in advance
...Buttons added on parent window
I downloaded an application a few days ago, and noticed that it has put
buttons on the parent window (next to the minimize, maximize and close
buttons) on explorer, Word and a few other windows. This looks nice and
I was wondering how it was achieved - overwriting a dll, for instance?
I believe it involves a hook, but I am not 100% sure.
<email@example.com> wrote in message
> Hi all,
> I downloaded an application a few days ago, and noticed that it has put
> buttons on the parent wi...MSG: No more new fonts may be added to this workbook
I get the above message while I'm working with my excel
2002 file. It's a big file with lots of charts. When I
copy and paste a chart I get the above message and the
program locks (although I can usually save and re-open).
But I don't understand what this message means. Can
anyone help? I'm not too fussy about formatting and have
tried clearing formats etc. but it only buys me a couple
more charts to add.
As answered in .charting --
Jon Peltier has some information on this in his Charting FAQ article:
Operating System: Mac OS X 10.5 (Leopard)
I have a big problem, my word 2008 (Student ed.) is crashing (hang) consistently when I add a footnote to a document. Is there any fix? Does anyone is experiencing the same behaviour?
Crash log is not very helpful...
Date/Time: 2008-03-13 18:35:53 +0100
OS Version: 10.5.2 (Build 9C31)
Report Version: 4
Path: /Applications/Office/Microsoft Office 2008/Microsoft Word.app/Contents/MacOS/Microsoft Word
Version: 12.0.1 (12.0.1)
Build Version: 0
Project Name: (null)
Source Version: 80305