Not delivering all mails and losing formatting using mail merge

Hi mso3,

See the attached .zip file that contains the following files:
a. LJMOpenWordMailMerge6ForMso3.xls - Excel file that runs Mail Merge
b. Birthday.docx - modified copy of your Word file.
c. SendMails.xls - modified copy of your Excel file.

To run Mail Merge the first time:
a. Extract the 3 files from the .zip file into the same folder.
b. Open file LJMOpenWordMailMerge6ForMso3.xls
c. Left Click the Brown Shape at the Top Right to put the proper files and folders on lines 25 and 27.
d. Left Click the Yellow Shape at the Top Left to run the Mail Merge.


Notes and changes required in your documents:

In word document:
I’m not getting a name of person having a birthday after a word ‘Dear ,’
a. Type in the name of the field (e.g. NAME_OF_PERSON). BLANKS are NOT allowed in field name.
b. Highlight the field name and then press CTRL F9 to create a Merge Field.
When opening a document, Merge Fields may not be visible. To make Merge Fields visible, highlight the entire document and press SHIFT F9.
Merge Fields are displayed in curly brackets preceeded by ref (e.g. {ref NAME_OF_PERSON} ).

I want a current date (today) under the picture cake leaving one blank line above and under a current date in green color.
a. Put in blank lines as required.
b. Put the cursor where you want the date.
c. Insert > Date and Time > Select Format. Check 'Update Automatically' > OK

In Excel File:
a. It is suggested that the first sheet in the file be used for Mail Merge purposes.
b. Header row is line 1. This row contains field names with NO SPACES in a field name.
c. Rows 2 thru n contain data.

Lewis

Hi mso3,

Thank you for posting the sample code. I was able to come up with a simpler solution, that will probably be easier for you to understand.

See the attached .zip file that contains the following files (all files have been modified since the previous update):
a. LJMOpenWordMailMerge7.xls - Excel file that runs Mail Merge
b. Birthday.docx - modified copy of your Word file.
c. SendMails.xls - modified copy of your Excel file.

To run Mail Merge the first time:
a. Extract the 3 files from the .zip file into the same folder.
b. Open file LJMOpenWordMailMerge7.xls
c. Left Click the Brown Shape at the Top Right to put the proper files and folders on lines 25 and 27.
d. Left Click the Yellow Shape at the Top Left to run the Mail Merge.

Please note that I added a few things to the Excel file that runs the Mail Merge:
a. User entry of a folder name where the Output Files will go.
b. User entry of a Mail Merge 'Field Name'. This is the Column in the Excel Data File that is used to create the 'Output File Name'.
c. User entry of 'First' and 'Last' Birthday to include. If 'Today' is wanted, the 'Birthday' cells can be left blank.
d. A command button that will display the 'Output File Folder' in using 'Windows Explorer'.

The following code excerpt is taken (out of context) from the attached file, and demonstrates how the Mail Merge Code works. Several statements not related directly to function have been removed for ease of readability.

Please Login or Register  to view this content.

Lewis

Your problems seems to be in the Word file. You are looking for a Date Merge Field {MERGEFIELD DATE}. This is probably incorrect, and causes an error because the Excel data file DOES NOT have a field Named 'DATE'. You say you want the current date in a specific format which should probably be: {DATE \@ "d MMMM yyyy"}. Notice that the current date DOES NOT contain the KEYWORD MERGEFIELD.

See the attached file, which implements the changes.

Lewis

Happy to inform you that I have solved the file name problem successfully.

I'm glad it worked out. I've been busy, but when I have time, I will look into the problem.

If I want to create the output data letters for all of my contacts then which amendment is require. I have to send greeting cards on the festival to all of my friends on festival. So in this case the ‘Today’ sheet is not require. I have to send the greeting cards to all contacts on the ‘Access’ sheet.

On the Excel File that runs the MailMerge on 'Sheet1', change the value on line 32 (First Birthday to Include:) to January 1, 2015 and change the value on line 33 B](Last Birthday to Include:[/B]) to December 31, 2015. That will put all entries on the 'Access' Sheet on the 'Today' sheet and do what you want.