Automator --> Microsoft Excel

Joined
Sep 28, 2010
Messages
1
Reaction score
0
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?


:confused:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top