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?
...Access attachments don't work anymore
Outlook 2000's security update makes it impossible to
receive MS Access .mdb or .mde files. But I need to do
this to earn a living as an Access developer! Other than
have the sender rename the file there must be a simpler
way to override the security patch. Outlook Express let's
you turn off this feature but OL 2000 has no such setting.
(The feature is basically worthless anyway - any hacker
would know you just rename the file, put your hacker code
in it and send it. Access will open ANY file, regardless
of what you name it!!)
See if the information on the following page help...Converting XLS file to QIF or to OFX
How do I safely and securely convert an excel file (xls) to a QIF or OFX file?
> How do I safely and securely convert an excel file (xls) to a QIF or OFX file?
In Excel, save the file to CSV and ustilise iCreateOFX Basic from:
to convert the saved CSV file to OFX.
Have several spreadsheet files I use routinely. Three have recently
crashed after I added another sheet. In each case the document
recovery created a file missing all the color and text formats that
the file contained before the crash. Not sure what other changes may
Is there something wrong with the copy of Excel on my PC?
Could these three files be corrupt?
Is there a procedure to "clean-up" these files?
Thanks in advance for any suggestions.
sounds like they are corrupted. I would suggest to copy the data +
formats to a new, 'fresh' workbook.
...Unable to forward attachments
I'm having problems sending (forward) an attachment with Outlook.
I can send an attachment if I send a fresh email but when I forward an email
that contains an attachment the recipient doesn't get the attachment. My
sent items folder shows the attachment was sent.
I'm using WinXP and Office XP. I've tried disabling Norton anti virus but
that didn't help.
I've searched Google and the Outlook newsgroup and found a lot of people
with the same or similar problems but so far I've been unable to find any
type of fix.
Does anybody have any ideas were to look for more inf...adding a leading 0 to only the numbers with 4 digits
I'm converting a bunch of data and during the import Excel dropped the
leading zero from all the lip codes. Since this is about 15,000
records, I'd like a way to add a leading zero to only the zip codes
with 4 characters. Any ideas?
"SwampYankee" <firstname.lastname@example.org> wrote in message
> I'm converting a bunch of data and during the import Excel dropped the
> leading zero from all the lip codes. Since this is about 15,000
> records, I&...conversion lotus 123 files to excel -- problem
I am converting lotus123 files to excel2002. One problem is that in lotus, literals are ignored when found in a cell within a formula. Excel on the other hand is not doing this and therefore causing #value errors on all the formulas where this occurs. Is there a way to handle this in excel other than manually having to change all the formulas?
...How do I get excel files to open automatically from directories?
When I try to open excel files from the directory or from desktop I only get
a blank worksheet not the file. I have to then go through File Open to get
the file I want.
There must be a way to have them open automatically.
On Mon, 2 Jan 2006 21:22:01 -0800, Damian
>When I try to open excel files from the directory or from desktop I only get
>a blank worksheet not the file. I have to then go through File Open to get
>the file I want.
>There must be a way to have them open automatically.
Go to Tools -> Options -> Gen...Adding attachments to email merges
I am trying to create an email merge in Outlook, with a PDF attachment.
It all works ok, and the message sends but the attaachment is always
stripped off the message - I have tried different files and the attachement
never comes through, or even gets mentioned in the received message.
What am I doing wrong?
Any suggestions gratefully received.
Not supported. You'd need to use third party software for that.
"m.nutt1" <email@example.com> wrote in message
news:%23qnq...Advanced mail merge/distribution/attachment ?s
Hey - questions.
1 - I already know how to do mail merges and email
distribution lists in Office, but if we don't want each
client on our distribution list to see the names/addys of
all everyone else on the list (we usually mail to blind
cc for this) is there STILL a way to have each client's
name show up in the email (preferably in the address or
subject header lines, if not in the message?
2 - Does anyone know how to take an attachment and add it
in to an email message/embed it for viewing a la HTML,
rather than just attaching it?
Any help would be appreciated,
1) ...Outlook 2002 multiple file opening
In Outlook 2000, CTRL A would select all attached picture
files, then Open would, in my case, open the files in
With the 2002 version I cannot find a way to do this.
...getting added to other peoples meetings in shared calendar
I opened shared calendars in my group by choosing their name and then the
email messages went out giving them access to my calendar and requesting to
view theirs. Ever since, I have been copied in as a "required attendee" on
all meetings for everyone. I get the calendar items on my calendar and
emails requesting Accept or Decline in my inbox. When others view view thru
their outlook, they do not see me as a required attendee? What am I doing
are you adding them as delegates or just giving them permission to view the
calendar (by right clicking on the calendar fold...Odd problem with worksheets when opening file
Okay, here's the odd problem that's come up.
When you double click on a excel file, excel opens up, but you can onl
see the toolbars. The grid area looks like a snapshot of whatever you
current background is before the file opened up. If you were showin
your desktop, after the excel file opened, you'd still see your deskto
in the datagrid area.
If you start up a new excel file, then do the File>Open>file name, th
file will open correctly.
This problem happens across users here. Everyone is currently runnin
Any ideas on what causes the problem and any..."File: send to mail recipient" not working
When users (on WinXP) select file, "send to mail
recipient", no response from Outlook 2002. This occurs
either when Outlook is open or closed. Problem happens
when rt. clicking on .doc, .xls, .pdf's....all files.
...Adding Members- Dist. Lists
Not sure if I should be posting this here or in the SBS group. Does anyone
know if there is a way to assign a permission to a user in our office to be
able to update membership lists for distribution groups while she is in
Outlook? Currently, when she clicks the "To:" button in a new email,
right-clicks the distribution group, selects properties, goes to "modify
members", it lets her select the new member but then when she clicks ok she
will get an error mssg saying she doesn't have permission to do this.
on the security tab of the DL, does she have the &qu...Subform doesn't work once added to main form
I've been searching around looking for some help and can't find anyone
that has had quite the same problem.
I have a main form called 'Sites' and have added a subform called
'Previous Year Flows' into the main form. I do not enter data into
this subform. Instead, data on previous years is drawn through from a
table called prev yr flows into this subform. When I open the subform
on its own it draws through all the necessary data, but when it is
embedded within the main form, none of the actual data is pulled
through at all, although the linked fields, Site ID and A...odd files created
Every time I open and edit an excel spreadsheet on a
network share, small odd files get created. They are
usually no larger than 25-40k and don't have any
extensions to them. Looking at the properties page for
any file, the file description says File. Anyone know
what this is from or how to get rid of them? Permissions
are setup correctly for me, Word files don't have this
Excel 2000 SP3
A file the same size as the workbook would be created
in the same directory as the workbook. The filename
would be nonsensical (or appear to be random) character...adding date/time picker to inputbox control
Hi all,is there a way to add a date/time picker control to inputbox?...Change default "SaveAs" to *.msg rather than *.html
Using Outlook 03, I regularly need to save emails and prefer to save as
*.msg so the attachments are contained within the one file.
How can you change the default SaveAs command to Save as Type in a *.msg
format (rather than *.html) so the type is already *.msg without having to
use the pull down?
Outlook provides no way to change that.
Sue Mosher, Outlook MVP
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
"TroyB" <firstname.lastname@example.org>...Ad Hoc Reporting #2
I am putting together an ad hoc report in Excel. My query is in the VB
editor. I am trying to specify criteria
Select x,y,z where...
in the WHERE, I am struggling.
I want to take a range of ids specified in the worksheet, F2:F55.
Select x, y, z where IDs IN ( F2:F55 )
I tried to use WHERE IN ( Range(F2:F55) ) but it did not like it.
What syntax should I use to make this work? Thanks!
...Excel Template Wizard, Very Large File Size
Background: Excel 2000. I created a spreadsheet and used
the template wizard that links to an Access 2000 database.
The template was later used to create one record and saved
as a spreadsheet. The database also contains this one
record. Spreadsheet and database work fine. Later I
reduced the Access field size properties (none are larger
than 150, most are less than 50). There are 35 fields.
Unexpected result: The Excel spreadsheet (template) and
the linked Access database are huge. The spreadsheet is
35MB and the associated Access 2000 database is 24MB. Each
contains one record (a si...adding supplier to items in PO
When you manually add items to a PO and then select the supplier in the
header the items should be added to the items that the supplier carries if
they aren't already. This would save loads of time adding suppliers to items.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the ...Date & Time file was last saved
Is there away to display in a cell the date & time the file was last saved?
I know you can do this in word but is it possible in Excel 2002?
Here is an UDF
Function DocProps(prop As String)
On Error GoTo err_value
DocProps = ActiveWorkbook.BuiltinDocumentProperties(prop)
DocProps = CVErr(xlErrValue)
Now you can use the following formula in one of your cells:
=DocProps("Last save time")
Obviously, the file has to have been saved.
... looking out across Poole Harbour to ...Outlook Level 1 Attachment Security
How do you disable Outlook 2002 Level 1 Security for
Take a look here, it may help:
"Gerry" <Kandels@bigpond.com> wrote in message
> How do you disable Outlook 2002 Level 1 Security for
Check out http://www.slipstick.com/outlook/esecup/getexe.htm
"Gerry" <Kandels@bigpond.com> wrote in message
> How do you disable Outlook 2002 Level...Attachment security in Outlook 2003 #2
I had the same problem. I downloaded DetachOL form the link below and
it fixed all my problems. You can choose different levels of
security. Hope this helps