Distribution List #46
In Outlook 2003 I could open an new email, click the "TO" button, select
distribution list from the drop down and populate the To with the
distribution list of my choice. Is this feature gone in Outlook 2007? If I
have an open email, I can't see where I can select a distribution list from
the pull down box.
"frustrated" <email@example.com> wrote in message
> In Outlook 2003 I could open an new email, click the "TO" button, select
> distribution list from the drop...Synchronization w/ OA2007 and packing list form
When I sync MS POS w Office Accounting 2007, what kind of data and
transactions synchronize? We need to syncronize receivables, so we can bill
later our customers. is that possible? Do MS POS have packing list?
...Filtering based on Reminder Time column doesn't work properly
I was trying to define a view for Todo Bar showing only tasks with passed
reminder time. My filter definition was:
Complete equals no
Reminder Time on or before Now
Surprisingly the view shows tasks with reminder time set within 24 hours
from now as well. I went to SQL tab of Filter panel and 'Now' is resolved
= 0 AND
<= '2010-01-02 17:42')
Since user-d...Global Address List Issues. #2
Hello everyone. I have yet another question. This is a good one. I have
set up a dummy Exchange account so that I could share the address book that
belongs to it. This makes it so that I can have a company Contacts Database
from which everyone in the company can e-mail from. This is the issue. When
I am sending a new message, and I hit the To button, I want this list to come
up as e-mail recipient options. Can this be done? If so, what is the best
way to accomplish this? Any and all help would be greatly appreciated.
A public folder would be a bette...combo box not updating accoring to record selector
I have a combo box which i use as a search field.
Correct me if i am wrong. Using the code below i am able to select the
record from the combo box and it populates the corresponding values to all
other controls on the form and subform. When i use the default record select
and scroll from one record to another the combo box selection remains in the
last selected value. Can i code to make the combo box record value highlight
the value I have scrolled.
long story short when i select a record using the default record locater the
main form footer section i need it to display th...Filtering spam based on sender's mail
When someone sends me an email, there's really two parts to the person's FROM
info. There's what they call themselves as a name AND their email, such as:
John Doe <firstname.lastname@example.org> .
I get quite a few spam from a sender masking with my own email address and
the name Approved Vaiagarra Store
(ie: Approved Vaiagarra Store <email@example.com> )
I don't want to filter out firstname.lastname@example.org because sometimes I send myself
a note or cc myself in things. But I would like to filter out the word
"Approved". I just don't see any way in Outlook...Bank reconsolidation/Create Outstanding list
Is there a template or macro that can match downloaded bank information with general ledger information exported to excel. Then create an outstanding list and list of discrepancies. Thank you.
If your downloaded bank information is in the form of a text or csv fil
then both can be imported directly to Excel.
Comparison then is relatively easy if both sets of information star
with a date field for instance
Message posted from http://www.ExcelForum.com
It's unlikely that there will be such a template because different
banks record the data in different ways.
If you can co...slanted text boxes
I wanted to put the word's "Postponed" in a textbox and then stick the
box on an angle across an event in a newsletter. Is this possible to do
in MS Word (2007)? What would you recommend I do?
On Wed, 03 Feb 2010 20:20:56 -0500, Ben <email@example.com> wrote:
>I wanted to put the word's "Postponed" in a textbox and then stick the
>box on an angle across an event in a newsletter. Is this possible to do
>in MS Word (2007)? What would you recommend I do?
It is not possible with a text bo...drop-down lists
How do I make the source for a drop-down list dependent on the selection of
another drop-down list? I'm using Excel 2002.
Try this website:
Check out the dependent lists section
Does that help?
> How do I make the source for a drop-down list dependent on the selection of
> another drop-down list? I'm using Excel 2002.
...If then with a list
I'm trying to determine if a date in Sheet1 is in a list of dates in Sheet2
(returning a simple, "YES" or "NO").
A1 contains the following date: 09/01/05
B1 should contain the "YES" or "NO"
Column A contains a list of dates, such as the following:
What is the best way to return a "YES" or "NO"? I have tried unsuccessfully
to do this with an if/then, but I'm thinking there must be a better way.
I have a list of names in Column A e.g.
and want to query that list and have the result display in cell B6 e.g.
NAFTA. I don't know which cell the information is in but wish to search
A1:A4. which one of the functions should I be using. I know I can do =A1 from
cell B6 but I want to search the range automatically. Thanks in advance for
Sounds like you mean vlookup but you need to give more info as to what you
> I have a list of names in Column A e.g.
> A ...How do I create 3 text boxes on a page?
I am trying to create an exam that will have 3 text boxes. I need for the
text boxes to expand as the student types in the answers and to continue to
an additonal page if necessary. This is my first Publisher project and I'm a
Scroll down to the "Connect text boxes" entry.
Mary Sauer MSFT MVP
"agrissom" <firstname.lastname@example.org> wrote in message
Have a strange condition that is happening with Outlook
2002 when receiving e-mail notifications.
We have a daily news flash that gets sent to a variety of
users. But when I open it only show my name in the To:
field, when there should be at least a dozen or so
Is there a filter that is hiding the other contacts? Any
suggestions would be greatly appreciated.
The sender may be using the BCC field instead of listing all recipients in
TO or CC
"Scott Kenyon" <email@example.com> wrote in message
news:01bb01c3d3c4$9bdcdea0$a40...Marketing list fails???
I could see that when use the last two options to select accouns or contacts
to integrate to a list, this "advance search" fails, this does'nt find
nothing.... it's possible???
thanks in advance
the functionality goes right, It was my error,this two types of search it's
about existing accounts inside marketing list and not includes accounts
> I could see that when use the last two options to select accouns or contacts
> to integrate to a list, this "advance search" fails, ...Remove contacts from marketing lists
I'm somewhat dazzled for I thought I could solve a 'problem' with three
clicks and now am searching/googleing for half an hour.
I'm searching for the right click to grant security roles the permission to
remove accounts/contacts from a marketing list.
Could someone push me the right way, please?
On Jul 22, 8:41 am, Llanddcairfyn
> I'm somewhat dazzled for I thought I could solve a 'problem' with three
> clicks and now am searching/googleing for half an hour.
> I'...Get the list of external links
Is there any way to get the list of external links referred by a workbook?
Normally, we get this list by using Edit->Links in Microsoft excel. But I
want to know the list of external links by programmatically.
Thanks in advance.
Take a look at VBA's help for LinkSources. There is sample code there.
> Is there any way to get the list of external links referred by a workbook?
> Normally, we get this list by using Edit->Links in Microsoft excel. But I
> want to know the list of external links by programmatically.
> Than...ACL Listing for a Distribution List
I have a Distribution List in Exchange 5.5 and 2003 and I have no idea what
it's for, although I think it's for permissions to a public folder, but I'm
not sure what folder. I know there's a way I can list the ACL for a folder;
is there any way that I can get a list of the public folders to which a
mailbox or distribution list has access so I can trouble shoot a problem
members of that list are having?
...List, Data Validation, unlocked cell, protected sheet.....
I have a unlocked cell, with Data Validation, List. With sheet protection
activated I cannot "add" to the cell contents supplied from the List
function. If sheet protection is off, this is possable. Is there a way to
have this feature with sheet protection turned on (activated)?
are you saying that in say cell A1 you have a drop down list created via
data validation ... you're clicked on this cell and chosen format / cells /
protection - and unchecked locked
and then when you choose tools / protection / protect sheet you can't make a
selection from the drop do...Excel List Separator .Net VB
In VB6 you could get the list separator using the code below.
How do you do the equivalent in .Net?
Thanks in advance
You've posted to two VB groups that have
nothing to do with .Net, one Excel group,
and 4 general .Net groups. How about just
posting to one more relevant group?
> In VB6 you could get the list separator using the code below.
> How do you do the equivalent in .Net?
> Thanks in advance
...Out of Office Assistant & Distribution Lists
Would someone know the following: when activating the
Out of Office Assistant, a user asks that all her
incoming messages be forwarded to someone in particular.
However, she receives an e-mail addressed to a
distribution list, it is not forwarded.
I tried editing the rule to no avail.
Help! Thank you.
Is there a way to list the spreadsheets which were a certain cell contains a
List the spreadsheet name if cell D4 contains 2004.
This should result in a list where all spreadsheets that have the value 2004
Is this possible?
A Perturbed Norwegian Agnostic
Public Sub Tester05()
Dim WB As Workbook
Dim SH As Worksheet
Dim ws As Worksheet
Dim i As Long
Const sStr As String = "MyList"
Const strControlValue As String = "2004"
Just wondering if there is a way to create a list for an
Basically we sell software, and each account has several
I want a Tab ( license ) which has a list with fields
Date, Product, Users, Key etc...
Just wondering if it possible to to this, as I know you
can't create extra tables?
While you can't do this within the app framework itself, you could create a new
table and then develop your own aspx pages that maintain it while "in" MSCRM.
The MSDN has examples of doing stuff like this.
...Custom Template not listed with Standard Templates
My boss has custom templates for memos, faxes, etc... and they are saved in
the following path C:\Documents and Settings\Application
Data\Microsoft\Templates. He would like to be able to go to File, New,
Templates on My Computer to access these, but for some reason they're not
showing up. We're using Office 2003.
I'm wondering if you will be able to help me...
I am putting together a league table spreadsheet, I have set up th
template for each game, and from this I can calculate the leagu
tables. This is the main use, but I would also like to use the score
information put into each game to produce top scorer lists.
I have done this by simply copying over all player data, whether actua
or blank by linking the cells and then sorting. This is fine for eac
round of games. But I am stumped for how to do cumulative tables.
Round 1 Top Scorers.
John Smith 3
Richard Jones 1
I have a list of 25 items, each item a new line. I want to apply bullets to
each line, but when I highlight the list and go to Bullets and Numbers, only
the first line comes out with a bullet. How can I get all the lines with
bullets? (Doing each line seperately does not work.) Thanks.
For bullets to work there has to be a hard return after each item. Shift+return
"Tom C" <TomC@discussions.microsoft.com> wrote in message
>I have a list of 25 items, eac...