For example i have several names/email address in excel I would like to transfer into my address book as one specific group without typing them individually,  Like 500 of them, can some one help?  They must show the persons name in the "TO" and there email only when I mail.  HELP!
134326
You could create a "Distribution List". If you're using MS Outlook 2000, you could follow these steps:\n1. Open Outlook and click on "File" then "New".\n2. Select Distribution List.\n3. Enter a name for the distribution list.\n4. Click on "Select Members" button if the e-mail addresses are already in your contacts or click on "Add New" button, to add an e-mail address at a time.\n5. Save.\n\nThe next time you send an e-mail to this group, all you need to enter in the "to" field is the name of the distribution list and the e-mail will be sent to all members under this group.\n\nYou could also use "Import" to upload bulk e-mail addresses from Excel (CSV file format) in Outlook. Just check on the Help section to know more information about this.\n\nHope this helps.
15819
Yahoo e-mailing actually has a new feature that allows you to create groups of contacts.  Go to address.yahoo.com, then add all the contacts to your address book.  Then click add list in the menubar and then all you have to do is use the window that pops up to put all the people you want in the list.  Now whatever you title the list is now what you type into the address field in the compose window.  Hope that is understandable and that helps you.
227868
Yes. If you have online accounts Individually set them to recieve only mail from address book and outlook will only recieve the same. Outlook isnt what i prefer.
89708
I think you're trying to do this:\n\n1) Open a new Excel file\n\n2) Click Insert > Object \n\n3) Select the Create from file tab\n\n4) Click browse and browse to the Word doc.\n\nAlternatively, a copy and edit>paste special would probably  also do what you're wanting.\n\n>\n\nAre all 13 pages the same labels?  If so, then just copy everything on the first page of the Excel worksheet (CTRL-C) and paste it normally into 12 more pages with CTRL-V.\n\nIf not, then unfortunately you're probably going to have to copy each page of the Word doc and paste special into Excel.  \n\nAlso, when you paste into Excel, you might look at the paste options by clicking on the paste options button that comes up right next to the cell that you pasted the information.  There is a wizard in there that might make the labels look better than otherwise.
60859
The first thing I suggest is to use the MICROSOFT OUTLOOK.\nIn the OUTLOOK EXPRESS to copy all your mail contacts & address book.  First open the outlook express.  Go to the \nTOOLS -> OPTIONS -> MAINTENANCE TAB -> STORE FOLDER.  There you will be able to see the full folder details of your complete outlook express mail contacts.  Copy the the folder address.  Then close the Outlook Express.  Go to the C: folder paste the copied address in the address bar & press enter.  You will find all your mail contacts in the dbx format.  Now go to the address bar again.  Delete the word Outlook Express from the last.  And press enter.  Now the folder of Outlook Express mails would appear.  Select the folder & write to the CD.  \n\nTo export the Address Book:  Open the Outlook Express.  \nSelect the Addresses Icon from the toolbar.\nFILE -> EXPORT -> SELECT THE FILE OR FOLDER OR THE CD DRIVE TO EXPORT.\n\nI hope this would solve your prob.
649848
Sounds like VLOOKUP is what you are looking for.\n\nFor example, I have will have a sheet that has a list of months in one column and in the second column I have the group that is responsible for something in the corresponding month.\n\n(ignore the dashes, they are for spacing only)\n----A------B  \n1--Jan--Team 1\n2--Feb--Team 2\n3--Mar--Team 3\n\nNow you would write the VLOOKUP formula:\nLets put =VLOOKUP(C1,A1:B12,2,) in C2\nif you typed Feb in C1, the formula in C2 will return "Team 2"
136879
First of all, make sure your lists in Excel have headings on the columns.  For example, line "A" needs to say First Name, Last Name, Street City, State, Zip, etc.  This tells Word what type of info it is looking at. Do this to the best of your ability, depending on how you set up your sheet.  If you combined some of it, don't worry and then follow the next steps...\n\nOk, go into Word and choose "Tools" "Letters and Mailings" and "Mail Merge."  When the mail merge wizard opens on the right, choose "labels."  Click "next"  Then choose label options.  Go in and tell it what type of labels you are using, etc.  You should be able to choose the Avery Label and # so it knows what it is printing on.  Then click "next" It should open up a page of blank labels and your next step should be choosing recipients.\n\nClick the "browse" link under "existing list" in the "select recipients" page.  Go through the browse and open your Excel mailing list.  Once you select that, you click "next" to arrange your labels.   There will be a group of options such as "address block" "greeting line" etc. on the right. Set up your "address block" on your labels by clicking the link then positioning it on the label where you want it.\n\nThen, choose the "more" link under the "address block" "greeting line" etc. and a window will pop up.  There will be a button it it that says "Match Fields."  Yours may work a little differently, but you need to find the "Match Fields" in case you need to tell Word which columns in your spreadsheet conatain what info.  For example, if you put the city, state, and zip in one column, you can go in and tell it to use that column for that part of the address.  This is where you tell Word which info to use for the labels.\n\nOnce you get all that meshed correctly, you should be able to preview your labels and all should be well.  If not, check back into the arrange labels part and fix what you need to fix.\n\nI hope that helps!
34127
Yes, \nAddress the email to yourslef and use the BCC (blind carbon copy) function in your email software's address section to add all the other names.\n\nThe people on the BCC list will only see the email as being addressed to you.  \n\nExample:\n\nTO:  Me\nBCC:  Myfriend1; myfriend2; myfriend3
30400
You can choose to use your email address for a name, or you can use a 'nickname'. The nicknames are not unique here, because they are tied to your email name.\n\nSo everyone on here could use Nelly if they wanted.\n\nTry it...
597709
You could add a temporary number column and use autofill to fill it down to the row which contains the last of your name data.\n\nSelect both this column and your name column and sort the name column alphabetically (ascending). Delete the blank rows (which should now be at the top) and then re-sort (ascending) by your temporary number column.\n\nThen delete the temporary number column.
620701
This is similar to changing to a new apartment or new house on the same street...\nYour mail needs to know where to go and so does the mail man...\nNow with email the email needs the right address also, so you will have to create a new email address and then send out all new letters to all on your list or they wont know where to write to you and the mail will get bounced...
645380
I have three.  The first is a Yahoo account that only friends and family have the address to.  The second is a Yahoo account that I use when I sign up for e-newsletters and such.  I get a lot of junk in that one.  And the third is an account from my college.  That one is used for school-related correspondence only.  If I only had one address, it would be a pain to sort though it every day!
616009
This is not a simple question to easily be answered.  First, the 'data' must be established in Excel.  Obtain the different fields of information and place each into it's own column.  Sep-10, Chicago, GreenBay.  Place the data beginning down a ways like row 15, and column D.  Label each column with a heading and keep the label simple: Begin with a letter, no more than 8 characters, no blanks, no spaces, meaningful to content, and not a reserved word (Excel command like SUM).  Then highlight the entire data range you placed and choose the INSERT-NAME-DEFINE and type database.  Then you can Go to the Heading line and highlight that line and copy to row 2 immediately above and paste it and also below the bottom line and leave 10-15 empty lines and paste the heading line again.  The top area should be INSERT-NAME-DEFINE and type Criteria.  The bottom area should be INSERT-NAME-DEFINE and type Extract.  When you define the Criteria you should include one blank line immediately below that heading line where you can place criteria that you would like to extract to the extract area from your 'Database".  The Extract area is just the data on the copied header line.  You place information like "Giants" under the FIRSTTEAM column and then on the Excel menu you select DATA-FILTER-ADVANCE FILTER-COPY TO ANOTHER LOCATION - UNIQUE RECORDS ONLY - OK and all the 'Giants' information will be copied to the extract area.  You can UNDO a selection by DATA-FILTER-SHOW ALL.  \n\nThis is the Database feature within Excel and is simple to setup and very useful to extract many types of data.
302229
Yahoo has a feature where you can assign a unique email address that you can give to special people or companies without divulging your real address..\n\nEX:  Say your id is :   yourname@yahoo.com  You can assign yournameemail-wal-mart@yahoo.com.  \n\nWhen you get email to that address you know it is from wal-mart so that you will know if they gave out your name to others.\n\nI think it is in the options feature of yahoo under "addressguard".  check it out.
173706
It is like you want to backup your contacts. Right !(If you are using Yahoo! Messenger)\nAll you have to do is save all your friends in messengger to your Yahoo Address Book by right-clicking on the friends save his contacts to your address book. You then log -in to Yahoo! Mail and Export your address book to CSV format . Click Address Book and top right you can find Import/Export link. Then proceeds\n\nYou can read more on exporting and importing back your address book
540615
You can use two profiles, go to file and Manage identities, then switch to the new identity to use the new display name.  You do have to recreate the account though, or go to tools menu, accounts, and export your current account to your hard drive, and switch identities and import it into the new one, and then just change the display name.\nyou could also have just one identity, with two mail accounts setup, each with a different display name.  Then when you send a mail, you can select an account to send from in the compose window.  This gets messy though, as you can get duplicate mails and other such headaches.
586466
Yes there is a way to do this, but you'll have to split the master document up into about 4 spreadsheets.  There's only one good way of doing this if you don't want to spend years matching these together and that is with a macro.  The problem is that macros take a descent little bit of expertise to develop.  So it's time for me to give you a crash course in macros.  First you need to make sure that your security level in Excel for macros is set to Medium or Low.  From the menu bar, go to Tools, Macro, Security.  Reset it to Medium save the file, then restart Excel.  Excel needs to be restarted for the change to take effect.  Now on to creating macros.  Go to Tools, Macro, Record New Macro.  Pick a name for your macro then click OK.  Don't do anything whatsoever to the Excel workbook, just click the stop button.  This creates basically a blank macro named Macro1 or whatever you called it in your workbook.  Now we want to go edit that macro.  Go to Tools, Macro, Macros.  \n\nNow select your macro and click Edit.  Now past the following text in as macro code:\n\n'Set column A to your part number and column B to your lead time\nFor Each x In [Doc2! A:A]           'Looks through every cell in column A in a worksheet called Doc2\n    If x.FormulaR1C1 = "" Then      'Tells computer to end the search if it reaches\n        Exit For                    'a blank cell in column A of Doc2\n    End If\n    \n    For Each y In [Doc1! A:A]       'Looks through every cell in column A in a worksheet called Doc1\n        If y.FormulaR1C1 = "" Then  'Tells computer to go to the next part number in Doc2 if it reaches\n            Exit For                'a blank cell in column A of Doc1\n        End If\n        \n        If x.FormulaR1C1 = y.FormulaR1C1 Then           'Compares the part numbers to see if they match\n            x.Offset(0, 1).Value = y.Offset(0, 1).Value 'Sets column B in Doc2 equal to column B in Doc1 (your lead times)\n            Exit For                                    'Moves to next part number in Doc2\n        End If\n    Next y  'Moves to next part number in Doc1\nNext x      'Moves to next part number in Doc2\n\n\nEverything after an apostrophe is comments and will appear green.  This will have no affect on how the macro runs.  You will need to modify the macro or you worksheets so the macro works properly.  The code gets pasted between the Sub Macroname and End Sub portions.  The comments I listed should help you understand how the macro works.  Here's something REALLY IMPORTANT!!!  Save your workbook BEFORE you run the macro.  You can't undo what a macro does by hitting the undo button.  So if it doesn't do what you want, simply close the file without saving it.\n\nContact me, I probably need to explain a few more things too you.  Since your master list is over one spreadsheet long there are going to be some complications you'll have to work through that could make it very difficult, even for a macro.  \n\nMacros can save hours or days of time, but they can be difficult to a new user.  The Visual Basic 6 Blackbook by Coriolis is a good reference guide if you want to learn to write macros in Excel.  Just remember the coding may be a little different in Excel than for writing a program in VB6.