How can I merge all my emails in outlook
How can I merge all my emails in outlook
On Fri, 9 Apr 2010 21:31:02 -0700, Gaston <Gaston@discussions.microsoft.com>
>How can I merge all my emails in outlook
Please ask in an Outlook forum. This group is for a different program,
Microsoft Access. The webpage can be confusing and may have misled you.
John W. Vinson [MVP]
"Gaston" <Gaston@discussions.microsoft.com> wrote in message
> How can I merge all my emails in outlook
...Merge Date Field
Can anybody tell me if it is possible to force a date merge field to display
the UK day/month/year format in Publisher 2003?
Its not the same as Word where you can display the field codes and force it
to show the required format.
Su <Su@discussions.microsoft.com> was very recently heard to utter:
> Can anybody tell me if it is possible to force a date merge field to
> display the UK day/month/year format in Publisher 2003?
> Its not the same as Word where you can display the field codes and
> force it to show the required format.
Is the date format s...merging the values of a field in a subreport
helloi am trying to prepare route cards for travels. I am preparing theseroute cards in an access reports. the route points, the stops oftravel, has been provided in a routeno-stop table. I am trying tomerge the values for a particular travel. for example, the table is asfollowsroute no: stops1 museum1 sports centre1 tennis court2 zoo2 city hallwhat i want is merging these values asfor 1: museum-sports centre-tennis courtfor2 : zoo-city hallis it possible and how?...Cell Drop-down Menu
Is it possible to create a drop-down menu in a cell? For instance,
would like a user to be able to click on a cell and choose what s/h
wants to enter
Message posted from http://www.ExcelForum.com
From menu select Data.Validation, and then in Validation window allow List
and then type your list into source field, like:
You can give the list as cell reference on same sheet, like
When you want to refer to the range on another worksheet, then you have to
define this range as named range, and then you can refer to this named
range ...Mail Merge and Access format of telephone number
I use mail merge for a directory using Access for my data. The telephone
numbers that are formatted in Access (555) 642-5555 aren't retained but come
in to merge as 555642555 so I have to go to each one and put in the (xxx)
666-666. Is there anything I can do to retain the Access format of the tele
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"terry50" <email@example.com> wrote in message
news:12784D...Start/End Cells in a Range
Having issues with a range and my searching has turned up nothing. I'm
probably missing something obvious, but I don't feel like beating my head
against the wall anymore.
I have a Range object. I'd like to get the row/column values for the start
and end cells of the range. The range is 'Raw Data'!$V$30:$V$51.
To retrieve $V$30, I can use Range.Row (=30) and Range.Column (=22).
How can I retrieve (or calculate) the row/column values for $V$51?
Any suggestions are appreciated.
Disregard, this is so I can find my post la...money2003 merge files
Is there a way to merge two money files (.mny)into one?
"daveb" <firstname.lastname@example.org> wrote in message
> Is there a way to merge two money files (.mny)into one?
...publisher printing wiht mail merge
I am having trouble printing a postcard in Publisher. I
am using mail merge to insert names on one side, and
address on side two. It currently prints page one, then
immediately page 2.I do not have time to change the
paper.So, I followed the directions online to make two
separate files..one for page one, and one for page two,
print one...reverse the paper, print two. The problem
then is the names do not print in the correct order. It
is not the order of the pages that prints incorrectly, it
is the names in the greeting line on the front of the
postcard do not match up with the name ...Merged letter and made changes to merged letters. Final merged doc
Merged letter and made changes to merged letters. Final merged document has
date in field code and atty wants to change it from Jan 5 to Jan 4. She does
search and replace but the date automatically updates on print, even if we
change that setting.
"Serena K." wrote:
> Merged letter and made changes to merged letters. Final merged document has
> date in field code and atty wants to change it from Jan 5 to Jan 4. She does
> search and replace but the date automatically updates on print, even if we
> change that setting.
>...search and return cell value
I hope that someone may be able to help.
I have a worksheet that has 7 fixed columns and a variable number of rows.
The rows can range from 1 to many. Cell A1 is dependent upon the value in
the last row in column G. I can locate this with nested "if" statements or
by creating a new column H that will test to see if the next row contains
Is there any function that I can put in cell A1 that will locate the last
row in column G that contains a value and return the value of this cell?
if you have no blank rows in between try
Reg...How do I format a cell with numbers, text and hyphens
more details would help
e.g. i have ................... in my cells and i would like to see
"Yaya" <Yaya@discussions.microsoft.com> wrote in message
If you want numbers, text, and hyphens, the cell must be formatted as TEXT.
But you won't be able to do any calculations with the numbers unless you
separate them out and use the value function.
...Update one text box based on another text box
I'm using Access 2007.
I have three date fields we use for follow up:
Then I have a text box I've named Status and a check box I've named Not
The idea is for us to enter a date in FU1 after the first follow up is
completed. Once the date is entered in FU1, the Status text box is updated to
read "First Follow Up". Same goes for FU2 and FU3.
If the Not Interested check box is checked off, the Status is updated to "Not
Interested". This all works.
My problem is if any of the dates are removed from any of the follow up date...How do you merge fields in a Publisher post card?
I am trying to print post cards to my students...4 per page. However, it
seems I am only to insert or merge their names and addresses using Microsoft
Word. My post cards in Publisher print 4 per page to the same student.
When you merge postcards there can only be one card on the screen. If you are looking
at print preview, it will reflect the same data on each card, this is a bug.
Mary Sauer MSFT MVP
"B C-ing 4 D Solution! �" <B C-ing 4 D Solution! �@discussions.microsoft.com> wrote
...What do you use for Payee when moving money from one acct to anoth
I have a bunch of different things for Payee when I transfer money around.
Sometimes I have myself listed, sometimes the account, sometimes, simply
What do you guys use?
In microsoft.public.money, db wrote:
>I have a bunch of different things for Payee when I transfer money around.
>Sometimes I have myself listed, sometimes the account, sometimes, simply
>What do you guys use?
If I enter it by hand, I usually leave it blank.
I use my first name or my wife's, depending on which account the transfer is
&q...How do you average a range of cells that continually grows?
What's the best way to average a range of cells that grows on
weekly-basis without modifying the formula weekly
65Stang's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1500
View this thread: http://www.excelforum.com/showthread.php?threadid=26666
AVERAGE should ignore blank cells
"65Stang" <65Stang.email@example.com> schrieb im Newsbeitrag
news:65Stang.firstname.lastname@example.org...Merging a CSV and XLS file automatically
I have a csv fles on the network derive that is being updated every night.
I need to automatically put the CSV data into the first worksheet of another
XLS file and make it available for users.
I can have a scheduled task runs and merge the CSV into the XLS file.
What would be the easiest/automated way to do that?
Sounds like you need an auto_open macro in your workbook which you are
opening as a scheduled task.
Research Scientist with many years of spreadsheet development experience
--------------------------------------------------------...Format this cell like that cell, automatically?
I keep my grades in an Excel workbook of four sheets, of which the
two relevant ones are Attendance and Grades. During the semester, if
a student drops the course I mark all cells for that student in both
worksheets as Locked and I apply a gray pattern to them.
Having to do this in two worksheets is kind of a nuisance. Is there
any way to set, say cells Grades!A11:AP11 to pick up automatically
any formatting and Lock/Unlock status as it changes in Attendance!A1?
I know I could do this in a macro, but I'm wondering if there's any
purely worksheet way to do it.
Stan Brown, O...Linking to non-adjacent cells
I have 2 workbooks. In Column A of workbook Source, I have the number
1 through 20 starting in A1. In the second workbook, Summary, I wan
to link to every third row in Source (for simplicity, these will b
located starting in B1 going down). So in the end, Summary will loo
like: B1=1, B2=4, B3=7, etc.
I can do this manually for each cell but want to find a way that if
manually link to a few of the cells and then copy down the formula, th
rest will automatically be completed. When I remove the dollar sign
from the linked cell's address and then copy down, I get a consisten
but very we...How do I set up formula to copy format from one worksheet to anoth
How do I set up a formula to copy both value and format from one worksheet to
When I use the = sign, it copy the value only. How do I get the format be
you can't "link" the formatting in the same way as you link the contents
what you need to do is to copy all the cells in your sheet
X A B C ...
click on the grey square which I have illustrated with the X
this selects all the cells in the sheet
press control-C (copy)
go to your new sheet and select the same X square
now do edit > paste special > format / column width.
if you are doin...How do I have pages oriented differently in one Publisher doc
I need to be able to have some pages oriented landscape and others portrait
in the same Publisher document.
Set the page either landscape or portrait which ever is the orientation of
the majority of pages.
Now when you come to a page that wants the other orientation, rotate the
text and image boxes 90�.
Or, make one file for the landscape pages and another file for the portrait
"bates" <email@example.com> wrote in message
>I need to be able to have some pages...Merge information from Excel to Access
I am currently an english student living in Qu�bec..
Im working for a company who wants me to use access but I am onl
familiar with excel.
They don`t speak english, and I speak limited french so Im looking t
the internet for a question to be answered.
I am currently typing up information about historic buildings i
Qu�bec, and they want me to make it a database, they havn`t gotte
Access yet so they want me to type it in excel first.
Can you import excel information over into access? or will I have t
Thanks for the help
Try lookig here:
http://off...Merging Access w/- How do I get different address on 2 prints per
I have created some post cards for my department. One side (one file) has
the same information on every card. The second side (second file) has unique
information on each card. The post cards are 4.25 x 6, so I am able to post
two per page; however, I am getting the same address twice on each page. Any
assistance would be greatly appreciated!!!!
- Kristy Land
Create two different publications, one for the merge and one for the other side.
When you merge, you can only have one card on your screen. Type your card
measurements in the page setup. Measure the margins and gaps on your...Change cell value result from "FALSE" to blank or zero
I have the following IF statement written into this cell:
If cells N6, P6, R6 or T6 all have zeros written into them, cell E6 shows
the value "FALSE". How can I have this cell have the value 0 under these
"JG" <JG@discussions.microsoft.com> wrote in message
>I have the following IF statement written into this cell:
...Can I merge 2 Profiles files into one?
I recently changed an email account and set up a new Profile. I'm using
Outlook 2003. This has caused complications and I'd like to now combine all
past emails into one profile, preferably into one of the existing profiles
and continue to use just that. Is this possible to do?
You can either import the mail from the second pst or use File, Open,
Outlook data file and move or copy it - or use two psts. Search for *.pst to
locate the second file.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickSt...Selecting 1 column left from active Cell
I know this should be so simple, but what would be the code to backstep 1
column from the active cell?
"rob nobel" <robnobel@dodoNOGOOBS.com.auNOGOOBS> wrote in message
> I know this should be so simple, but what would be the code to backstep 1
> column from the active cell?
Norman Harker MVP (Excel)
Excel and Word Function Lists (Classifications, Synt...