I’m not at all certain that I did it before, and only reasonably certain that I did that today. I certainly tried, but as yet, no joy. Part of the problem is that I built this routine in 2005 when I was, not only younger but infinitely more alert. I have two MM routines, this one and Christmas Card addressing. SHMBO (She who must be obeyed) opted to hand-address the cards this year, so I’m not sure if that one works anymore or not. I’ll worry about that one in November.


I no longer remember how to change the source data, but I apparently did it correctly today. I don’t know how to determine what my main document is, so the change was made by accident. Be nice to know how to do it on a regular basis. As far as the separators, I continue to get the prompts. I can live with it, of course, but would prefer to do it right.


Speaking of which… I’m also getting the warning about allowing SQL code when I invoke the document. I notice that you dealt with that in another response recently, but I believe that dealt with VBA macros, and my problem is a bit different. I’d really like to get rid of that warning. Thoughts?


I’ve attached some screen shots.


Thank you.


JLOB

Attached Images

	Delimiters-1.jpg (133.5 KB, 12 views)
	Delimiters-2.jpg (133.9 KB, 12 views)
	word sql.jpg (104.3 KB, 12 views)

I would not expect the prompt for delimiters to appear once you've done the basic setup - unless you change the data source or disconnect from it and have to reconnect.
Unless you've moved the CSV file to a different folder or renamed it, or you're using a different CSV file each year, you shouldn't need to change the source. If indeed you're using a different CSV file each year, try using a generic filename for the current year (e.g. 'Mailing List.csv') in the same folder every time, then renaming/moving it to the 'year' folder it after the mailmerge is done.
Microsoft introduced that some years ago, to warn users against running documents containing possibly malicious SQL code. If you answer 'No' to the prompt, the document disconnects from the data source. There is a registry edit for suppressing the warning.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Nor would I, but there you have it. The problem I have is when to save the document such that it has the delimiters correct.
I use the same input data file name every time. It just has updated data. Years ago, clearly during a moment of creative genius, I named the file csv.csv. Seemed catchy, so I stuck with it!
I'm no stranger to Regedit. Where might I find the code?


Thanks for your continued help. On another note, I hope the fires near you aren't adversely affecting you or your family.


JLOB

Opening the csv in Excel and saving it as an Excel workbook and using that as the mailmerge data source would certainly overcome that.
See: https://support.microsoft.com/en-my/...command-messag
See also: How to stop a Microsoft Word warning concerning a SQL command when - Microsoft Community

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]