Parsing a field from Access into Word

[Telsa]

I'm trying to create a word doc where fields from Access populate the document. One of the fields has multiple entries delimited by commas. Need code for word that as it populates the doc, the countries are parsed and looped through to populate the field in the document. Any clues?

Thanks!

Mary )

 

[kathryn]

Sorry, but I am not sure that I understand. Could you post a few sample rows from your table and exactly what you want to happen in Word?

If I read you right, you are saying that you have a field in Access that has multimple items in it, separated by commas. If so, that is going to cause continual problems, in my experience, and you may want to fix the design of Access, which might then make your Word problem much easier.

Anyway, post what you have, and we'll see what we can do.

 

[BobCrawf]

Sounds like you need to take a look at mailmerge in Word.

Use the table in Access as your source and enter the field names as merge fields where needed in the document.

 

[Guest_imported]

I'm not an experience user but am working on the same project. My IT guy took a ParseName module from this same page. Go to the Access FAQ's, section "How To", section "l.". This will parse the names from the Access sides. You will need to create new fields in your table for Word to reference.

(The MS Access section can be found in the blue column on the right-hand side of the entry area to this site"

Good luck! You'll need it!
Zach the Access Maniac