<div>
<div class="content wysiwyg-content">
Hi All,<br />
<br />
<br />
We are an academy and I want to create a mail merge in Word and then send this via Outlook. However, I first need to format my data into a meaningful way. I am connecting to a remote SQL server databse.<br />
<br />
&nbsp;This is where I have my problem.<br />
<br />
I want to send a message to all my parents asking them to confirm the information I have on them.<br />
<br />
The first bit is easy, I connect to’ tbl_Parents’ where I have their &lt;&lt;Name&gt;&gt;, &lt;&lt;Address&gt;&gt;, &lt;&lt;Email&gt;&gt; etc. If this was all I would simply loop through these and that would be it. However, I also now need to list their children and their date of birth etc. That means for each parental account I need to open ‘tbl_Students’ and collect an array of all the students which match the parental account unique ID.<br />
<br />
The last bit I do not seem to be able to do in Word. Is this possible.
</div>
</div>


Hi All,


We are an academy and I want to create a mail merge in Word and then send this via Outlook. However, I first need to format my data into a meaningful way. I am connecting to a remote SQL server databse.

 This is where I have my problem.

I want to send a message to all my parents asking them to confirm the information I have on them.

The first bit is easy, I connect to’ tbl_Parents’ where I have their <<Name>>, <<Address>>, <<Email>> etc. If this was all I would simply loop through these and that would be it. However, I also now need to list their children and their date of birth etc. That means for each parental account I need to open ‘tbl_Students’ and collect an array of all the students which match the parental account unique ID.

The last bit I do not seem to be able to do in Word. Is this possible.

Data for Mailomerge

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Microsoft Outlook is a personal information manager from Microsoft, available as a part of the Microsoft Office suite. Although often used mainly as an email application, it also includes a calendar, task manager, contact manager, note-taker, journal, and web browser.

Outlook

Microsoft Word is a commercial document editing program that is part of the Microsoft Office suite. It features numerous text-editing tools for creating richly formatted documents, along with tools for the use of macros in Word documents. Word's native file formats are denoted either by a .doc or .docx file extension. Plugins permitting the Windows versions of Word to read and write formats it does not natively support, such as the OpenDocument format (ODF) are available. Word can import and display images in common bitmap formats such as JPG and GIF. It can also be used to create and display simple line-art.