Question

Asked:
Asked By:
Nov 9 2008   1:16 PM GMT
Aliyani   200 pts.

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


VBA, Visual Basic for Applications, Microsoft Office 2003, Word 2003, Office 2003, Microsoft Word 2003, Microsoft Word Mail Merge, Word 2003 Mail Merge

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

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window

Answer Wiki (Improve, edit or add to this answer)


 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0



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

Browse more Questions and Answers on Development and Microsoft Windows.

Looking for relevant Development Whitepapers? Visit the SearchWinDevelopment.com Research Library.


Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register