How can I read a text file for use with Microsoft Word mail merge?

265 pts.
Tags:
Microsoft Word Mail Merge
Office 2003
VBA
Word 2003
Hi I have a text file that the first row is the filed name that separated with comma and from second row there are data fields that separated by comma too. I want to read this file record by record and make a report by it's data in microsoft word!! I have read just the first row of data by using of For Each aField In ActiveDocument.MailMerge.DataSource.FieldNames MsgBox aField.Name msgbox ActiveDocument.MailMerge.DataSource.datafields.item(afield).value Next aFieldIs now I want to read all records of text file it possible?How? Could you please help me? My OS is win xp sp2 and I use of Microsoft Office 2003.and I use of Microsoft Visual Basic Editor from Ms Word. Thank you. ---- Regards Mahnaz

Answer Wiki

Thanks. We'll let you know when a new response is added.

Do you want to use the records in Visual Basic? or
to use in (mail merge) MS-word itself ?

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following