Using Outlook to create/read mailing lists
I recently installed Outlook in my office and would like it to do some
automated tasks. Specifically, automated email to my employees based
on a spreadsheet or database. If I have an individuals name on a
spreadsheet, is it possible to link Outlook to that spreadsheet
(let's say in Excel) and create a mailing list? I'm using Outlook
'03 and my employees are already on a list in Outlook.
Any help would be appreciated.
Yes to do this type of automation, you can use the addin
Thanks for the response. Could you be a bit more specific. I'm an
what do yo...Contact Ribbon
The DELETE option in the Actions box of the Contact tab is right next to the
SAVE & CLOSE option. I have allready deleted 2 of my contacts. It seams
they should have put the delete option in a safer place? I am aware that the
ribbon can not be changed. I am a new user to Office 07 and will probably
become more carfull as time goes on. Is there a way to undo delete? Is
there any other way to get the Contact back other than locating the
information and re-entering it?
Might I suggest just clicking the "x" to close and then answer "Yes" t...File List Folder Outlook 2003
I found an article which describes how to setup a folder to view any file
system folder in Outlook 2002. I can't find any equivalent in Outlook 2003.
Basically I just want to have an Outlook 2003 folder named something like
"my files" and have its address pointing to a mapped drive. I have tried
setting up a "home page" location on a folder, but it only works for web
addresses, not file systems. Thanks in advance.
At the bottom of the Navigation pane, you should have buttons for Folder
List, Shortcuts, etc. Select the Folder List button.
Op...Load the address from the lookup table to corresponding contact fi
Is it possible to create a custom mapping / loading between the contact and
entities in such a way that when selected the existing account value from
the lookup table of account on the contact page, the existing address fields
will be populated into corresponding contact fields?
Yes, it is possible with the help of little coding. Basically you need to
add JScript code in onChange event of the Account lookup on Contact entity
form. That code will be calling the CRM webservice and fetching the account's
Following posts will explain you a little about ...Permanently keep holidays from showing up in Calendar2007
I had holidays automatically set to appear in my Outlook 2003 Calendar. I'm
now in Outlook 2007, and would like to turn off Holidays. When I go to
Tools, Options, Calendar Options, Add Holidays..., as soon as I uncheck the
United States box, my OK button becomes grayed out so I'm unable to
permanently keep the checkmark removed from in front of United States. I'd
prefer not to individually & manually delete all the holidays. Anybody know
what a fix might be?
When viewing the calendar, switch to the by category view and delete the
...Hiding formuals in cells question
Hi. I was wondering if there was a way to hide the formulas in cells without
protecting the sheet. I am making something for other teachers at my school
and I want to hide the formulas so they won't mess anything up on the
spreadsheet. Any help would be greatly appreciated. Thanks!
not without protecting the sheet but why is this a problem for you?
"JP" <JP@discussions.microsoft.com> schrieb im Newsbeitrag
> Hi. I was wondering if there was a way to hide the fo...Using custom fields for better email list view.
I get lots of letters with the same title. I want to group them by topic and
sort on the number of letters in the group. I know that I can do this using
custom fields but I do not know what query to use to get the number of
letters the group.
...Hiding "0" values in pivot table
In a worksheet I have a listing of stock records with ItemNumber, Date,
StockLocation and NumberOnStock. When I make simple Pivot Table with
ItemNumber and StockLocation as rows and select a Sum of "NumberOnStock"
I would like to hide rows where the sum is "0". But this does not seem
to be possible.
Tried to follow the guidelines in the Microsoft article:
But no luck :-(
You could use conditional formatting on these cells - highlight the
cells,...Contacts Synchronization Problem
I am copying contacts from a PST file to an exchange
account. When i synchronize with the exchange, some of the
contacts are deleted. I am left with 619 contacts out of
over 3,000. I get sync issue error with a code of
Can anyone please advise me how i can insert a name and address from
the microsoft address book into a exel spreadsheet. If this cannot be
done what alternitives are there?
Here is a good approach:
1. From Address Book:
File > Export > Other Address book... > Text File (Comma Separated Values)
The Wizard will permit you to select which fields are to be exported.
2. From Excel, just open the .csv file created in step #1
Gary''s Student - gsnu200713
> Can anyone please advise me how i can insert a name and ad...hide my name
When replying to an email or creating one from scratch how do i hide my name
in the "from" field...thx
fred <email@example.com> wrote:
> When replying to an email or creating one from scratch how do i hide
> my name in the "from" field...thx
Are you saying you want the reply to be anonymous?
Brian Tillman [MVP-Outlook]
no, I don't mind if my email is revealed.. just my name. I have tried by
removing it from the "User Name:" field in the email account but it
continues to show up. I have also removed from the header informati...Copy a contact to Clipboard?
I use Outlook 2002 that came with my iPAC rx3115. I use it for contacts and
calendar and not for email. Outlook 2002 allows me to highlight a contact
and go to Edit menu and click copy and the entire contents of that contact
are put into Clipboard. I can then paste the contact information into MS
Notepad, an email, etc. and edit it from there. I like and need the
quickness of this feature. This is a very important feature for me I use
often. I want to upgrade to Outlook 2007. Did Outlook 2007 retain this
feature? In Outlook 2007 can I quickly copy the entire contents of a...How do I hide gaps in an Excel 2007 chart?
I have a bar chart that is showing gaps and i don't want them. The select
data > hidden and empty cell button does not give an option to hide gaps. I
think by default they are hidden but if you even click on this to see what it
does the gaps are shown and no way to turn off.
If you hide the actual rows then with the Plot visible cells only
setting on the gaps will be removed.
In xl2007 the setting is on the Select Data dialog, Hidden/empty cells
> I have a bar chart that is showing gaps and i don't want them. The s...GAL issue
Our existing Exchange 5.5 organization consists of two different sites,
each in its own NT 4.0 domain, so call that siteA and siteB in domainA
and domainB for simplicity. They share a common GAL between them as
you would expect and all is well.
I've just installed the first Exchange 2003 server in a Windows Server
2003 AD domain (call this domainC) and placed the Exchange server into
Trusts are in place between domainA and domainB (previously), between
domainA and domainC (for the migration), but not yet between domainB
The problem that I see now is that GAL for use...OWA and second mail address
Exch 2003 cluster
I have a domain with two mail address.
The first one is example.com (pubblic address) and the
second is test.com (only for internal mail).
Example.com is the default address.
Every users are configured only with example.com and are
able to connect to OWA.
Every users are configured with example.com and test.com
and are able to connect to OWA.
The others users that have only test.com but doesn't are
able to connect to OWA.
Do I have to configure the HTTP protocol or IIS or both?
Thanks for your reply
All users should be able to connect to OWA regardless of
what thei...Hiding and Un-Hiding Data fields
I am using a form for people to select data via dropdown menus and then
having it run through a query to filter results. Is there a way that I can
have certain feilds hidden until a toggle button or something of the like is
Basically I want have three choices of buttons: Year, Quarter, and Month.
What I ideally want to happen is when someone selects the button for year, a
hidden drop down menu appears where they can then choose from the available
years to filter through the query.
I would say I am above average with using access, but I have no idea how to
hide fields and then...REPOST: Contacts/Global Address List/Automated Dialling
We can currently initiate telephone calls from within our contacts folders,
plus some public (contact) folders, by right-clicking and selecting Call
This feature could use our mobile phones (via Bluetooth) but more usually it
uses our BCM office phone system. This all works fine.
However, under this system we are maintaining a lot of duplicate data: 1 x
Active Directory, 1 x Exchange 5.5 directory, and several public contact
We are moving to Exchange 2003 soon which will mean that Exchange will
directly tap into AD, rather than maintain it's own directory. We would als...Hiding a worksheet #3
I want to hide a worksheet. So, I went to the format menu and the "worksheet" option is grayed out. Why? And, how do I "ungray" it.
is your worksheet protected ?
> I want to hide a worksheet. So, I went to the format menu and the
> "worksheet" option is grayed out. Why? And, how do I "ungray" it.
I think Frank meant to ask about the Workbook--not the worksheet.
(Check under Tools|protection|Protect workbook or Unprotect workbook)
My question is: Is there another sheet in the w...Hide images when Hiding Rows
I have inserted images into cells, but when I hide the column the images
are not hidden with that column, they just get squished between the two
cells next to the hidden cell. Is there a setting or way to tie the
image to that cell so that it hides/unhides appropriately with the row?
kurt's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35686
View this thread: http://www.excelforum.com/showthread.php?threadid=554712
You cannot insert an image into a cell.
You can overlay ...Address book #18
I installed a new hdd making it the master and the old one
the slave. All of my contact info is still on the old
drive. I need to know the file name and location so that I
can get my old contact info back.
Look here for all the information you need on backup and restoration of
MVP - Outlook
*** Replies sent to my e-mail address will probably not be answered --
please reply only to the newsgroup to preserve the message thread. ***
> I i...control box list
Hi I have a long list of hospitals, and would like to put a control in
that will fill in as you type to search.
I have tried list box, but can not see how to enter the list into the find
...how to hide an ActiveX control?
i have an ActiveX control, written in C++, which has the
OLEMISC_INVISIBLEATRUNTIME flag set, yet when i display the web page
it is attached to, i get the familiar "red cross" graphic in the
middle of the screen - how can i hide the control so nothing is
displayed at all?
can u set the size of ur control as 1x1 pixels
"bhu Boue vidya" <firstname.lastname@example.org> wrote in message
> hi there
> i have an ActiveX control, written in C++, which has the
> OLEMISC_INVISIBLEATR...How do I get my XP Pro Outlook to auto fill email addresses?
My Microsoft XP Professional Outlook has stopped the auto fill function when
emailing to parties that I've previously emailed to, so I have to retype the
persons email address each time.
Have reinstalled the program and run the detect & repair to no avail.
Not sure where or what my problem is, but would appreciate any suggestions.
Auto fill function works fine in Google, etc., but not in Outlook.
Did the feature ever work? Assuming you still have the feature turned on,
this usually means a corrupt profile.
Create a new one with a different name.
&q...Hiding plot Area
I have a formatted output sheet that has a Pie Chart
embedded. The data for the pie chart comes from a second
sheet using 2 ranges B2:B6 & D2:D6 B2:B6 is always
populated and contains labels. What I want to do is, when
D2:D6 contains 0 in each cell (or Null), suppress the Pie
chart but always show the Legend (which is driven by B2:B6)
All you see of the pie when all values are zero is a single line at the
first slice. The legend still appears. To hide the line, double click on
one of the wedges and on the Patterns tab, change the Border setting to
None. ...Change of Address
Where in Money 2004 Small Biz do I change my address and phone? Can not seem
to find where that gets set.