I am working on learning how to create a mail merge from Excel, but to do so one needs a chunk of code that I need to create from different merges to study, and so far can not find where the heck the code is. As an example I extracted the salient block from another post as follows:

appWd.MailMerge.OpenDataSource Name:="C:\My Documents\mydata.csv" _ 
, ConfirmConversions:=False, _ 
ReadOnly:=False, LinkToSource:=False, AddToRecentFiles:=False, _ 
PasswordDocument:="", PasswordTemplate:="", WritePasswordDocument:="", _ 
WritePasswordTemplate:="", Revert:=False, Format:=wdOpenFormatAuto, _ 
Connection:="", SQLStatement:="", SQLStatement1:=""
I need to learn how to define different DataSources and SQLStatements, which I hope to do by choosing different datasources and creating different searches and reading how this general block gets altered, just like learning from my own recorded macros.

As an added note, I intend to use this for eMail merges, for where it makes a difference, and the MSDN version/explanation(...) of MailMerge.OpenDataSource kind of flies right over my head. No, not "kind of". More like "absolutely".

Can this be done? If so, where the heck do I look?!? and if not, how can I learn how to accomplish this?

I am old, so yes, I am open to even purchasing and reading books...

Thank-you!