Atomic Avenue Label Printing
by Peter Bickford
Not long after I started selling my own books on Atomic Avenue, I began to realize that I’m pretty much rubbish at any sort of repetitive process with a lot of steps…like, say, shipping out comic book orders. To help eliminate as many steps from the shipping process as possible, I came up with this macro which kick in whenever I get an order in my Outlook mail box.
Now, whenever an Atomic Avenue order arrives, my default printer automatically prints out the packing slip and shipping information that was mailed to me. It also prints a shipping label on my Dymo Labelwriter for that order, marked with the order number and noting if it’s an Express Saver shipping order so that I know to stick on extra postage.
Afterward, all I have to do is put the comics and packing slip in a box, slap on the label, and stick on the postage (or run it to the Post office).
What You’ll Need
- Microsoft Outlook as your email client
- A printer, preferably loaded with regular paper
- A Dymo Labelwriter, loaded with shipping labels
Setting It Up
- Download and unzip the AA_Label_Printing folder containing the various parts you'll need to your desktop (you can delete this folder when you’re done). Open that folder up.
- Copy the Atomic Avenue Sale.LWL label file to the folder on your hard drive:
C:\Documents and Settings\All Users\Documents\DYMO Label\Label Files
- Install the Dymo Label SDK
- Open the Redemption folder and install the free “Outlook Redemption” library which lets Outlook safely work with mail messages without triggering all sorts of security messages under later versions of Windows. Once you’ve downloaded Redemption.zip (preferably to your desktop), double-click on it, then double-click the Install file to install Redemption on your system. (For more about Redemption and writing code for Outlook see http://www.dimastr.com/redemption/)
- Copy the VBAProject.otm file to the folder:
C:\Documents and Settings\<your login>\Application Data\Microsoft\Outlook
If you don’t see the Application Data folder, go Windows explorer and choose Tools -> Folder Options, click the View tab, then click “Show hidden files and folders” to show it. You can change this setting back to “Do not show hidden files and folders” when you’re done if you like.
Important: When copying the VBAProject.otm file, do not replace any file by the same name that’s already there.
(This would only occur if you’ve previously written your own macros in Outlook). If that happens, you should instead launch Outlook, go to the Visual Basic editor (Tools -> Macros -> Visual Basic), then Import the Module1.bas file into your existing project. You may also have to adjust the macro names in the mail rules in step 7)
- Add a reference to Redemption to your copy of Outlook. To do this,
- Launch your copy of Outlook and choose Tools -> Macros -> Visual Basic Editor.
- Choose Tools -> References, then check off the “SafeOutlook Library” reference from the (rather lengthy) list of available references.
- Launch your copy of Outlook and choose Tools -> Rules and Alerts, then click Options. Click Import Rules and choose the Print Atomic Avenue Label.rwz file from the AA_Label_Printing.