OK... I'm back after a hellish week @ work. It's Friday night, so no gorey details of sitting in meeting after meeting and getting no work done.

Anyway, I think I have a better grasp of what I'm trying to do here.

The 3rd party contact management app exports the data to a CSV in the same format/layout each time, but the field (column) names do not match the fields in my existing merge templates.

I need to either execute a find and replace, or just rename certain fields

i.e.
Field: 9
fieldname: "JobTitle"
I need to rename it to "Job Title" so it matches the existing autotext entry in my merge templates. I have to change the names of approximately 20 fields. They will always be in the same order when exported.

I've figured out that I can open the csv from Word and i'm assuming that i can make changes to it programmatically before executing the merge.

[VBA]ActiveDocument.MailMerge.OpenDataSource path + fName
[/VBA]
Then what?
Any suggestions, tips are appreciated. I'm on my own for this one, and brand new to VBA.