New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus Ľ Advice and insight from world-class Apple enthusiasts Ľ Exclusive access to members-only contests, giveaways and deals

Join today!

 
Start a Discussion
 

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
OS X - Apps and Games Discussion of applications and games available for Mac OS X.

Applescript


Post Reply New Thread Subscribe

 
Thread Tools
nastyveg

 
Member Since: Jan 20, 2011
Posts: 3
nastyveg is on a distinguished road

nastyveg is offline
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
QUOTE Thanks
sau124

 
sau124's Avatar
 
Member Since: Feb 18, 2010
Posts: 177
sau124 is on a distinguished road

sau124 is offline
you can do some macro work in word/excel (assuming you use word to print labels).

Quote:
up there with the bEst of the bEst....
QUOTE Thanks
nastyveg

 
Member Since: Jan 20, 2011
Posts: 3
nastyveg is on a distinguished road

nastyveg is offline
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
QUOTE Thanks
sau124

 
sau124's Avatar
 
Member Since: Feb 18, 2010
Posts: 177
sau124 is on a distinguished road

sau124 is offline
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.

Quote:
up there with the bEst of the bEst....
QUOTE Thanks

Post Reply New Thread Subscribe


« what program to use for as builts pdf format | Want to get my money back for MS Office 2011 due to unfixable Outlook 2011 problem. »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread
Thread Starter
Forum
Replies
Last Post
help needed to link up buttons on HUD Window to Applescript nick_harambee OS X - Development and Darwin 0 09-30-2010 09:26 AM
newbie question on XCode 3.2: how to populate pop up buttons/link to applescript nickharambee OS X - Operating System 0 10-21-2009 08:10 AM
Logic Express and Applescript via GUI Scripting albertaurus Music, Audio, and Podcasting 0 04-09-2009 02:13 PM
Run applescript on start-up slugzzz Running Windows (or anything else) on your Mac 3 09-11-2007 02:51 AM
[ANN] New comprehensive AppleScript book hanaan OS X - Development and Darwin 0 11-06-2004 08:28 PM

All times are GMT -4. The time now is 07:09 AM.

Powered by vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
X

Welcome to Mac-Forums.com

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!


(4 digit year)

Already a member?