Albert Kallal's for foreign characters

[GiPSyFiSH]

About me:

Hi, since I'm new here, short introduction:

I'm from Belgium, living in Thailand. Working as an English Teacher, but hopefully that will change soon.

I'm not new to databases, but fairly inexperienced using vba coding. I'm fairly computer literate however and keen to earn more.

I am making a database that will run the administrative part of a government run foreign teacher recruiting division.

Running Office 2013 (and yes, it is overly bright), have used 2003,2007, 2010

The issue:
I need to do mail merges, with lots of different sql's and templates. I have been using Albert Kallal's method and it works well.

However, some of my data is in THAI. And (I think) because this method exports to a .txt file first (.888) the data gets lost and shows as question marks.

Manual merge works fine.

Now, ideally, if I could export to xls in stead of .txt and use that as my merge source, that would work fine, but I have no idea what part of the code would have to be changed.

At the moment I'm building from scratch but it cheer madness, took me a day just to get the export to excel running... Let alone setting up the merge, building a dialogue for selecting the template and allowing different sql's to be passed...

Someone that knows this code and knows what to change, please help.

Basically:
- export to xls in stead of the .888 file
- use the xls file as a datasource for the merge

I believe everything else can be left intact.

Cheers

 

[GiPSyFiSH]

Nevermind,

I started building from scratch.

Exported to a word table and using that as a source for the merge seemed to work best, surprisingly.

No I have the export and merge working, I need to bind it together and make an interface for multiple templates that allows to edit, delete and create them.

Guess I learned a lot more this way.

Anyway, thanks to the people that at least read my post I understand it wasn't a very evident question.

Close please