mysql data to excel to outlook

[relisys]

hi all

yes me again

this time asking on how to export mysql data to excel then to outlook

only thing trying to do is export my client link details, name of company email address names ect

i have over 150 people to add or i would add them manuly

so could some one post a step by step guide on how to do it thanks

[relisys]

so it seems it cannot be done then?

[Nathan H]

It may be no-one has a specific solution to your problem,
One thing you could do, though im not sure on the entire script myself is if you follow the guidline below in a php file

open mysql
run a query like "SELECT * FROM TABLE"
echo " headers and <table>"
echo the column titles
for every result from the query
echo row data
echo end tables
close mysql

copy and past the resulting table into mysql (it should put everything into relevant cells

then import from outlook

[relisys]

thanks for the reply, but this as gone well over my head :S

[Nathan H]

What you can do, if you provide the column names etc is ask for someone to script the page for you, if you go to the market place and put up a [REQ] (request) you should be able to find a user who is willing to make the page for you