Question about Avery Wizard for PC

2 Answers

Avery rounds numbers up in my address fields.

When converting the data in my excel spreadsheet (address-contact list), the new Avery Wizard rounded up addresses. So 2554 1/2 Beachwood Drive ends up being 2255 Beachwood Drive. So I ended up getting a whole lot of my mail returned to me for bad addresses. First it changed the numbers to 2254.5 and then converted that up to the next number 2255. What can I do to get back to the way the old or former Avery Wizard operated?

I have a mailing to do in the morning and am afraid to try to print out labels and have them wrong - there are 875 addresses!

Posted by on

2 Answers

  • 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
  • 326 Answers

Just required to set up the  Avery Wizard again by reinstalling the software and it will work.otherwise it will give the same error.

Posted on Jan 09, 2009

  • 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.

    President:

    An expert whose answer got voted for 500 times.

  • Master
  • 1,314 Answers

Can you try setting it as a text label?

Posted on Jan 09, 2009

  • Kevin Shafer
    Kevin Shafer Jan 09, 2009

    Or put quotes around it...."2435 1/2"

×

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

HOW DO I CREATE A DATA BASE FOR FILE LABELS USING AVERY LABELS 6646? THANK YOU, BARB KOWALSKI


you can do it in excel
then mail merge excel file with
word https://support.office.com/en-us/article/Mail-merge-using-an-Excel-spreadsheet-858c7d7f-5cc0-4ba1-9a7b-0a948fa3d7d3

and use avery template in word
http://www.averyproducts.com.au/avery/en_au/Templates-%26-Software/Templates

Jan 27, 2017 | Avery Office Equipment & Supplies

2 Answers

I have changed my email address ...how do i notify you..??


On any FixYa page, click your username in the upper right corner, click "My Profile," click the "My Account" tab, change the entry in the "Email Address" field, then click the "Save My Information" button.

Sep 29, 2013 | hotmail.com

1 Answer

How do i address envelopes on my lenovo Windows 7 computer


The simplest method of addressing envelopes is to use a word processing application such as Microsoft Word.
If you do not have Word then I would recommend downloading and installing a copy of Kingsoft Office Suite Free 2012 which is compatible with the latest versions of Microsoft Office documents and is free for home users.
Once the application is installed, open Kingsoft Writer 2012 (which is very similar to Microsoft Word).
Click on File then on Page Setup and select the Paper page tab where you can then choose the Paper size to use for your envelopes.
In the Paper size drop down selection listing, choose an envelope size such as C6 Env.
If you are unsure which option to choose, then simply measure the size of the envelopes you are wanting to print on and set the Width and Height values (in centimetres) to match that size.
Next switch back to the Margins page and select the Orientation that you want to use for your envelopes, i.e. Landscape or Portrait.
On this same page you can also increase the Margins to position your address text more centrally on the envelope.
Click on OK to exit Page Setup.
Type your address on the main Kingsoft Writer page and you are ready to print the envelope on your printer.
Kingsoft Writer can also use Mail Merge to write a series of addresses on a stack of envelopes if you need to write a number of addresses.
Simply create a list of your addresses in the Kingsoft Spreadsheets application, putting each 'address field' in a separate 'box' in the new spreadsheet so that you have a column each of 'Names', 'Address line 1', Address line 2, Town, County, Post code etc.
Then in Writer, click on Tools, Mail Merge toolbar, then in the toolbar, click on the left icon to Select Data Source and select your addresses spreadsheet document.
Next, click on the icon for Insert Merge Field and select all the address fields to insert into your new Envelope document.
Finally, adjust the layout of the fields by moving fields on to new lines as needed. You can also change the font and character size of the new address fields to make the text larger or bolder etc.
Last of all, click on the icon for View Merged Data which will show you what your addresses will look like when printed on the envelopes - you can step through the list of addresses using the controls in the toolbar.

Dec 23, 2011 | Lenovo Computers & Internet

1 Answer

I have installed Avery for my Word 2007. I am trying to do labels from an existing excel spreadsheet, also 2007, and when I get to the point to select from existing file it says there was an errora and...


Jill (guerinje),

I might have a solution for you.

I recently ran into this issue as well. When using the Avery Wizard (Avery Wizard 4.01 - US 20111209.exe), I was able to select the Avery Product template, the customization Design, and could select the 'Merge data from an existing data file' option, but when I clicked 'Next' to continue, I got an aborted list of recently used data files and then an error pop-up stating that the Avery Wizard encountered an error and needed to close. There was also the option of notifying Microsoft of the error.

Here is the solution that worked for me - TAKE CARE - This solution makes changes to the computer's Registry: WARNING: Using Registry Editor incorrectly can cause serious problems that may require you to reinstall Windows.

These instruction are for Windows XP. Other operating systems will most likely require adjustments to the steps below.

Step 1: Open the Registry Editor: Click the Start Button -- Select 'Run...' -- Type regedit -- Click 'OK'

Step 2: Select the Registry Entry: In the Left-Hand pane of the Registry Editor, double click on 'HKEY_CURRENT_USER', then on 'SOFTWARE', then 'Avery', then 'Avery Assistant', then '4.0', then single click on 'Recent Data Files'.

Step 3: Backup the Registry Entry: On the 'File' menu, select 'Export...' -- Select your Desktop for the 'Save in:' field -- Enter a name for the backup of this registry entry: I used 'Avery Recent Data Files' -- Make sure the 'Save as type:' is Registration Files (*.reg) -- click the 'Save' button.

Step 4: Delete the Registry Entry: In the Right-Hand pane of the Registry Editor, ignore the entry for '(Default)', select the entry for File1, hold down the 'Shift' key on your keyboard and then select the last file value (for me it was File9 - File10 was actually listed between File1 and File2) -- When all the File entries are selected, right click on them and select 'Delete'.

Step 5: Exit the Registry Editor: Either Select the File menu's Exit option or click the red 'X' button in the upper right corner of the Registry Editor Window.

Step 6: Restart the computer

Step 7: Login again

Step 8: Test the Avery Wizard in Word to verify it works. If it does not work: You should restore the registry values you deleted by double clicking on the 'Avery Recent Data Files.reg' backup that you saved to the desktop in Step 3.

Step 9: If the Avery Wizard works again: You can delete the 'Avery Recent Data Files.reg' backup that you saved to the desktop in Step 3.

And that's it. This process worked on the two computers that were having this issue at my office. Hopefully it will work for you as well.

Good Luck,
fnis

Apr 14, 2011 | Avery Wizard for PC

1 Answer

Not Enough Memory to run Microsoft Office Excel. Please close other Applications and try again..


Excel running on a 32 bit PC and using a 32 bit operating system can only address 2 Gb of RAM. If your machine has a 64 bit processor (these were being shipped over 5 years ago) it will be possible to install a 64 bit operating system such as Windows XP 64 bit or Windows 7 64 bit. It has been claimed that an Excel 2010 spreadsheet, running on a 64 bit machine and using Windows 7 64 bit, was able to load and use a database with 100 million records.

If you are unable to do this then I suggest that you examine what your machine is running at the same time as your spreadsheet and if any part of the spreadsheet can be off-loaded. By the latter I mean can any of it transferred to another Excel file?

Are you using any links on your spreadsheet, if so can the links be converted into data, e.g. a link to a lookuptable could be converted to data (copy, paste-special, value) and this remove a significant amount of processing load.

Oct 18, 2010 | Microsoft Excel for PC

1 Answer

When I try to merge my excel document with 250


Hi deloisr

It looks like you have chosen the wrong data file. Probably an earlier version of your data still present in some folder.
Check these
Do you have column headings for every column?
Make sure which folder contain the file? What exactly is the name?
When you are in the Microsoft word, make sure you select the correct data file for your mail merge. If you have selected the correct data file, when you attempt to insert the merge fields, there is no way, it give wrong field names.
The only reason you get the erong field names is because you have the wrong excel file for your data. Fix this problem first, then the rest will sort themselves out.
Have a good day.
luciana44

Nov 09, 2009 | Microsoft Computers & Internet

1 Answer

I am having problems with a mail merge for tent card 5302 - can someone tell me how to merge an exisiting excel document into word?


In Word 2003:
Open the Tools Menu >> Letters and Mailings >> Mail Merge.
Select Labels and click Next
Click on Label Options and select your tent card and click OK and then Next
Select Use Existing List and click Browse to find your Excel document. Click Next.
Add in the fields you want on your cards to the first and then click Update All Labels.
Finish Mail Merge Wizard.
-- Word 2003 doesn't come with the 5302 label template. You'll need to download that from http://support.microsoft.com

In Word 2007
Select Mailings from the menu list at the top,
Click on Start Mail Merge and select Labels
Select Label vendor Avery US Letter
Select your product number 5302 and click OK
Click on Select Recipients from the top and select Use Existing List to browse to your Excel document
Using the buttons on the top for Address Block/Greeting/etc add in the fields you want to the first label.
Click on Update Labels
Click on Finish and Merge

Apr 28, 2009 | Computers & Internet

1 Answer

Convert figures to numbers on Mac


The easiest I can think of converting numbers into text in 2 colums is using a LOOKUP function in Excel. I have no knowledge of the range of numbers you are working with though so it may sound easier than it is...

Mar 25, 2009 | Apple Computers & Internet

1 Answer

Incomplete synchronisation of contact list


If it is MS office software on the PDA the fields should convert. Problems arrive with different versions though. What is the Software you are using on the PDA? (and version, and version of win)?

Jun 09, 2008 | Sharp Wizard OZ-290

1 Answer

Mail Merge Print Problem


Was a recipient address created in an Excel spreadsheet or a database? Data needs to be pulled from somehwere to be added to the envelope.

Dec 05, 2007 | Dell Latitude D800 Notebook

Not finding what you are looking for?
Avery Wizard for PC Logo

Related Topics:

27 people viewed this question

Ask a Question

Usually answered in minutes!

Top Avery Computers & Internet Experts

Donna Sander

Level 2 Expert

193 Answers

NIK
NIK

Level 2 Expert

206 Answers

Ronald Connal
Ronald Connal

Level 2 Expert

140 Answers

Are you an Avery Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...