How can I read a text file for use with Microsoft Word mail merge?
Microsoft Office 2003, Microsoft Word 2003, Microsoft Word Mail Merge, Office 2003, VBA, Visual Basic for Applications, Word 2003, 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
Software/Hardware used:
Software/Hardware used:
ASKED:
November 9, 2008 1:16 PM
UPDATED:
November 11, 2008 5:28 AM
RELATED QUESTIONS
- VBA - Mail Merge Automation via Access
- Word 2003/2007 VBScript fails in 2010 (background printing) - help!
- Lotus VB script - email generator - add button
- Setting up a field to store .png file in Access 2007 Database so that it can be merged with Word document
- Data report from iSeries to a CSV format need page breaks and colors
Answer Wiki:
Do you want to use the records in Visual Basic? or
to use in (mail merge) MS-word itself ?
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
