Mail Merge to Email

Hi,

I started to write code for a mail merge, but it only seems to be working in the "Directory" format whereas I will need the final result in the "Email" format. In the example attachments, I will need to send out 3 emails (one per manufacturer) with the corresponding product list changing in each. For the first manufacturer, the email should look as follows (the red text is what needs to change every time the manufacturer name changes):

"Dear Joanne,

We will need a list of these products sent in by November 23rd, 2017.

List of Products (Code --- Manufacturer --- Brand Name):

123 --- ABC Food --- Gold
345 --- ABC Food --- Orange

Thank you in advance for your assistance on this initiative.

Jane Doe
(888) 876-6543"

The code currently written in the word document seems to ignore the email signature portion ("Thank you in advance...") and it puts each product in it's own email rather than grouping them together in one email per manufacturer. It also ignores the formatting (mainly the spaces between paragraphs).

Would anyone be able to help me edit this code in order to send out the 3 emails at once?

Thank you in advance for your help!

Nicole