Question about Microsoft Office Professional 2007 Full Version for PC

2 Answers

Have database in Excel - Want to print labels on Avery 6150. hOW?

I am familiar with Microsoft Works and how to set up labels using wdb and wps files. Can't figure how to apply this to Excel and Word in Microsoft Professional 2007. I have a database that I downloaded in the excel format and would like instructions on how to set up and print labels using Word or some other program in MS Office 2007.

Posted by on

2 Answers

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Genius:

    An expert who has answered 1,000 questions.

  • Master
  • 1,011 Answers

Sir,

Check this link http://word.mvps.org/FAQs/MailMerge/

also click this link

thanks
good luck

Posted on Dec 16, 2008

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Sergeant:

    An expert that has over 500 points.

    Novelist:

    An expert who has written 50 answers of more than 400 characters.

  • Expert
  • 327 Answers

Http://office.microsoft.com/en-us/excel/HP052037601033.aspx
just click the above link and follow the instructions.

Posted on Dec 16, 2008

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Create labels on Word 7 with Avery 8250 labels


I am assuming that you want to do a mail merge from a list.

If you list is in Excel, you should be able to click mailings in Word. It will take you through the steps to create your set of labels. [It will help with other places for your lists besides Excel, too.

May 24, 2010 | Business & Productivity Software

1 Answer

I have several address stored in Excel. Now I


You don't need to print labels in Excel. You can use the mail merge feature in Word to do so. Use the Excel file as the data.

Nov 06, 2009 | Microsoft Excel for PC

1 Answer

Printing Avery Labels


click on "mailings" then labels. Then set up your lables

May 27, 2009 | Microsoft Office Word 2007 Full Version...

1 Answer

Using Microsoft Query to bring Access 2007 data into a spreadsheet


Try using Data > From Other Sources and select From Microsoft Query. In the Excel sheet, select the cell that you want the results to start in. Your MS Query would be pulling the data from your Access database.

May 04, 2009 | Microsoft Excel for PC

1 Answer

I need to convert a wdb file to a Doc file


Open the filie in Works. File>Save As...Set file type to Microsoft Word

Apr 11, 2009 | Microsoft Works Suite 2005 for PC

1 Answer

Can only print one label when I set up Avery Labels


Hi. Look at the label contents. I believe the top corners of the group is touching the header. Meaning it should only print 1 time.
Make the content smaller and be sure it is inside the body area.

Jan 23, 2009 | FileMaker Pro 7 for Mac, PC

1 Answer

How to connect my database to my project?


use Excel library at following location.

D:\Program Files\Microsoft Office\Office12\EXCEL.EXE
Microsoft Excel 12.0 Object Library

Jan 05, 2009 | Microsoft Office Standard for PC

2 Answers

Steps in saving file in excel to database


severals solution :
- save file as text separated by comma and use sqloader from oracle
- use function in excel to concatenate insert order : "insert into TABLE_NAME (field1,...,fieldn) values (A1,B1,...,??n);". Save file as text with sql extension. Connect against roacle db and execute file previously saved.
- use ODBC from MicroSoft

Dec 11, 2008 | Microsoft Business & Productivity Software

1 Answer

If function in exel


For Current Date - you can use the =Now() function in your cell where you want the date.

For Contract #, I don't know what you're using, but you can link to a database of contract #s (see below), or you can name a range like current contract #, which gets updated by 1 each time you add another contract, which then is automatically posted on your EXCEL



DGET(database,field,criteria)
Database is the range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column.
Field indicates which column is used in the function. Enter the column label enclosed between double quotation marks, such as "Age" or "Yield," or a number (without quotation marks) that represents the position of the column within the list: 1 for the first column, 2 for the second column, and so on.
Criteria is the range of cells that contains the conditions that you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label in which you specify a condition for the column.

Jul 15, 2008 | Microsoft Excel for PC

Not finding what you are looking for?
Microsoft Office Professional 2007 Full Version for PC Logo

Related Topics:

91 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18297 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...