Avery labels formats

tford · Post by **tford** » Wed Feb 18, 2009 1:21 pm

Has anyone designed an AwareIM document that will print labels in any of the Avery label formats?

I have an MS Access program that uses Word Mail Merge features that I am going to be converting to AwareIM.

Tom

paddo2002 · Post by **paddo2002** » Wed Mar 04, 2009 3:57 am

Good luck with this one Tom,
I have been going to tackle this one soon too, but haven't worked up the courage to try!!

Let me know how you get on.

Cheers
PM

tford · Post by **tford** » Wed Mar 04, 2009 3:59 am

You first

Tom

tford · Post by **tford** » Sat Mar 14, 2009 2:59 am

I think I'll export from AwareIM to a CSV file, then use Avery's Design & Print Online at:

http://www.avery.com/avery/en_us/Templ ... 6-Software

http://www.avery.com/avery/en_us/Templa ... Online.htm

tford · Post by **tford** » Sat Mar 14, 2009 3:42 pm

Below is one way to have AwareIM and MS Word Mail Merge work together to do labels. I use this approach because all of the layout work of Avery label formats is done by MS Word and saves AwareIM configuration time. Note that once you configure AwareIM/Word with Steps A B & C one time, you simply need to run Step D to produce MS Word Mail Merged labels with AwareIM data:

A- Configuration in AwareIM:
1- Create a BO called Label that has the attributes you want to show on the label

2- Create a Process that will:
...a) FIND ALL Label
...b) EXPORT Label to SystemSetting.LabelPath

where LabelPath is the path + file name with a CSV extension

B- In MS Word (I use MS Word 2003):
1- Create a new Word Doc
2- Tools | Letters and Mailings | Mail Merge
3- Merge Step 1/6 - select "Labels"
4- Merge Step 2/6 - pick the Avery label #
5- Merge Step 3/6 - browse to the csv file created by AwareIM #A2b above
6- Merge Step 4/6 - define where the AwareIM attributes from the CSV will show on 1 label. Then click "Update All Labels"
7- Merge Step 5/6 - Preview the labels
8- Merge Step 6/6 - Print the result

9- Now save the MS Word file to a .Doc extension.

C- Configuration in AwareIM:
1- Create a Document Template called SelectedLabels.
a- Use "Determined at run time"
b- Import the MS Word file from B9 above.

Note that this AwareIM document template will now have a static CSV path. It is critical that you specify the same path in Step A2b above. Otherwise, AwareIM's Document Template will not be able to find the CSV file.

D- Running future mail labels from AwareIM application:
Simply add 1 line to the process in Step A2 above and you will be able to create labels over and over totally within AwareIM:

FIND ALL Label
EXPORT Label to SystemSetting.LabelPath
DISPLAY DOCUMENT SelectedLabels

Of course the FIND action above can be modified if you do not want to print all instances of Label BO.

tford · Post by **tford** » Sat Mar 14, 2009 3:44 pm

One addendum:

After creating Step A in AwareIM, run it one time & create some sample data in the CSV file.

This CSV file will then be used in Step B.

paddo2002 · Post by **paddo2002** » Tue Mar 17, 2009 4:11 am

wow tom,
that is a lot more complicated than I imagined. Did it work?

regards
PM

tford · Post by **tford** » Tue Mar 17, 2009 12:41 pm

PM,

Sure it worked -- otherwise I would not have posted all of the steps.

paddo2002 · Post by **paddo2002** » Wed Mar 25, 2009 5:26 am

Hi Tom,
I just realised again why I didn't get much further with this one. I quickly found that I need to use data from several business objects to get all the attributes on the label. For this, I would probably need a temporary BO or something similar. HMM I had better keep the brain ticking over before I try it.

PM

GertV · Post by **GertV** » Sun Mar 21, 2010 6:33 am

Tom,

Thanks for posting this. I followed all the steps you described, but cannot get it to work. All I get is an empty document in Chrome and IE says the pdf file cannot be opened. I also tried to save the file but when I try to open it with Adobe Reader I get the message that the file is corrupt as well.

Is this still working for you in 4.9 or do you have any idea what could be wrong?