Excel Drop Down Boxes #2
Question; does anybody know how to add additional data to a previous
drop down box? I have created a form that has several drop down boxes
a while ago, and due to some information that has been change I need to
input more info in the drop down boxes but for some odd reason I cant
remember how I executed these actions!! If it helps I am using Excel
CRS's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27444
View this thread: http://www.excelforum.com/showthread.php?threadid=46...Smith's SK2 2-Stone Sharpening Kit
Best deal: http://thediscountlocator.info/index.php?id=B000B5JXU2
Deluxe Sharpening Kit, Contains 1 Each 5" X 5/8" Medium Arkansas Stone, 1 Each 4" X 1" Fine Arkansas Stone, 2 OZ Honing Oil.
550lb. Type III Paracord:http://thediscountlocator.info/index.php?id=B000S5ODO6
Swedish Firesteel- Army Model:http://thediscountlocator.info/index.php?id=B0013L8D9K
Enter The Kettlebell! Strength Secret of The Soviet Supermen:http://thediscountlocator.info/index.php?id=0938045695...Average formula where blank cells are counted as zeros
I am trying to write an average formula that takes into account the blank
I had only cells A2, A4, A6 filled out, but when I do =average(A1:A6), it is
not treating the blanks as zeros so the answer is much higher than it should
Should I do a logic formula within the cells?
If you know the range, you could do the division yourself:
But this would include other non-numeric cells in the count of cells (6), too.
> I am trying to write an average formula that takes into account the blank
> I ha...email or phonecall in a calander?
I am new to CRM and wonder if email or phone call activity is updated into
the calander as well as appointment.
The only way to do this is to use one of
The GroupCalendar for MSCRM 1.2 is an Add-On
that allows you to see all activities in the GroupCalendar.
Also you can look into the Calendar of other users if you have
the security privileges.
If you want to see all further functionallity go to www.mscrm-addons.com
and download a trial version.
Your company for MS-CRM ADD-ONS!
GroupCa...Sending a Publisher 2003 Newsletter in an email.
I'd like to send a newsletter I created using publisher in an email. I've
tried a few different ways to do it but I'm not satisfied. I've tried to
save it as a picture and insert it into Word and then put it in my email but
it looses quality. I've tried to save it as a web publication but it won't
keep the pictures I have in my newsletter. Any help or suggestions would be
> I'd like to send a newsletter I created using publisher in an email.
> I've tried a few different ways to do it but I'm not satisfied. I've
> ...Is there a way I can only print the reply instead of the entire email message
I wonder if there is a way I can only print the reply to an email message,
instead of printing the entire message? My choice for selection only seem to
be gone with Outlook 2003 printing options. Any help is
...Not sending emails to groups
I am having a problem with my new laptop. I have several groups with several
diff. emails for different people in diff. cities around the world.
Whenever I want to send a email message to -- let's say -- people in NYC, if
it is under a certain number of people the message is sent ok, but if it is
let's say 40 people, it will be hanging in my outbox and it's NOT sent.
I think Microsoft might have added some type of security feature that would
unable viruses to send the same email message to my whole list. I might be
wrong, but that's the only conclusion I could come u...Some users can't email mail-enabled public folder
I've had a problem that recently started somehow. Environment is
clustered Exchange 2003 SP2 running on Windows 2003 Enterprise SP1.
Outlook 2003 SP2 clients.
I have a mail enabled public folder. Internal and external users were
at one point able to email the folders. Recently, some internal
(including myself, enterprise admin) and external users have been
unable to email just these specific folders. The users in question can
still email all other public folders. Also, other users can email the
public folders that are having trouble. It appears that only specific
users are having t...Money 2002 Died #2
Experiencing the same situation. Please inform us of the
We have the same problem here. Money won't start up. We
reinstalled and it ran initially, but now it has the same
problem again. Has anyone contacted Microsoft?!
>Experiencing the same situation. Please inform us of the
Same thing here. This is scary!
>We have the same problem here. Money won't start up.
>reinstalled and it ran initially, but now it has the
>problem again. Has a...outlook email #16
I have been using hotmail as my default email at home and using others for
work. I would lide to receive all my emails at Outlood to reduce time wasted
looking for the emails.
On Sun, 5 Mar 2006 23:17:52 -0800, darius
>I have been using hotmail as my default email at home and using others for
>work. I would lide to receive all my emails at Outlood to reduce time wasted
>looking for the emails.
Get a paid Hotmail account and Outlook can be used to access the
Chicago, Illinois, USA
...Exch 5.5 SP4
One of my user sent an email to the client yesterday, Since then this user
has been receiving return receipt every two minutes. Client has been also
receiving the email in every 3 minutes.
I have rebooted my server, Recreated the email address. Rest the IMS queue.
Following is the email which my user are receving. Can any one please help.
Thanks in advance
From: Mail Delivery Subsystem
Sent: Saturday, February 03, 2007 11:01 AM
Subject: Return receipt
The original message was received at Sat, 3 Feb 2007 ...Event id: 474 2 days after offline defrag
Last week my customers exchange 2000 information store dismounted and stopped
due to it's size exceeding the max 16gigs.
I had to run an offline defrag which lowered the databse to below 16 gigs
and it mounted properly. That night the was a good backup.
Since then there has not been a good backup - basically because of Event
id:474 - a chksum error.
I an afraid to restart that server or touch it because all of the email is
working - all is OK except it cannot be backed up.
We are prepared to order another server and run exmerge to migrate the data
- is this the best method - or is...Email addresses in a comma-delimited (CSV) file
I am trying to create a csv from another application to be imported into
Excel. One of the columns will contain email addresses. Is there a way that I
can format the data in the column to have the addresses be 'links' when
brought into Excel.
First, hyperlinks are not just formatting. The Insert|hyperlink style of
hyperlinks are objects in excel.
Second, CSV files are plain old text. They don't hold these kinds of objects.
(And they also don't contain any formatting properties, either.)
But third, you may be able to cheat a bit.
Can you go back to the othe...Changing Inventory Item Types #2
In GP7.5, is there any way to change inventory
item types once they have been used? Can the item
be deleted and then recreated at the end of a
year? Are there any utility programs that can do
this? In particular, I've got some "sales
inventory" items that I want to convert to "kits"
and others that need to be "services"
We are on 8.0, but I don't think it is possible to change the item type - not
even with Professional System Tools. We have changed the item name (via
tools) to include the word Discontinued. Then we set up a new item to
repl...Outlook replication changes valid email to lastname firstname
CRM 4.0, Outlook 2007, CRM Outlook Online Client with latest Rollup.
When some users are sync contact information between Outlook and CRM, sync
changes email address email@example.com in CRM to format
Not happen to all users. One reason can be there are also mobile sync
between Outlook (Exchange) and mobile phone. But this is also used by many
users and only some have problems.
It is look like email is populated with Outlook display value, not the real
Any ideas what setting (and where) is not right?
...IF statement help #2
What im trying to do is,
Calculate a Cell x say 0.5. If the result is a negative number, sho
0. If it is a positive number, work it out and show the answer. Jus
tried, and cant seem to get it right for some reason. I dont want t
have to use another cell for no reaon, as I need to present th
This is what I tried, IF((E22*0.5)>0), (E22*0.5),
RudeYute's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3295
View this thread: http://www.excelforum.com/showthr...External smtp email to public folder shown as post, not shown as email
Exch2003 FE & BE servers, both running on w2k3 server, BE server also a DC &
Now config public folder at BE, mail enabled it. For internal users, if
sent email to public folder, it shown up as email. For external parties, if
sent email to public folder, it shown up as post.
Wondering how to tweak public folder so that external emails will shown as
email instead of post?
Try looking at the following KB:
"Zac" <firstname.lastname@example.org> skrev i en meddelelse
news:Og20iL...Exchange 2003 / Outlook XP How to lock down email format / colour and disable signatures
My boss wants a uniform email look for everyone throughout the
organisation, as users are using bizarre colours for email backgrounds,
unusual fonts, and their own personal signatures.
To create a standard signature for users using information from AD, I
believe there are 2 ways: either create an event sink using a VB script
(I dont know how to do do this, so I won't be trying); or use a third
party application like Exclaimer (BTW is there a good alternative to
this - I have a quote for this but it is pretty damn expensive for what
To prevent users from using their own signatur...I want to open archived email attachments
I don't want to save to disk first. There is no danger from viruses
as these are emails I know the source for.
"Scott" <email@example.com> wrote in message
>I don't want to save to disk first. There is no danger from viruses
> as these are emails I know the source for.
> Please help.
And that attitude is EXACTLY how viruses get spread. How do you know 110%
that the scource is NOT infected?
"Gordon" <firstname.lastname@example.org> wrote in message
n...Am I able to manage multiple email accounts
I have several email accounts including Gmail, HOtmail and corporate. I can't make Entourage mail (2004) list individual accounts or find how to manage profiles. Apple mail works but doesn't allow me to insert a tiff company logo without making it an attachment. Outlook allows for all of the above.<br>
> This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
On 2/7/08 1...No more new fonts may be applied to this workbook #2
I have Excel 2003 (11.6113.5703) running on windows XP.
I have loaded the latest update from the web.
When I try to change the font size of text in the axis or
label of a chart, a message shows "No more new fonts may
be applied to this workbook."
When I do a print preview of the charts, the same message
shows up and then the print previews would be displayed.
I'd appreciate if you can tell me the fix.
Jon Peltier has some information on this in his Charting FAQ article:
and at his web site (use th...Show this folder as an e-mail Address Book #2
I have just created a new contacts list in our public folders.
When I go to all the workstations, the "Show this folder as an e-mail
Address Book" is unchecked.
To save me going to all workstations and checking this setting, is there
some way I can set it to "Show this folder as an e-mail Address Book"
....ms... <email@example.com> wrote:
> Hi all,
> I have just created a new contacts list in our public folders.
> When I go to all the workstations, the "Show this folder as an e-mail
> Address Book&q...i have problem with password to email server
i just got on the sight. How do i go about finding out the
password to outlook express to the email server. I have to
set up a internal email system. and everytime i get to log
on outlook express it pops up with a window to enter a
user and password. but i dont know it. How do i get my
password back. can i get in touch with isp and get it.
My microsoft money mutual fund page does not update anymore. Is there
any reason? I did not change anything
...I'm sending 2 (duplicate) emails each time I send emai
I'm using Office 2007, Outlook and, each time I send an email.. the receiver
gets two copies.... any thoughts?
Do you have a virus scanner installed which integrates itself with Outlook?
Uninstall this integration part of your virus scanner and try again; you'd
still be sufficiently protected by your on-access scanner part of the virus
scanner. For more details see;
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
Outlook FAQ, HowTo, Downloads, Add-Ins and more