Using Outlook to create/read mailing listsI 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
Outlook beginner.
what do yo...
Contact RibbonThe 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?
thanks Paul
Might I suggest just clicking the "x" to close and then answer "Yes" t...
File List Folder Outlook 2003Hi,
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.
Regards,
Troy
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 fiIs it possible to create a custom mapping / loading between the contact and
account
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?
Hi Tom,
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
address fields.
Following posts will explain you a little about ...
Permanently keep holidays from showing up in Calendar2007I 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?
Thanks!
When viewing the calendar, switch to the by category view and delete the
holiday category.
...
Hiding formuals in cells questionHi. 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!
Hi
not without protecting the sheet but why is this a problem for you?
--
Regards
Frank Kabel
Frankfurt, Germany
"JP" <JP@discussions.microsoft.com> schrieb im Newsbeitrag
news:ABFE07BF-6087-4E24-814A-03AF8863A633@microsoft.com...
> Hi. I was wondering if there was a way to hide the fo...
Using custom fields for better email list view.Hello.
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 tableIn 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:
http://office.microsoft.com/en-us/assistance/HP051998791033.aspx#Hide%20zero%20values%20in%20a%20PivotTable%20report
But no luck :-(
Mogens
You could use conditional formatting on these cells - highlight the
cells,...
Contacts Synchronization ProblemI 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
8004011B.
...
AddressesHi
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?
Thanks
Oggy
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
"Oggy" wrote:
> Hi
>
> Can anyone please advise me how i can insert a name and ad...
hide my nameWhen replying to an email or creating one from scratch how do i hide my name
in the "from" field...thx
fred <fdbjrgetridofthis@wowway.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.
Hi,
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
button.
Cheers
Andy
Waynesch wrote:
> I have a bar chart that is showing gaps and i don't want them. The s...
GAL issueOur 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
siteA.
Trusts are in place between domainA and domainB (previously), between
domainA and domainC (for the migration), but not yet between domainB
and domainC.
The problem that I see now is that GAL for use...
OWA and second mail addressExch 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 fieldsI 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
clicked?
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 DiallingWe can currently initiate telephone calls from within our contacts folders,
plus some public (contact) folders, by right-clicking and selecting Call
Contact.
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
folders.
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 #3I 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.
Hi
is your worksheet protected ?
--
Regards
Frank Kabel
Frankfurt, Germany
llong wrote:
> 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
------------------------------------------------------------------------
kurt's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35686
View this thread: http://www.excelforum.com/showthread.php?threadid=554712
Kurt
You cannot insert an image into a cell.
You can overlay ...
Address book #18I 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.
Thanks.
Look here for all the information you need on backup and restoration of
Outlook data:
http://www.slipstick.com/config/backup.htm
--
Jocelyn Fiorello
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. ***
In news:097a01c3973e$a20fd920$a001280a@phx.gbl,
Danny wrote:
> I i...
control box listHi 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
data.
thanks tim
...
how to hide an ActiveX control?
hi there
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?
tia
bhu
can u set the size of ur control as 1x1 pixels
"bhu Boue vidya" <bhuvidya@yahoo.com.au> wrote in message
news:1175703214.292931.252210@e65g2000hsc.googlegroups.com...
>
> 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.
--
Russ Valentine
[MVP-Outlook]
&q...
Hiding plot AreaI 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)
Many Thanks
Adam
Adam -
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 AddressHi folks,
Where in Money 2004 Small Biz do I change my address and phone? Can not seem
to find where that gets set.
Thanks.
-=Bob=-
...