drpete
January 30, 2007, 5:23pm
#1
Hi MacScripter,
I need to makes inquiries from address book into Microsoft Excel. When I have established the person exists in my address book I want to check a .xls document and the send some data to the member.
For example: my database would look like this:-
Monday
07:00
Abbott
www.internet.com/abbott
10:00
Costello
www.internet.com/Costello
12:45
Hancock
www.internet.com/Hancock
13:00
Sellers
www.internet.com/Sellers
Tuesday
07:00
Abbott
www.internet.com/abbott
10:00
Costello
www.internet.com/Costello
12:45
Hancock
www.internet.com/Hancock
13:00
Sellers
www.internet.com/Sellers
Wednesday
07:00
Abbott
www.internet.com/abbott
10:00
Costello
www.internet.com/Costello
12:45
Hancock
www.internet.com/Hancock
13:00
Sellers
www.internet.com/Sellers
For example: the data I send to address book is:-
marx@email.net , Database1, Monday, 9.43
at that time the answer would be:-
Abbott
www.internet.com/abbott
I could then send that to marx@email.net
How would I get the URL if it is a hyperlink in Excel and not a separate field?
I hope you can help me with some of this. I was quite successful getting applescript to manipulate Address Book. But Excel looks daunting!
Reagrds drPETE
Excel is daunting. What version are you using - X and 2004 are quite different from a scripter’s point of view.
drpete
January 30, 2007, 6:11pm
#3
Hi Adam,
Excel 2004 for Mac version 11
Do I actually have to integrate Address Book? Can I have another part of the database with the users names and email addresses?
Regards Pete
drpete
January 30, 2007, 7:12pm
#5
My Excel 2004 now looks like this:-
Monday Tuesday Wednesday MEMBER EMAIL
07:00 07:00 07:00 Marx Brothers marx@skipzone.co.uk
Abbott Abbott Abbott Russ Abbott Abbott@skipzone.co.uk
www./abbott www./abbott www./abbott Lou Costello costello@skipzone.co.uk >
10:00 10:00 10:00 Tony Hancock hancock@skipzone.co.uk >
Costello Costello Costello Peter Sellers sellers@skipzone.co.uk >
www./Costello www./Costello www./Costello Charlie Chaplin chaplin@skipzone.co.uk >
12:45 12:45 12:45 Buster Keaton keaton@skipzone.co.uk >
Hancock Hancock Hancock Whoopi Goldberg goldberg@skipzone.co.uk >
www./Hancock www./Hancock www./Hancock Peter Cook cook@skipzone.co.uk >
13:00 13:00 13:00 Tommy Cooper cooper@skipzone.co.uk >
Sellers Sellers Sellers
www./Sellers www./Sellers www./Sellers
So for example:- When I get an email at 9.53 Tuesday with subject ‘Lou Costello’ a mail rule triggers applescript to open desktop havingalaugh.xls find the email address for the sender and then perform a day/time query to find the ‘show’ and associated URL then send result to the new mail address.
I am going to make a start with the easy bits. Please Help!