Mac Help Forums


Reply
Thread Tools Display Modes

Automator --> Microsoft Excel

 
New Member
Join Date: Sep 2010
Posts: 1
 
      28th September 2010
I am trying to use automator to automate a sign in process at my seminars. This is what I would like to accomplish:

1) Collect attendee's name, phone #, email, address. and all info to an excel spreadsheet.
2) Print Name Tag for attendee.
3) Take Picture of attendee.
4) Start Screen Saver of pictures of attendees.

This is what I have so far:

Collect Info:
Action: Ask For Text - First Name
Action: Set Value of Variable - <First Name>
Action: Ask For Text - Last Name
Action: Set Value of Variable - <Last Name>
Action: Ask For Text - Phone Number
Action: Set Value of Variable - <Phone Number>
Action: Ask For Text - Email
Action: Set Value of Variable - <Email>
Action: Ask For Text - Address
Action: Set Value of Variable - <Address>

Take Picture:
Action: Take Video Snapshot - Save as: <Last Name> <First Name>.tiff
- Where: Seminar Pix
- Take Picture Automatically is checked

Start Screen Saver:
Action: Start Screen Saver - set to <Seminar Pix> folder

Action: Loop - for duration of seminar

everything seems to be working so far, though I've not even tried the name tag part yet.

Here's my Problem: I can't seem to figure out how to get the text entered in the "ask-for-text" actions to be pasted into excel. is this even possible?


 
Reply With Quote
 
 
 
Reply

Thread Tools
Display Modes

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Microsoft Excel: looping through cells Aerial AppleScript 8 28th March 2011 09:44 PM
Mac OS X 10.2: Remove Microsoft Office v.X Test Drive before installing Microsoft Off Newsbot Apple News 0 26th August 2008 07:11 PM
Microsoft Excel 2008 and Applescript UnisonMac AppleScript 1 27th February 2008 10:53 AM
Free Microsoft Excel 5.0/ Sensory Overload/ JAG II JoshW UK Macs 1 9th January 2006 09:06 AM
Mac Excel vs. Windows EXCEL FRANCISCO PEREZ-LANDAETA Apps 3 23rd December 2003 09:45 PM


All times are GMT +1. The time now is 12:03 AM.
Mac-Help.com is an independent website and is not affiliated with Apple Inc.


Welcome!
Welcome to the Mac Help Forums
 


Latest Threads
Using Terminal to move my iTunes and GarageBand libraries to an external?
corbytender (1 Hour Ago, 10:51 PM)

itunes message
leondpap (3 Hours Ago, 08:12 PM)

Excel
Shell (5 Hours Ago, 06:46 PM)

how do you carry your MacBook?
SwampWitch (5 Hours Ago, 06:39 PM)

Macbook Pro (Intel), OSX Lion, and Microsoft Exchange 2003 - NO SOLUTION
BigBossCorin (10 Hours Ago, 01:55 PM)

 


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51