How to include article contents in email

I would like to include the contents of a specific article in the body of the automatically generated email that accompanies CB registration. How can I do that?

You can't, we've no features for such usage. You'll need to directly add the contents of the article to the email body language string or within CB > Configuration > Registration if you're talking about the Welcome or Pending emails.

I wanted to include the text of our Terms of Service page in the confirmation mail generated when a user registers. I wanted it to come from the article so that, in the event that the terms are modified by the site owners, they only have to edit that page and the text is carried through to all functions where it was needed. I did not want the site owners to have to mess around with cutting and pasting updated text into a languag string file.

Here is the solution I finally came up with:

I created a new CB field of type Query, called it TOS RETRIEVAL, which created the field name cb_tosretrieval

I set it to show on profile but made it a hidden field by typing the word "hidden" (without quotes) in the CSS Class box.

For Parameters/Query I used the following code:
SELECT `introtext` FROM `y2vfp_content` WHERE `id` = 127;

Someone else would substitute the "y2vfp" part with whatever prefix your tables have, and you would also need to use the article id from the article you intend to use. The article id for mine was 127.

In my email template I am now able to insert the article contents with the substitution [cb_tosretrieval]

You can exclude y2vfp and simply use #_ in its place to avoid the dependency. Example as follows.

Yes, I tried that first and it generated an error, indicating that the #_ part was not being replaced ( No Such Table #_content), so I hard coded it to get it functioning.

You need to use 2 underscores. See my above example.