I have been given an assignment to do a "mail merge" in Excel. The
names and addresses are in a document in Excel and the person does not
want to have to have the information typed again. Is this possible?
I believe a mail merge would have to be done in Word or Access. By
the way, I am using a Mac. Thanks for your help.
You may want to read some tips for mailmerge.
The first is from David McRitchie and the second is by Beth Melton and Dave
> I ...Averaging a Value between Two Serial Dates
I have two spreadsheets. The first spreadsheet contains two columns, one for
start date/time (in serial format) and the second for stop date/time (in
The second spreadsheet contains two columns. One containing a serial
date/time and the other containing a meteorological value (eg. temperature).
I want Excel to read the start and stop date/time from the first spreadhseet
and then search the second spreadsheet for all temperature values which were
recorded during this time frame.
Lastly, I want Excel to average these values.
Is this possible using a single Excel func...Test and consequences for adding and deleting W2K8 DC in 2003 domain
I have a forest and a domain with 3 Windows 2003 Server DCs. In order to
make a test during 2 weeks, I have to install and promote a Windows 2008
Server R2 into DC (without particulary role).
I know I will have to do an ADPREP with the W2K8 R2 DVD but forest and
domain will not change their level.
2 weeks after I will retrograde the server as member and suppress it from
the network (It will leave only W2K3 severs).
Do you know if there could be a problem for the AD architecture ?
Thanks in advance.
Answered in the same posting...Sorting Data #8
Does anyone know how to sort a column with a second word inside a cell?
Create a "helper" column to extract the word(s) of interest.
Then, sort on the helper column.
Please keep all correspondence within the Group, so all may benefit!
"Tim" <Tim@discussions.microsoft.com> wrote in message
Does anyone know how to sort a column with a second word inside a cell?
What function is the one I use to extract...Find Oldest date based on two criteria.
I am having an issue trying to figure out this issue.. I have tried a
MIN, but it doesnt seem to work correctly..
I have three columns One with a State, one with a Code and one with a
The Code can have say EA12 EA23 EA45 and FG12 FG34 FG56
What I need to have happen is that when State= NY and CODE Starts with
EA find me the oldest date in the column.
A B C
NY EA12 1/1/2009
NY EA24 2/28/2009
CT EA12 3/2/2009
NY FG34 4/5/2009
ME FG45 5/1/2009
NY EA12 ...Deleting Duplicate Records 03-20-08
I've got my duplicates records query and now I want to delete these 1100
dups in my table of 12,000+ records.
Can you please explain how I can easily delete these duplicate records in my
table now that I have found them in my query.
Thanks very much.
Use a subquery to identify which duplicate records to delete, and which one
This example assumes:
- a table named Table1;
- a primary key named ID;
- "duplicate" is defined as same Company, Address, and City;
- you want to keep the lowest ID value.
DELETE FROM Table1
WHERE ID <>...sync Outlook data between multiple computers
Looking for a way to sync both contacts and caledar on two
different computers (single user). A tablet PC and a
laptop running Win XP w/either Office 2002 or 2003 with
peer to peer network.
Do you have IR on both? At any rate, see if one of these solutions works
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to the
Swen virus, all e-mails sent to my actual account will be deleted w/out
After searching google.groups.com and finding no answer
rweaver <anonymous@discussions....Merging excel files
Hello everyone, I have one excel file for every day of the
month since June 2003. I would like to create one file per
month and merge the daily file into it...is there another
way to do it other than copy/paste? Please help there is
a lot of files
what are the names of your files
"Raul V" <email@example.com> wrote in message
> Hello everyone, I have one excel file for every day of the
> month since June 2003. I would like to create one file per
> month and merge the daily file into it...is there another
> way t...How do I dynamically retrieve the cell address of the last cell t.
I want to write to an excel file that already has data in it using matlab
xlswrite function. I found that I can write to the excel file without
overwriting information that is already there. So I was wondering if there
is a way in excel to retrieve the address or index of the last cell
There are several ways of doing this depending on the layout of your
Say you have data in all the cells of A1:A10. No blank cells in that
range. You can use:
LastCellAddress = Range("A1").End(xlDown).Address(0,0)
This will give the address of A10.
If you...Data Validation #23
Rather than writing some VBA to restrict entries into a cell I thought I
would use the data validation!
All I am trying to do is restrict the user to having to select from the from
pick from list box. I believe I have set things up correctly, but I cannot
stop the use from adding spaces!
The use is restricted from using his own codes, but I cannot seem to stop
him from manually adding (in error) unnecessary spaces either before or
after his selection. What happens is he selects from the list, but he can
them manually edit the cell. It does not allow him to use entries that are
not ...Data manipulation
I am trying to manipulate a fairly simple weekly schedule.
On Sheet 1, column A contains names, Row 1 contains Days of the week. The
cells in column B contain a number indicating the shift that the person is
supposed to work. It looks like this:
On Sheet 2, I want to turn this data around so that the column headings are
the shift time and underneath there is a list of people on each shift. It
should look like:
6 7 11
Joe Bill Frank
Unfortunately, there may be a different numb...using Access Data
I have a slight problem with Charts in Excel & Access. I'm creating charts
that can use up to 50,000 data points (if not more) and in Excel there is
significant lag time (up to 2 minutes just to rescale an axis or change the
title). I decided to try and use Access to organize the data, but creating a
chart in Access is a pain because there is a 4000 data point limit per series
My question is: Is there a way to link the data from Access to an Excel
chart without importing the data (importing would just cause my initial
problem)? I do know some basic...Marking deleted items as read #2
Does anyone know if there is a rule combination that will mark messages that
I delete as read. When I delete stuff it really bugs me that it stills marks
the items as unread. I don't care! Thats why I deleted them!
If anyone knows how to fix this I'd greatly appreciate it
My first question would be, if you are deleting unread
messages, why would you be concerned if they are
marked "read" or "unread"?? Just empty the deleted items
folder and be done with it. If there is a concern, then go
into the deleted items folder and selec...can i use filters to compare data instead of vlookup?
I have to compare membership lists to identify if customers belong to certain
groups. Currently, I have been using Vlookup but I notice that there are too
many nuisances. Could I use a filter to compare two membership lists and give
me a more accurate answer?
Maybe try setting up a new sheet with List1, and entering a new column
indicating List1 in each row......then adding List 2 at the bottom and
entering List2 in the new column for each row in that section............then
do Data > Filter > AutoFilter and check the arrows at the tops of the columns
to filter from there...........Deleted Exchange accounts reappear #2
We have an infrequent issue where Exchange 2000 and 2003 mailboxes
sometimes reappear after being deleted. (Some of the users accounts
are NT based, and some are AD.) Has anyone else experienced this? If
so, is there a remedy.
...copy text to specific cell
In one cell I have a String And in another cell I have a reference to a cell.
How do I put the String into the referenced cell?
A Formula will return a value to the cell that holds the formula.
You'd need some VBA to do what you want.
dim myStrCell as range
dim myAddrCell as range
set mystrcell = .range("a1")
set myaddrcell = .range("b9")
.range(myaddrcell.value).value = mystrcell.value
This has no validation at all!
If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritch...Data is populating the same in EVERY record in the DB
I'm trying to assist a user who changed the name of a field in a form. After
doing so, the information she enters into the field populates in EVERY
record in the DB. Does anyone have any ideas on the cause of this and how to
correct it? I know absolutely nothing about Access (or any other DB for that
On Mon, 8 Oct 2007 12:36:02 -0700, Todd <Todd@discussions.microsoft.com>
>I'm trying to assist a user who changed the name of a field in a form. After
>doing so, the information she enters into the field populates in EVERY
I've created a new schema field, but have not yet published it. Is there
any way to delete it?
I saw your posting, and would appreciate it if you can let me know how
you created a new schema field, and how would I publish it?
I would like to add a database/table, have the data synch with the
Outlook, and configure it for replication.
Thanks in advance.
"Cindy MIkeworth" <firstname.lastname@example.org> wrote in message news:<email@example.com>...
> I've created a new schema field, but have not yet published it. Is there
> any way to delet...Can you do an e-mail based merge in Pub 2003?
I may be bonkers but I believe before I loaded the beta of Pub 2003 I could
merge to an e-mail format in Publisher. The new wizard is good but only
offers printing and help dosent help...
Is this a capability or not?
Publisher now lets you create an HTML publication for emailing through
Outlook. It still won't allow you to mail-merge to email.
"Thomas Loker" <firstname.lastname@example.org> wrote in message
> I may be bonkers but I believe before I loaded the beta of Pub 2003 I
> merge to an e-mail format in Publisher. The n...Can you sort Excel data by font color?
I heard that you can sort Excel data by font or column colors. Is this true
and how do you do it?
"Help Me Sort" <Help Me Sort@discussions.microsoft.com> schrieb im
>I heard that you can sort Excel data by font or column colors. Is this
> and how do you do it?
Only with VBA or helper columns:
http://www.cpearson.com/excel/SortByC...In Microsoft Outlook how can you delete email without opening it?
I am an Outlook Express user and you can click on email once and delete
without opening it or double click to open it. Is there a way to delete
without opening in Microsoft Outlook?
Hello Corey, you wrote on Fri, 26 Aug 2005 06:48:02 -0700:
> I am an Outlook Express user and you can click on email once and delete
> without opening it or double click to open it. Is there a way to delete
> without opening in Microsoft Outlook?
Sorry, but I don't understand your question really. Which program is
used? Outlook Express or Outlook?
Hello C...Excel Data Connections to Access Queries: Limits?
I have an Access 2007 database with data connections to:
+ Sharepoint Lists
+ SMS SQL tables/views
I've written Access queries that use tables from those data connections.
I want to use Excel to connect to those queries in the Access database to
run various reports (such as charts, lists, etc...)
However, I'm having 2 problems:
1) In Excel, when I go to Data / Get External Data / From Access, I cannot
see all of the queries listed in the Access Database.
2) The queries I do see only return a small subset of records. (I've
tested the query within Access, and I should get 17...Mail merging from Excel to Publisher or Word (office XP)
I am a teacher in a Sheffield UK school teaching GCSE.
Part of the requirement this year is to mail merge into
either Publisher or Word from an Excel spreadsheet. Did
the same last year with no problem (office 2000) but with
Office XP now have strange results.
Mail merged figures (results of formula) now unexpectedly
develop either 4 decimal places when merged to Word, or
up to eight in Publisher. i.e 14.67 goes to 14.6667 or
14.66666667, This in spite of formating to two decimal
places and/or roundup.
My solution is to manually convert the numbers to text
but this can't be right...How do I create columns in a catalog merge?
How do I re-arrange the merge fields into columns instead of rows? (Top to
bottom - 3 columns per page)
Resize the "catalog merge area" until it says it will repeat 3 across. Resize
the merge area vertically so it says Area will repeat 1 down.
Mary Sauer MSFT MVP
"dcallaway" <email@example.com> wrote in message
> How do I re-arrange the merge fields into columns instead of rows? (Top to
> bottom...Counting of cells with a specific color filled
I have an excel workhseet where different cells are filled with different
colors. I need to count no of cells in a specific column with a specific
colour filled. For example i need to count how many cells are filled with
green color and how many with red etc. What formula i should use?
Thanks in advance,
use the COUNTIF() function, the criteria is whatever was used in conditional
formatting to change the color fill of the cell. If conditional formatting
was not used to color the cell, you can't do it. (unless you use Visual