Exchange Migration Wizard and creating new SMTP reply addresses
I'm migrating from a Netware 6.5 environment, but am going to be using
another tool because of the need to migrate archives and personal address
books. I would, however, like to use the Microsoft tool to populate the
GWISE SMTP address with the old GroupWise address. Is there a way to run
the Exchange Migration Wizard in a mode that will only create the additional
GWISE SMTP addresses for all of my users?
...Re: Outlook 2007 create background
I played around with this further. You can still use any HTML editor to =
create stationery and place it in the user's Stationery folder. You can =
also use FrontPage 2003 to create new themes with background images. =
Details at =
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
and Microsoft Outlook Programming - Jumpstart for=20
Administrators, Power Users, and Developers
=...learning access 01-31-08
Inform me a reliable interactive source to learn microsoft access
On Thu, 31 Jan 2008 13:58:36 +0530, "Manas Ranjan Nayak"
>Inform me a reliable interactive source to learn microsoft access
Here's some places to look:
Jeff Conrad's resources page:
The Access Web resources page:
A free tutorial written by Crystal (MS Access MVP):
MVP Allen Browne's tutorials:
http://allenbrowne.co...Outlook 2000 Starts with Information Box
On some computers running NT4 and Exchange 5.5 with XP pro
Clients A message box appears about macros added to
additional files, why does this box appear? and how do I
stop it from appearing every time I sart Outlook 2000?
Please state the full error you get. You can control macro's in Outlook by
Tools-> Macro-> Security
Microsoft Office and Microsoft Office related News
Also Outlook FAQ, How To's, Downloads and more...
Tips of the month:
-Create your own fully customized Toolbar
-Creating a Classic View in Outlook 2003
Subscribe to the new...storing multiple list selections in access
i have 2 tables, table a and table b. is it possibile for a control
bound to table a (a list box, with multiple selections eneabled) to be
able to select multiple records from table b, and store them?
i.e. table A record 1 has table B records 1,2,3,4,8,12, and so on
while Table A record 2 only has table B records 3, 8 and 15 selected,
and so on..
is there some way to store those selections within table A?
for those curious, i'm making a character sheet for an RPG.. table A
is the actual sheet, while B is the list of spells.. i'm looking for a
way to store which spells each ...Combo Box from data in another tab
Is it possible to create a combo box from data that's in another tab?
I have a combo box that's from data in hidden columns. But now I need to move
all that hidden data to another tab in the same file. But when I go into
properties and go to the ListFillRange option, it won't let me enter another
Message posted via OfficeKB.com
I have called data from another tab with a combo box by doing th
First - name the range of the data on the other tab. This can be don
with the shortcut on the toolbar (l...Adding a new data series to an existing chart
I have a stacked bar chart that shows monthly sales by customer type. I want to add an additional data series to show the monthly forecast, to be displayed as a point or line against the existing stacked-bar data. Any ideas?
Select the data you want to plot. Drag onto the chart. XL will pop up
with a dialog box asking for some information. Provide it and you will
be all set.
MS MVP Excel 2000-2004
Excel, PowerPoint, and VBA tutorials and add-ins
Custom Productivity Solutions leveraging MS Office
In article <1418C2D7-4DF6-4945-A08A...Password on access
I'm working on a database that has a few tables that everyone can access. I
want to give permision to other people to see them but not to change any of
I have tried to make users and administrators but it seems to work in only
Does someone know how to do this?
Thank u very much!!!
On Tue, 18 Mar 2008 07:34:02 -0700, Yael <Yael@discussions.microsoft.com>
>I'm working on a database that has a few tables that everyone can access. I
>want to give permision to other people to see them but not to change any of
&...Promoting and Outlook Email and Creating Contact
After reading an Email in Outlook I promote it to CRM. The author of the
Email is not a CRM contact so their name appears in red. Clicking on the
authors name, CRM gives the option of reconciling to another contact or
creating a new contact record. When I select a new contact record, why
doesn't CRM populate the name and Email address just like when you create a
contact from an Email in Outlook? Why should I have to go back and look up
the Email address from the Email itself to place in the CRM Contact record?
I'd post that as a suggestion for future product enhancements. Ho...Excel 2000
*First off:* I have created a spreadsheet that has a dynamic range an
*Next:* i know i can add options to the 'dynamic range' and my dro
down menu will add the option to its list.
*Problem:* How can I make it so the user can add data into th
validated data list/drop down menu rather than having the user addin
it into the dynamic range?
*Example:*this drop down menu indicates how often a system is updated
weekly, monthly, etc. etc... i don't want to restrict it, so i want t
make it so they can indicate their own time on how often those update
-...how do i turn on overtype in microsoft access
how do i turn on overtype in microsoft access
Press the 'Insert' key once.
Build a little, test a little.
"Mandolin Man" wrote:
> how do i turn on overtype in microsoft access
Push the Insert Key on your keyboard.
If you want to do it in code, the key constant is vbKeyInsert
Arvin Meyer, MCP, MVP
"Mandolin Man" <MandolinMan@discussions.microsoft.com> wrote in message
> how do i turn ...Updating all Fields in Word Document
I need to update all fields in the Word document.
I have some of the fields in drawing canvas too.
I have tried this, which works fine, but except drawing canvas.
Windows Vista Business SP2, Office 2007 SP 2
Dim oStory As Range
For Each oStory In ActiveDocument.StoryRanges
If oStory.StoryType <> wdMainTextStory Then
While Not (oStory.NextStoryRange Is Nothing)
Set oStory = oStory.NextStoryRange
...Data within a cell
If names are in cells as "last name, first name, middle initial" can a macro
be run to change the order to "first name, middle initial, last name"?
A formula will do
Assuming you have spaces between commas and names,
Then just copy down. If you want this more permanent, copy the cells with
formulas, right click, paste special.
*Remember to click &q...How do I make the x axis data the y axis data?
My graph automatically makes certain data the y axis and other data the x
axis. I need to just reverse it for the graph I am looking for. Any
One option is to reverse the positions of the data on the spreadsheet.
Assuming an XY chart, you would change a setup like this:
If this doesn't work, can you post back to let us know what type of chart
and data you're using?
> My graph automatically makes certain data the y axis ...Data entered from list automatically enters number in another cell
I am using Excel 2007 and here is an simplified example of what I need.
Items Column is List for Valid entries in table below
Prices are the numbers I want entered when I enter the Item
If I enter Oranges from Dropdown List in A16 , I want Excel to automatically
enter the number 7.95 3 columns over in D16,or if it is quite a bit easier,
just 1 column over in cell B16
Example of table I want:
My Entries: Excel Enters
...Outlook 2000 and Win XP
I have a Laptop with Windows XP Professional and Outlook
2000 SP-3. About 3-4 times a day the user cannot open the
GAL. I have to delete and then reconfigure the profile. At
which time the GAL works for another couple of hours. Do
you know of any issues.
...converting plain data to table format
It has been a while since I used excel but I am almost sure there is a way to convert just plain rows and columns of data into a table format. This way I believe that adding rows to this block of data is as simple as tabbing after the last cell and it should just drop down to the next row and insert one??? correct??
Excel should recognize a contiguous range as a table, or list. Include
headings in the first row, and leave at least one blank row and column
between the table and other items on the worksheet.
You can use the built-in data form to add records to the table
(Data>Form). Or,...recieving reminders since re load of exchange 2000
I have recently done a reinstall of exchange 2000 using setup and selecting
reinstall all components. Before doing this I did an offline backup of
After reinstall moved backed up mdbdata back.
All is working okay all emails and public folders are as before. However a
few users are complaining that they are recieving reminders from months ago.
Any ideas all I can see is the outlook.exe /cleanreminders
to fix it.
...Data Migration Framework 08-04-04
I am not understanding something pretty fundamental regarding the Data
Migration Framework (DMF). I am looking to migrate a limited number of
records (approx 1K) from Goldmine into MS CRM as Account records.
I understand that the DTS in SQL can be used to load the data into the
CDF database. On page 73 of the Data Migration Framework Guide (v1.2)
it states that you use the Goldmine export utility to extract data
from Goldmine. However, how do you use DTS to load this data into the
CDF database as Goldmine exports it into Excel?
Also, using the export facility in Goldmine you can only e...SP3 Problem
Ever since I installed SP3 for Office XP, I have been
getting the following error - "A program is trying to
access email addresses you have stored in Outlook. Do you
want to allow this?"
I get this error only when I use Word as my email editor.
Hence what is happening is that Outlook thinks that Word
is a rogue program trying to send unauthorized emails.
My question is, is there a way to prevent this - a
whitelist of programs for example?
Disable the PDFMaker addin. (See
http://www.slipstick.com/outlook/ol2002sp3.htm#problems for details on how
to do this.)
"Aj...Exchange Email Router CRM Server 2003 & Exchange 2000
I´ve installed CRM1.2 on Win Server 2003 - everythings OK - afterwards I
installed the Email Router and followed the steps in IG.
The problem now is that I could send mails but incoming mails are not in
support queue or in CRM system anyway (answers to a crm mail guid included!)
Is it possible to use Server 2003 and Exchange 2000?
Thanks and Regards,
Yes, they are supported. Where are you sending those messages from? The router
will only capture mail that comes in via the SMTP gateway, so it must come from
MVP - Microsoft CRM
------...Prevent auto recoloring of chart when using Pivot Table data
I have crated a Pivot tabel with data I want to show in a Chart. My problem
is when I refresh data the colours of the "data series" changes.
For exaple I want one of my series "OK" always be shown in green colour, but
after a refresh of pivot all colours changes.
This problem is not only colouring. If I have made changes to my chart so
that one series ar plotted on a secondary axis, and I change it to another
chart type (e.g. the secondary should be shown as a line instead of column)
this also changes when refreshing the data. Most irritating!
Anyone that knows how to p...saving Word document to os x server
I have noticed some strange behaviour while save Word 2004 documents to
our os x (10.2.8) server. When I open the Word 2004 document and make a
change, then save it, it takes forever to save the document (by forever
I mean 2-3 times longer than with Word vX).
I keep the document open, make another change, then save again, and it
takes not so long to save the document (somewhat faster than Word vX).
Again making a change, then saving, and faster saving continues until I
save and close. If I then re-open the document and save it, it again
takes forever to save.
In short: after opening ...Excel or Access?
I have server data that is about 200-300 rows/records and includes abou
25 columns/fields. Coworkers have suggested that this data shoul
reside in a database, such as Access, and then import/link to it fro
Excel for reporting purposes.
Does anyone have a recommendation/comment/suggestion on this? I a
comfortable using Excel as my "database" for this data that will no
grow much larger than it already is, and is easier for me to perfor
the reporting in Excel simply on another sheet.
Message posted from http://www.ExcelForum.com
Why fix what's not broken? ...Money 2000 Deluxe
I just upgraded my computer and reinstalled Money 2000
Deluxe. When I tried to backup or transfer my data from
floppy to Money. My data would not transfer...
Any tips would be greatly appreciated....How can i get my
data to transfer from my floppy into money?????I have
tried backup option and this doesn't seem to work nor does
the restore option....
In microsoft.public.money, Rich wrote:
>I just upgraded my computer and reinstalled Money 2000
>Deluxe. When I tried to backup or transfer my data from
>floppy to Money. My data would n...