Link to home
Create AccountLog in
Avatar of Starquest321
Starquest321

asked on

Contact Sync - mysql to Outlook

I would like to write a little scipt that would allow a "sync" of the contacts from a mysql datbase to Outlook. Is that possible?
Avatar of striker46
striker46
Flag of Germany image

You could write a script which retrieves values from the database and writes them to a text file. You can import into Outlook CSV files, namely text files with the data separated with ;
Rename the text file generated by your script to .CSV instead of .TXT and import.

I recommend you export some sample contacts with the desired fields to a test file in your computer, then you open it with notepad or any other text editor to see how Outlook formats the values and separates them with ;. Then you'll see how you must make the script write the files...

Regards
ASKER CERTIFIED SOLUTION
Avatar of striker46
striker46
Flag of Germany image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Starquest321
Starquest321

ASKER

But the question: Can I do it directly to Outlook?
Automatically/directly, not this way. You still need to manually import the contacts stored in the CSV file to Outlook manually, from Outlook itself.

If there are other ways to do that (automatically or not), I ignore it.

Regards
So what's the automatic way?