Results 1 to 4 of 4

Thread: Applescript

  1. #1
    Applescript

    Member Since
    Jan 20, 2011
    Posts
    3
    Applescript
    Hi, Can anyone help?
    I have some files supplied to me(200 a week) which i print. I then have to post them to different addresses.
    Heres the question, The 1st 5 letters/numbers(ie M1234) on the files represent an address which is in a database supplied to me in excel(this excel database has over 2000 addresses in it). Can anyone help me or tell me how to get some kind of script that will take the code from the files and select them out of the database? This is a weekly thing and not always the same addresses. At the moment i am doing a 'find' for the code in excel and then copy and pasting into a new document so i can print labels.
    Is this something that can be done?

    Also are you able to tell it that their is a duplicate address, so it doesn't print 2 of the same label?
    PS i am not familiar at all with scripting so if you could give me advice in the simplest terms, that would be great.
    Hope someone can help!
    Thanks in advance

  2. #2
    Applescript
    sau124's Avatar
    Member Since
    Feb 18, 2010
    Posts
    177
    you can do some macro work in word/excel (assuming you use word to print labels).
    up there with the bEst of the bEst....

  3. #3
    Applescript

    Member Since
    Jan 20, 2011
    Posts
    3
    Applescript
    I use Quark for labels at the moment, but i will use word if it makes it easier.
    Do you know how your idea is done?
    I know nowt about macros!

    thanks for the reply

  4. #4
    Applescript
    sau124's Avatar
    Member Since
    Feb 18, 2010
    Posts
    177
    a simple vlookup formula in excel will help you find the people in the list. Save the file and mailing option in word will help print labels.
    up there with the bEst of the bEst....

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Applescript
    By EdMarx in forum OS X - Apps and Games
    Replies: 0
    Last Post: 02-10-2012, 04:06 AM
  2. Applescript
    By SgtDave in forum OS X - Development and Darwin
    Replies: 6
    Last Post: 01-19-2011, 03:50 PM
  3. Applescript help please?
    By thtguyjosh in forum OS X - Apps and Games
    Replies: 8
    Last Post: 08-22-2010, 07:22 PM
  4. Applescript
    By nixonbw in forum OS X - Operating System
    Replies: 0
    Last Post: 07-17-2008, 07:00 PM
  5. AppleScript
    By TehHero in forum OS X - Apps and Games
    Replies: 0
    Last Post: 01-26-2008, 09:46 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •