Hi there,
I'll be working on a project soon which will involve outputting a list of names and addresses from a database, these will then be used in an MS Word Mail Merge. I need to know how best to create the file for use as a datasource in the MM.
So far I have found that a fairly easy method is to output a txt file which contains a tab delimited list of the names and addresses. This can then be used as a datasource in MSWord, afterwhich fields can be selected and the Mail Merge created.
I've not coded any of this so far, I've only created the text file manually. I was wondering though, how do you get carriage returns into the address? At the moment when I used the file, the addresses all appear on one line?
Thanks,
Chromis
I'll be working on a project soon which will involve outputting a list of names and addresses from a database, these will then be used in an MS Word Mail Merge. I need to know how best to create the file for use as a datasource in the MM.
So far I have found that a fairly easy method is to output a txt file which contains a tab delimited list of the names and addresses. This can then be used as a datasource in MSWord, afterwhich fields can be selected and the Mail Merge created.
I've not coded any of this so far, I've only created the text file manually. I was wondering though, how do you get carriage returns into the address? At the moment when I used the file, the addresses all appear on one line?
Thanks,
Chromis