Database wizard - I want to print a list of labels from excel however I can't find the database wizard even though the help file says there is one. I'm using a z4m plus, can you provide directions? thanks
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
The internal memory of the printer is limited. When printing large files the memory is refreshed several times to complete the print job. This is normal.
More information is required so I will only assume you are using Excel as a database. Excel is a spread sheet program used by accountants or for mathematical formulas and ledgers. Access is the Database program, however, Excel has functions which is faster to sort and work with address, phone number, zip codes. I will confess, I use Excel as Database because it is quick and easy. I do not know what version of Excel you are using so I will describe it from Office 2007.From Excel make sure you have headers above each column i.e. First Name in Cell A1 Last Name in Cell B1 Address in Cell C1 ect.
Make sure your data is correct and case sensitive as you would like it. If you want zip+4 select the Colum and right click to format the cells using special and select Zip or Zip+4.
It is easiest to use Microsoft Word for the next step rather than format the cells, add page breaks, and customize the print size.
Save your document as an Excel document where you can find it to import it into Word.
Open word and select Mailings then Start Mail Merge and Step by Step Mail Merge.
Select Envelope and next. Select envelope options to change envelope size, font and print options.
Click on Next Select recipients.
Click on browse under select an existing list.
Select the Excel file with your address information.
From the Select Table check the First row of data contains column headers.
Click on the OK buton.
Arrange your envelope then Preview it and your good to go.
If you have an older version of word selects Tools and click on Mail Merge.
Select Get Data.
Pull down Excel for document type.
Select entire Spread Sheet.
Layout your document and complete the merge.
On old versions of word it may not recognize the Excel file. If this happens open the Excel file and save it as a Database File (.dbf) and it should work.
I hope this helps since I did not have enough information from your question.
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.
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
use the "print from a database" function that the software for the DYMO has. It will allow you to import a database (in this cae your excel spreadsheet) and "map" it to the fields on an address label, like first name, address etc.
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.
AppleWorks is a quirky and hopelessly outdated product. I am aware that a few people have an extreme fondness for it however.
It should only have taken minutes to import data, but don't do it in AppleWorks - they stopped making it years ago and it is unsupported and non-standard.
I have just taken two AppleWorks databases, - one older and one newer that needed to be combined. I exported them as tab delimited text and then imported them into Excel (You could use Apple Numbers - the modern equivalent to AppleWorks). Because the to db's had different headers, I imported them into two different Excel docs first and moved the columns around so the matched first, them copy each column over to the 'master' excel sheet.
You can either use the basic database tools in Excel, or once your data is combined and in this kind of data form, it is easy to import a .xls, or .csv into a new database program, such as Filemaker.
If you do copy over the data to Excel, any merge function - for label printing etc. has to be done in Word (or at least up to Word 2004). I was thrown by this until I realised you have to do this. Once a merge doc is set up with the right labels, it worked beautifully. Typical MS though it is a wholly unintuitive process.
Copy and importing data should be done with attention to care obviously. Make sure you have your original AW files backed up before you start.
I've figured it out!!
what program are you using?
×