www.gmayor.com Open in urlscan Pro
2001:8d8:100f:f000::21f  Public Scan

URL: http://www.gmayor.com/ManyToOne.htm
Submission: On November 17 via manual from CA — Scanned from CA

Form analysis 3 forms found in the DOM

POST https://www.paypal.com/cgi-bin/webscr

<form action="https://www.paypal.com/cgi-bin/webscr" method="post" style="width: 143px">
  <input type="hidden" name="cmd" value="_s-xclick">
  <input type="hidden" name="hosted_button_id" value="C22QAMXJVVZQ4">
  <input type="image" src="images/DonateGBP.gif" name="I1" alt="PayPal - The safer, easier way to pay online!" style="height: 62px; width: 124px;">
  <img alt="" src="_inc/pixel.gif" width="1" height="1">
</form>

POST https://www.paypal.com/cgi-bin/webscr

<form action="https://www.paypal.com/cgi-bin/webscr" method="post" style="width: 143px">
  <input type="hidden" name="cmd" value="_s-xclick">
  <input type="hidden" name="hosted_button_id" value="HUS7FWLVVNTH4">
  <input type="image" src="images/DonateUSD.gif" name="I2" alt="PayPal - The safer, easier way to pay online!" style="height: 62px; width: 123px;">
  <img alt="" src="_inc/pixel.gif">
</form>

POST https://www.paypal.com/cgi-bin/webscr

<form action="https://www.paypal.com/cgi-bin/webscr" method="post" style="width: 143px">
  <input type="hidden" name="cmd" value="_s-xclick">
  <input type="hidden" name="hosted_button_id" value="72JWWJEZX6KXS">
  <input type="image" src="images/DonateEuro.gif" name="submit" alt="PayPal - The safer, easier way to pay online!" style="height: 62px; width: 124px;">
  <img alt="" src="_inc/pixel.gif" width="1" height="1">
</form>

Text Content

GRAHAM MAYOR


... HELPING TO EASE THE LIVES OF MICROSOFT WORD USERS.

 * Home
 * What's New
 * Word Pages
 * Links
 * Downloads
 * Photo Gallery
 * Search
 * Contact

YOU APPEAR TO BE USING AD BLOCKING SOFTWARE. WHILE I RESPECT YOUR RIGHT TO DO
SO, PLEASE BE AWARE THAT THE MINIMAL ADVERTISING ON THIS SITE HELPS DEFRAY THE
COST OF PROVIDING THIS FACILITY, AND I WOULD THEREFORE ASK THAT YOU TURN OFF THE
BLOCKER WHILE BROWSING THIS SITE.

Return to Top

MANY PEOPLE ACCESS THE MATERIAL FROM THIS WEB SITE DAILY. MOST JUST TAKE WHAT
THEY WANT AND RUN. THAT'S OK, PROVIDED THEY ARE NOT SELLING ON THE MATERIAL AS
THEIR OWN; HOWEVER IF YOUR PRODUCTIVITY GAINS FROM THE MATERIAL YOU HAVE USED, A
DONATION FROM THE MONEY YOU HAVE SAVED WOULD HELP TO ENSURE THE CONTINUED
AVAILABILITY OF THIS RESOURCE. CLICK THE APPROPRIATE BUTTON ABOVE TO ACCESS
PAYPAL.




MAIL MERGE 'MANY-TO-ONE', 'ONE TO ONE' (BOTH INCLUDING MERGE TO E-MAIL WITH
ATTACHMENTS).

WORD'S FORM LETTER MAIL MERGE IS STRICTLY ONE TO ONE. THIS MEANS THAT ONE
DOCUMENT IS PRODUCED FOR EACH RECORD. THIS ADD-IN ALLOWS THAT KIND OF MERGE TO
THE PRINTER, BUT ALSO INCLUDES VARIOUS OPTIONS THAT ARE NOT AVAILABLE FROM THE
WORD FUNCTION, ESPECIALLY A MERGE TO SEPARATE DOCUMENTS AND TO E-MAIL
ATTACHMENTS.

THIS ADD-IN ALSO OFFERS MANY TO ONE MERGE CAPABILITIES I.E. DATA FROM SEVERAL
RECORDS MAY BE INCLUDED AND PRESENTED IN THE SAME DOCUMENT.

ILLUSTRATIONS ON THIS PAGE MAY BE FROM EARLIER VERSIONS THAN THE VERSION
CURRENTLY AVAILABLE FOR DOWNLOAD AS SHOWN IN THE TITLE BARS OF THE USERFORMS.

IMPORTANT NOTE: THE DOWNLOAD LINK FOR THE ADD-IN IS AT THE FOOT OF THIS PAGE,
AND IS NOT ASSOCIATED WITH THE ADVERTISEMENTS, WHICH ARE CONTEXT AND LOCATION
SENSITIVE.

THE FACILITIES OFFERED BY THIS ADD-IN ARE COMPLEX, SO PLEASE READ THE CONTENT OF
THIS PAGE BEFORE DOWNLOADING AND ATTEMPTING TO USE THE ADD-IN.


THE FEATURED ADD-IN THUS PROVIDES THE FOLLOWING FUNCTIONS:

 1. Many to One Merge to e-mail or separate Word documents or PDF format
    documents or to the printer.
 2. Many to One Mail Merge with attachments to e-mail.
 3. One to One Mail Merge to e-mail or separate Word documents or PDF format
    documents or to the printer.
 4. One to One Mail Merge to e-mail with attachments.
 5. Mail Merge graphics (with provisos shown below.)
 6. Mail Merge bar codes (with provisos shown below)

Where the open source PDF creation tool PDF Creator is installed, additional
options to use PDF Creator are available for both Many to One and One to One
merges. PDF Creator additionally offers the option to add security measures to
the merged PDF files, which are not available to Word's built-in PDF Creation
function. The PDF Creator functionality is described in the last section at the
end of this page, followed by the download button.

THE ADD-IN REQUIRES THAT THE DATA SOURCE IS AN EXCEL WORKSHEET, WITH A HEADER
ROW STARTING AT CELL A1 AND THAT OUTLOOK IS AVAILABLE AND CONFIGURED AS THE
DEFAULT E-MAIL APPLICATION IN WINDOWS TO SEND THE MESSAGES.

AS A SEPARATE PROJECT, I HAVE ALSO PRODUCED A TOOL TO MAKE IT RELATIVELY EASY TO
EXTRACT OUTLOOK CONTACTS DATA TO AN EXCEL WORKSHEET SHOULD IT BE REQUIRED TO USE
OUTLOOK DATA WITH THIS ADD-IN.

NOTE THAT THE PROCESSES OF THIS ADD-IN DO NOT CONSTITUTE A TRUE MAIL MERGE.
WORD'S MAIL MERGE FUNCTION IS ONLY USED AS A CONVENIENT WAY OF PLACING THE
VARIABLE DATA FOR THE FINISHED DOCUMENTS.

THE FUNCTION PROCESSES THE COMPLETE RECORD SET SERIALLY. IF YOU REQUIRE A
FILTERED RECORD SET, THEN FOR PREFERENCE YOU SHOULD FILTER IN EXCEL AND PROCESS
THE FILTERED WORKSHEET AS THE DATA SOURCE. HOWEVER I HAVE ADDED A SIMPLE
OPTIONAL FILTER, SWITCHABLE FROM THE 'CONFIGURE OPTIONS' BUTTON ON THE ADD-INS
RIBBON TAB, WHICH PROVIDES FILTER TOOLS, TO LIMIT THE RECORD SET TO BE MERGED
BASED ON THE CONTENT OF UP TO FOUR FIELDS. CONTEXT SENSITIVE HELP IS PROVIDED.

DO NOT USE THE ADDRESS BLOCK FIELD IN YOUR DOCUMENT AND DO NOT INCLUDE BLANK
COLUMNS OR ROWS IN THE WORKSHEET USED AS A DATA SOURCE.

ERROR TRAPPING IN THE ADD-IN WILL DETECT WHEN THE WORKSHEET IS INCOMPATIBLE AND
WILL ATTEMPT TO POINT OUT WHERE THE PROBLEMS LIE.

OUTLOOK ACCOUNTS - IMAP

IF OUTLOOK IS NOT CONFIGURED TO HAVE A LOCAL PST FILE, OTHER THAN THE IMAP
CACHES, IT STORES ALL THE DRAFT MESSAGES WITHIN THE DRAFTS FOLDER OF THE IMAP
ACCOUNT. MOST PROVIDERS DON'T ALLOW YOU TO HAVE SUBFOLDERS OF THESE SPECIAL
FOLDERS WITHIN IMAP ACCOUNTS. SO THE PROCESS WILL NOT BE ABLE TO CREATE THE
REQUIRED SUBFOLDER, BUT INSTEAD CREATES ALL THE MAILS TO BE SENT DIRECTLY WITHIN
THE DRAFTS FOLDER.

IF THERE IS A LOCAL PST FILE, BUT NOT SET AS DEFAULT DATA FILE (INSTEAD SETTING
AN IMAP FILE AS DEFAULT), THE PROCESS WILL CREATE THE SUBFOLDER WITHIN THIS
LOCAL FILE, BUT STORES THE MAILS TO SEND WITHIN THE DRAFTS OF THE DEFAULT IMAP
DATA FILE.

POP ACCOUNTS SHOULD NOT BE AFFECTED BY THIS ISSUE.

The add-in is provided in the format of a macro enabled template which should be
installed in the Word Startup folder (with Word closed) so that it loads with
Word and makes its commands available to the Mailings Tab of the Word ribbon.

The add-in is also provided as a self executing zip file, which will install the
add-in and remove older versions.

THE ADD-IN HAS ITS OWN RIBBON TAB WITH THE FOLLOWING COMMAND SET:


 * Start Merge Process - runs the Process
   
   
 * Insert List Field - The add-in allows the use of a separate list of a single
   child field to be included. The intention is to facilitate the insertion of
   sets of signatures in contract (etc.) documents, though it can be used to
   list the contents of any single child field.
   
   This option works in conjunction with a rich text content control positioned
   as required in the document. The button will insert the appropriate rich text
   content control, titled 'List Field', with the required syntax to display the
   content of that variable at the cursor position. The use of the List field is
   describe later on this page.
   
   
 * Send Messages - Sends the e-mail messages created by the application to the
   intended recipients. This option provides an opportunity to delay the send
   time of the messages.

BE AWARE THAT CLICKING THE 'SEND MESSAGES' BUTTON WILL SEND ALL THE MESSAGES IN
THE APPLICATION'S TEMPORARY FOLDER TO THE OUTBOX- INCLUDING ANY TEST MESSAGES
YOU MAY HAVE LEFT THERE!!! IF OUTLOOK IS CONFIGURED TO SEND MESSAGES
IMMEDIATELY, THEN ALL THOSE MESSAGES WILL BE SENT.

NO MESSAGES ARE SENT FROM THE APPLICATION OTHER THAN BY CLICKING THIS OPTION.

 * Force Send - All messages - This is aimed at messages which appear to be
   stuck in the Outbox. Instead of having to open and send each such message
   again, the function aims to automate that task. It does not affect messages
   in the temporary folder created by the add-in. For that you should use 'Send
   Messages', the first item in the menu.
    
   
 * Configure Options - This button recalls a process to allow the setting of
   some defaults The configuration is called automatically after installation,
   following an update to he add-in, or whenever the user changes.
   
   
 * Toggle SQL Security check - When a merge document with a data file attached
   is opened, by default Word displays a security message. This button toggles a
   registry value that controls the display of the security warning - see the
   yellow panel below for more information.
   
   
 * Reset Defaults - The application stores various settings in the registry.
   This button removes the registry values created by the application.
   
   

MICROSOFT'S WINDOWS SECURITY PRODUCES THE FOLLOWING WARNING MESSAGE WHEN THE
MERGE DOCUMENT IS OPENED AND ITS DATA ATTACHED.

THE SECURITY MEASURE THAT PRODUCES THIS WARNING CAN BE DISABLED BY A SIMPLE
REGISTRY CHANGE (SEE TOGGLE SQL SECURITY CHECK ABOVE), BUT I REALISE THAT
COMPANY IT DEPARTMENTS MAY BE RELUCTANT TO PERMIT SUCH A CHANGE, SO YOU MAY SEE
THIS MESSAGE MORE THAN ONCE WHEN USING THE ADD-IN.

THIS WARNING, APART FROM BEING ANNOYING, SHOULD NOT AFFECT THE WORKING OF THE
ADD-IN, THOUGH SOME USERS HAVE REPORTED PROBLEMS ATTRIBUTABLE TO IT.

 



 


CONFIGURE OPTIONS

When the add-in is installed and run for the first time, the process starts by
displaying a userform to set some preferences. You can redisplay the dialog as
required from the ribbon button.



Earlier versions would check whether Outlook was installed, however as the
latest versions of Office have Outlook installed, I have included a manual
confirmation. For the e-mail options to work, Outlook must be the default e-mail
application and the check box must be checked.

Show Filter Dialog at Start is self evident. With the check box unchecked. The
filter is not shown and all the records in the set are processed.

E-mail validation may be disabled. It is strongly advised that you don't check
this option unless you use an Exchange Server with recipient nicknames that are
not recognised by the add-in as e-mail addresses. This option is only enabled if
the Outlook check box is checked.

The add-in has included an option to enable the use of a macro to be run before
saving the individual documents for some time, though in some versions it had
not been enabled for most users. This version has that option enabled if checked
in the configuration. Support for creating macros is not provided.

Where macros are enabled in the configuration, an additional tabbed page is
available on the main program dialog with options to include a macro and to 'Fix
Hyperlinks' This latter option should not be required by most users, but if
hyperlinks are not resolved correctly, it can be checked to address that issue.

THE HYPERLINKS OPTION, CAN AFFECT THE LAYOUT OF SOME COMPLEX DOCUMENTS SO SHOULD
BE USED ONLY WHEN NECESSARY.



It has been found that where the '#' symbol is used in the data, it can cause
the process to misread the following data. The add-in therefore detects the use
of the '#' symbol and stops the process. This hash check may be disabled, but
should you do so, check the results thoroughly, especially if you are sending
the merges to e-mail, where incorrect data may be sent out and cause
embarrassment.

The add-in allows the use of PDF Creator version 2.5 to be used to create more
secure PDF files, when that application is installed. Do not check the box if
PDF Creator 2.5 is not installed.

PDF CREATOR IS NOT REQUIRED IN ORDER TO USE THIS ADD-IN, AND THE VERSION 2.5 FOR
WHICH CODE SEQUENCES ARE INCLUDED IS NOT THE MOST RECENT VERSION OF THE ADD-IN.
THE CURRENT VERSION IF NOT COMPATIBLE WITH THIS ADD-IN, AND IF INSTALLED THE
CHECK BOX MUST NOT BE SELECTED.

Mute sounds. The add-in uses sounds as alerts throughout for messaging etc. Some
users prefer to work without such sounds so the option is included to mute them

he temporary folder is set by default as a sub folder of the user's TEMP folder.
For this reason when the process detects a new user, the dialog is shown and the
new user's TEMP folder is displayed.. You can change the folder to a location of
your choice, but there is no need to do so.

Previous versions prompted each time for the location to save the document. The
dialog now requires the user to set a folder to save the documents to. The
folder selected will become the default for future merges using the add-in. You
can change it by re-running the configuration from the ribbon button.

Each of the options in the configuration dialog is accompanied by context
sensitive help displayed by clicking the '?' buttons alongside the check boxes.
Similar help buttons are available throughout the process.


MANY TO ONE

The mail merge function in Microsoft Word works only with a flat data file as a
'One-to-One' merge i.e. a separate set of values for each record in a single
document.  There have been various approaches proposed to enable the merging of
lists associated with records that share a common 'key' field - for example a
list of purchased items from a particular customer where multiple separate
product items are associated with each customer. Microsoft's own suggested
approach is quite complicated and recorded at 'How to use mail merge to create a
list sorted by category'.

Fellow Word MVP Paul Edstein has posted a tutorial on this, with working field
codes and a sample Excel data source which you can download from this web site
but it can be a tad bewildering and even Paul would concede that creating this
type of merge can be intimidating for those unskilled in mail merge.

To overcome this difficulty another Antipodean MVP and occasional contributor to
this site, Doug Robbins, produced an add-in to attempt to simplify the process.
I developed the principles Doug had come up with to form the basis of my
original Many to One add-in, which is now replaced by the completely re-designed
add-in described on this page.

If there are likely to be some rows with no data, in some of the Excel data
source fields, all of the cells that represent the data source must be formatted
as text. Otherwise, errors can occur, when the routine encounters a type of data
that it is not expecting.

For Many to One to function correctly, the data must be sorted by the field that
is going to be used as the key field. Not sorting it that way will not cause an
error, but the desired result will not be achieved.

The merge starts a new document each time the key field changes, which feature
is used to different effect in the One to One options, but more of that later.

When merging to e-mail, ensure that the e-mail addresses are in a valid format
and that all the records have a valid e-mail address. The add-in will detect
invalid e-mail addresses. Where records do not have a valid e-mail address you
must correct the address, replace it with a valid address (such as your own
e-mail address) or use a dummy address as in the example data supplied with the
add-in.

WHEN MERGING TO E-MAIL, THE APPLICATION SHOULD START OUTLOOK, IF IT IS NOT
ALREADY RUNNING, BUT SUCH IS THE RELATIONSHIP BETWEEN THE OFFICE PRODUCTS THAT
THIS MAY NOT HAPPEN. IT IS THEREFORE ADVISABLE TO START OUTLOOK BEFORE RUNNING
THE APPLICATION.

The appropriate add-in should be should be extracted to the Word start-up
folder. By default the start-up folder location is a hidden location, but it can
easily be located by typing %appdata%\Microsoft\Word\Startup in the address bar
of Windows Explorer or your Internet Explorer browser.

For the purpose of explanation of the use of the add-in, a sample document and
an Excel data source are included in the zip file. An extract of the relevant
part of the merge document is included below.

The merge document must be set up as a conventional letter merge with the Excel
data file attached as its data source. The example document is supplied as an
ordinary Word document.

THE MESSAGES CREATED BY THE APPLICATION WILL GO TO A SUB FOLDER OF THE OUTLOOK
ACCOUNT DRAFTS FOLDER CALLED 'MERGE MANY TO ONE'. MESSAGES ARE ONLY SENT WHEN
YOU CHOOSE TO SEND THEM. IF YOU HAVE THE OPTION SET TO SEND MESSAGES IMMEDIATELY
WHEN CONNECTED, THEN THAT IS EXACTLY WHAT WILL HAPPEN, SO DO NOT DO THAT UNLESS
YOU REALLY DO WANT TO SEND THE MESSAGES TO THE RECIPIENTS INDICATED IN THE DATA
FILE.

The example data supplied with add-in contains dummy e-mail addresses and so it
will not matter too much if you send the messages. They will only be bounced
back with a delivery failure error.

With the example document, the 'Key field' is OWNER and the 'Child fields' are
PROP_ID, LEGAL_DESC. for the totaled fields ACRES and VALUE. and for the List
field NAME.

The fields are inserted in the document as shown in the next illustration. They
do not have to be placed in a table, but a table format is ideal for lists.

The intended result is shown in the lower illustration of the two illustrations
that immediately follow. Note that only one set of each of the “repeating”
fields (PROP_ID, LEGAL_DESC, ACRES and VALUE) is required in each location where
that data may be reproduced as shown in the table of the first illustration.
Fields not designated as child fields will be reproduced from the first record
that matches the key field. In the example document, those are the fields of the
address.

FORMATTING SWITCHES

THIS IS NOT A MAIL MERGE APPLICATION. THE WHOLE THING IS CREATED IN VBA. THE
MERGE FIELDS ARE USED PURELY AS PLACE MARKERS THAT REFLECT THE FIELD NAMES IN
THE DATA SOURCE. FOR THIS REASON IT IS NOT POSSIBLE TO USE FORMATTING SWITCHES
WITH THE 'CHILD FIELDS' IN A MANY TO ONE MERGE.

You may use switches with fields that are not 'Child fields', and include such
fields in conditional constructions, but when doing so bear in mind that the
merge fields are converted to docvariable fields during the process and as
docvariables cannot contain a null value, any field in the data source that has
a null value is replaced in the docvariable field with a zero length space
ChrW(8203)

TOTALING THE VALUES IN THE COLUMNS.

With lists of items, it is often desirable to provide a total of the values of
one of more of the listed fields. This can be done quite simply, subject to two
provisos.

1. That the values returned from the data source are numbers. It may be stating
the obvious but you cannot total values that are not numeric.

IF YOU WANT NUMBERS WITH CURRENCY SYMBOLS IN THE LISTS, THEN THE CURRENCY
SYMBOLS MUST BE PROVIDED BY EXCEL FIELDS FORMATTED AS TEXT IN EXCEL C/W WITH
THOSE CURRENCY SYMBOLS.

WHERE THE USER DOES NOT HAVE THE OPTION OF EDITING THE DATA DIRECTLY, IT MAY BE
POSSIBLE TO MAKE A COPY OF THE DATA AND EDIT THAT FOR USE AS A MERGE DATA
SOURCE.

As an aid to formatting numbers and dates formatted and displayed in Excel as
text, you could use the following Excel macro. Select the column(s) to be
converted and run the macro:

Sub ConvertFormattedNumbersToText()
Dim oRng As Range, sText As String
For Each oRng In Selection
If Not oRng.HasFormula Then
sText = oRng.Text
oRng.NumberFormat = "@"
oRng.Value = sText
End If
Next oRng
lbl_Exit:
Exit Sub
End Sub

2. The list of values is in a table column. In the example shown below the Child
Field 'Value' is inserted in a table cell. The function will build sufficient
rows for the child fields, as shown in the third of the following illustrations.

When both conditions are met, you can add an Expression (=) field to a final row
of the table. This field can be formatted using switches as required. The fields
to be added - here 'VALUE' may not be formatted with switches. If you do so the
range of values in the column will simply be added together.

IMPORTANT!!! DO NOT USE NESTED TABLES (I.E. TABLES INSERTED WITHIN OTHER TABLES)
WHEN CREATING YOUR MERGE DOCUMENT AND DO NOT USE MERGED CELLS IN THE TABLE USED
FOR THE CHILD FIELDS OR THE FUNCTION WILL NOT BE ABLE TO CREATE THE EXTRA TABLE
ROWS REQUIRED TO DISPLAY THE CHILD DATA.

ONLY CHILD FIELDS MAY BE USED IN ANY TABLE USED IN A 'MANY TO ONE' TYPE MERGE
DOCUMENT (IT DOESN'T MATTER FOR 'ONE TO ONE' TYPE MERGES) .

DO NOT PUT COMMON (NON-CHILD FIELDS) IN ANY OTHER TABLE IN THE DOCUMENT. THIS IS
ERROR TRAPPED IN THE ADD-IN, BUT I SEEM TO BE CONSTANTLY PLAYING CATCHUP WITH
ERROR TRAPPING OF ISSUES THAT USERS PRESENT. IF IN DOUBT ONLY USE ONE TABLE IN
YOUR MERGE DOCUMENT.



 

RUNNING THE MERGE

Having setup the merge document and data source, the next step is to run the
macro. The function begins by making a range of checks to ensure the viability
of the merge document and the worksheet attached as its data source. A range of
messages informs of any anomalies that may be found. Should all the tests be
passed, the first time the add-in is run, it displays the disclaimer text
similar to that used in all my add-ins. Please take a moment to read it.



When the disclaimer is dismissed, if the Filter option in the configuration has
been set, a Filter dialog will be displayed. This is a simple filter that allows
users to merge only selected field values. You may only choose one value from
each of four fields.

The dialog is populated with the fields from the data set, and text entered in
the text boxes is not case sensitive. If a field is selected, and text entered
associated with that field, the check box alongside is automatically checked.
Only checked filters will be applied to the data set.

If a field is entered then subsequently unchecked, the entry is removed and the
list moves up to fill the empty space.

The filter uses a 'Like' comparison so you may use wildcards in the values to be
searched. E.g to merge only records beginning with (say) "A & " (there are two
such records in the example files) enter A &* in the search field.



With large data sets, the filtering (which works by creating a temporary copy of
the worksheet and document and removing records from the temporary worksheet,
thus the original worksheet remains unchanged) can take a while to complete. I
have therefore added a progress indicator to the filter.

Cancelling at any stage of the process restores the original document and data.



The main multi-page userform is then displayed. From this page you can select
from a variety of merge options.

YOUR CHOICE OF MERGE MANY TO ONE OR MERGE ONE TO ONE IS RETAINED BETWEEN MERGES,
AS MOST USERS WILL TEND TO REPEAT THE SAME TYPE OF MERGE. THE CHANGE IS STORED
WHEN YOU CLICK THE 'CONTINUE ' BUTTON.

 



IF THE MERGE DOCUMENT CONTAINS LEGACY FORM FIELDS THE PROCESS WILL BE CANCELLED.


 

 


MERGE TO INDIVIDUAL FILES

A ONE TO ONE MERGE TO INDIVIDUAL FILES PROVIDES AN ALTERNATIVE APPROACH TO
SPLITTING MERGES INTO SEPARATE FILES FROM THE INDIVIDUAL MERGE LETTERS ADD-IN.
IT PROVIDES A SIMILAR RANGE OF FUNCTIONS, EXCEPT THAT IT DOES NOT OFFER THE
OPTION TO MERGE USING ADOBE ACROBAT WHERE PRESENT, AND UNLIKE THE OTHER ADD-IN
IT DOES NOT USE MAIL MERGE TO PROCESS THE DOCUMENTS. THIS CAN PRODUCE BETTER
RESULTS THAN THE INDIVIDUAL MERGE LETTERS ADD-IN - ESPECIALLY WITH DOCUMENTS
THAT CONTAIN COMPLEX TABLES AND/OR SEVERAL SECTIONS.

The dialog for the One to One merge option is relatively simple. it merely
requires the selection of a field for use in naming the document. Apart from the
title bar captions the dialogs are identical whether merging to Word documents
or PDF.



The dialog includes a button marked 'Select additional filename options'. This
provides the opportunity to add a second field value to the filename and/or
accompanying text. That text can be placed before or after the two fields, with
a choice of separator character between each element. The field order can be
transposed if required. This may be important in the case where the filename
field is also the key field.

The dialog indicates the format of the filename (see below). Not indicated is
the filename extension, which will be PDF or DOCX according to the initial
selection of the merge type.



IMPORTANT!
AS THIS ADD-IN ALSO PROVIDES FUNCTIONALITY FOR MANY TO ONE MAIL MERGES, IT IS
IMPERATIVE THAT THE INITIAL FILENAME FIELD CHOSEN HAS UNIQUE DATA IN CONSECUTIVE
RECORDS. THE FUNCTION WILL PRODUCE A NEW DOCUMENT ONLY WHEN THE VALUE IN THE
FILENAME FIELD IN A ONE TO ONE MERGE CHANGES. IF THE VALUE IN THE FILENAME FIELD
OF THE FOLLOWING RECORD IS IDENTICAL, THEN THE FOLLOWING RECORD WILL BE SKIPPED.

There are no additional options for a merge to individual documents and so click
'Continue' to run the process of creating the separate document.

You will have to select a location to store the documents in the next dialog, or
they will be created in the current document folder.



Click OK and the merge creates the documents in the chosen folder. As nothing
much appears to be happening I have added a progress indicator.



Merging with the Many to One option to individual documents provides a few more
options and introduces the concept of a 'Key' field and associated 'Child'
fields. The 'Key' field is a field that contains data related to all the records
in the set. The 'Child' fields are those fields from the set that are to be
listed.

The list can be in a table, which will be ideal if you wish to calculate totals
for values, or it can be a plain list, one to a line, or a continuous list.

Where the list is not in a table, you can choose the separator character and
whether to use 'and' or 'or' as the separator for the last item in the list.
e.g.


 * Value1
 * Value2
 * Value3
   and/or
 * Value 4

Or

 * Value1, Value2, Value3, and/or Value4



 


INDEPENDENT LIST FIELD

The Many to One merge provides for a single child field to be used to create a
separately formatted list, regardless of whether the child field has already
been used in a table or list elsewhere in the document. Access to this option is
found on the List Field tab.

Such a field may have a variety of uses, but it was envisaged that it would be
used for providing signature blocks for legal documents where several parties
would sign the document.

In order to employ this field in the document, it will be necessary to insert a
rich text content control, with the title 'List Field' at the position(s) where
the list is to be displayed. Clearly this content control must be present before
the merge process if run.

THE FIELD SELECTED AS LIST FIELD IS A CHILD FIELD SO MUST HAVE BEEN SELECTED AS
A CHILD FIELD ON THE MAIN PAGE OF THE USERFORM. ONLY CHILD FIELDS ARE AVAILABLE
FOR SELECTION ON THE LIST FIELD PAGE. IF THE FIELD YOU WANT TO USE IS NOT
AVAILABLE FOR SELECTION, RETURN TO THE MERGE TABBED PAGE AND SELECT IT AS A
CHILD FIELD.

You can use any text in the Leading and Trailing text boxes to give the spacing
you require. Note that if you type [TAB] in either text box, this will be
substituted by a tab character when the merge is run. The Independent List
Layout does not indicate the actual spacing provided by the tab setting applied
to the paragraph containing the DocVariable field so you may need to establish
what leading and trailing text is required to give the effect you seek, before
running the merge. See the two illustrations below which indicate how the
function is applied in practice.




MERGE TO PRINTER

A One to One merge to printer is include for completeness. In practice you would
probably use the Word mail merge function to merge to printer. The main
advantage of this function is that each document is treated as a separate print
job, which can be of value when printers include stapling functions.



MERGING TO PRINTER WITH THIS FUNCTION REQUIRES A KEY FIELD. THIS MAY BE ANY
FIELD IN THE MERGE DOCUMENT WHICH HAS A VALUE FOR EACH RECORD AND WHICH VALUE IS
DIFFERENT IN CONSECUTIVE RECORDS. IT DOES NOT MATTER IF THE SAME VALUE IS
DUPLICATED IN A SUBSEQUENT RECORD, BUT THE FUNCTION ONLY CREATES A NEW DOCUMENT
WHEN THE VALUE IN THE KEY FIELD CHANGES.

A Many to One merge to printer provides the additional functions relating to the
use of Child fields outlined in the previous section.






MERGE GRAPHICS

As the Many to One add-in is not a mail merge application, merging graphics is
not simply a matter of inserting the correct syntax as discussed at Mail Merge
Graphics. I have therefore incorporated a process to convert a merged graphics
path that points to an existing file, inserted into the child field table. Note
that this facility is only available for Many to One merges where the child
fields are in a table as in the following example:



TO RESTRICT THE SIZE OF THE IMAGES, ENSURE THAT THE COLUMNS ARE SET TO FIXED
WIDTH. THE IMAGES WILL THEN SHRINK TO THE WIDTH OF THE COILUMN.

The data file for this would be something like the following, with the paths
available on a local disc



The add-in features an additional tab



Checking the check box populates a combo box with popular graphics file
extensions. The extension helps the process locate the file path in the table,
so it is essential that all the graphics merged are of the same format and the
extension selected matches that format.

If either of the above conditions is not true, or the file path indicated is no
longer valid, the file path only is merged.



FOR ONE TO ONE MERGES, OR FOR GRAPHICS THAT ARE NOT RELATED TO CHILD FIELDS, USE
THE SYNTAX DISCUSSED AT MAIL MERGE GRAPHICS (OR USE THE ASSOCIATED ADD-IN) TO
INSERT THE FIELDS. THE ADD-IN'S GRAPHICS OPTION IS NOT RELEVANT TO SUCH USE.


MERGE BARCODES

As the Many to One add-in is not a mail merge application, merging barcodes (as
with graphics above)  is not simply a matter of inserting the correct syntax as
discussed at Insert Bar Code. I have therefore incorporated a process to convert
a merged field, inserted into the child field table. Note that this facility is
only available for Many to One merges where the child fields are in a table as
in the following examples.



The process can convert a selected column (column 1 in the following
illustration) to barcode type 39, 128 and QR in the following three fields
respectively.




MERGE TO E-MAIL MESSAGE

The function is able to merge the document to the body of an e-mail message.
This function, more than any other, took up a lot of development time to get to
the stage it is currently at. There are several issues involved and thus this
part of the process uses an entirely different means of communicating with
message creation part of Outlook from the merge to attachment options with
covering message.

IMPORTANT NOTE

WHEN MERGING TO THE BODY OF AN E-MAIL MESSAGE (AND THAT WILL INCLUDE
PERSONALISED COVERING MESSAGES WITH ATTACHMENTS) IT IS ESSENTIAL THAT OUTLOOK IS
STARTED BEFORE WORD. OTHERWISE THE MERGED DOCUMENTS WILL NOT BE PASTED TO THE
MESSAGE BODIES. THIS IS A PECULIARITY OF THE LINK BETWEEN WORD AND OUTLOOK THAT
I HAVE BEEN UNABLE TO RESOLVE. THE PROCESS WILL THEREFORE STOP, WITH A WARNING
MESSAGE IF YOU ATTEMPT TO MERGE TO THE BODY OF AN E-MAIL MESSAGE AND OUTLOOK IS
NOT ALREADY RUNNING.

IF YOU START WORD BEFORE OUTLOOK AND THEN RUN THE MERGE, THERE REMAINS A
POSSIBILITY THAT THE MESSAGES WILL AGAIN NOT CONTAIN THE MESSAGE BODIES AND WILL
RESULT IN AN ERROR CONDITION. THIS ERROR IS TRAPPED. THE PROCESS WILL STOP AND
THE USER WILL SEE A WARNING TO CLOSE WORD AND OUTLOOK AND START AGAIN.

When Word is used as e-mail editor, as is the case when the documents are merged
to the body of an e-mail message, and small attachment called 'header.htm' is
attached to the message. This is a harmless addition which has been present
since at least Word 2000, and there is no simple way around it.

Up to version 8.8 of the add-in, I allowed the add-in to produce these
attachments, as this produced a cleaner running add-in, but it had not occurred
to me that the attachments were also added when the merge was to attachments,
with a customized message body. I have therefore modified the process to create
the message bodies in a different way, but this has the disadvantage that each
message must be opened and closed.

Such opening and closing produces flashing on screen as the messages are
displayed briefly, and to date I have not found a way to avoid this, so when the
Merge to Email Message option is selected (or the HTML check box is selected)
the user will see a warning message. In addition I have removed the progress
indicator for Merges to Message body (but not when the HTML check box is
selected, as that is a much slower process and user indication is desirable).



A particular problem is that Word document format and formatted e-mail messages
are quite different in their presentation and capabilities. E-mail does not, for
example, support pages nor headers and footers, so if you are going to send the
document as a message body, you must check its layout carefully in Word's Web
view, and it would be advisable to create a dummy merge run with a limited
record set to ensure that the results are what you expect.

If you want to be certain that the recipient will see the document as you
intend, merging as an attachment - preferably in PDF format is the best way
forward.

Dialogs for One to One and Many to One are shown below.



THE ADD-IN HAS BEEN PROBLEMATIC FOR SOME USERS, WHEN USED WITH EXCHANGE SERVER
E-MAIL ACCOUNTS IN OUTLOOK. THIS RELATES TO THE WAY THE ACCOUNTS ARE CONFIGURED
AND A DIFFICULTY TO SEND THE MESSAGES CREATED IN THE TEMPORARY FOLDER. HOWEVER
THE DIFFERENCES FALL INTO TWO CAMPS AND I HAVE THEREFORE MADE THE ALTERNATIVES
SELECTABLE VIA A 'QUOTES' CHECK BOX THAT IS AVAILABLE ON THE USERFORM WHEN THE
EXCHANGE SERVER OPTION IS SELECTED. ONE OR OTHER SETTING OF THE 'QUOTES' CHECK
BOX SHOULD SUIT MOST EXCHANGE SERVER USERS.





Note that both options enable more of the tabbed pages of the userform. Common
to both are the 'Include Attachments' and the 'Copy to Third Party'. The Many to
One option additionally includes the 'List Field' which was described in a
previous section.

INVALID E-MAIL ADDRESSES

It is essential that the e-mail addresses in the data source are both present
and valid when an option to merge to e-mail is selected. When such an option is
selected, the add-in will examine all the e-mail addresses in the record set and
if any addresses do not meet the required standards for e-mail address formats,
the process will be stopped and you will see a warning message and the erroneous
record numbers and associated e-mail addresses are listed in a new document to
help you locate and correct them.

Note that it is the record number shown and not the row number in the Excel
worksheet.

WHEN ATTACHING THE EXCEL DATA SOURCE TO THE MERGE DOCUMENT, USE THE DEFAULT OLE
DB CONNECTION OPTION AND SELECT THE APPROPRIATE WORKSHEET FROM THE DIALOG. USE
OF ALTERNATIVE CONNECTIONS IS LIKELY TO PRODUCE MISSING E-MAIL ADDRESS ERRORS.

This function caters for the vast majority of possible e-mail address
configurations, however should you discover a genuine e-mail address reported as
erroneous, or an erroneous address that is not flagged as incorrect then please
e-mail me with the details so that I may modify the error trapping.

 

 

OUTLOOK TEMPORARY FOLDER

When 'Continue' is clicked, the messages are sent to a temporary sub folder of
the Outlook drafts folder (to ensure a unique location) named Merge Many To
One. If this folder is not present, it will be created.

ONE USER HAD REPORTED DURING THE TESTING CYCLE THAT THE MESSAGES WERE CREATED
NOT IN THE TEMPORARY SUB FOLDER, BUT IN THE DRAFTS FOLDER ITSELF. THE PROCESS TO
SEND MESSAGES WILL NOT HANDLE THE MESSAGES IF THEY ARE IN THE DRAFTS FOLDER. IF
THAT OCCURS, MANUALLY DRAG THE MESSAGES TO THE CORRECT FOLDER BEFORE SELECTING
THE OPTION TO SEND.

I WOULD APPRECIATE FEEDBACK FROM OTHER ANY OTHER USER WHO EXPERIENCES THIS
PROBLEM AS SO FAR I HAVE BEEN UNABLE TO RECREATE IT. IN PARTICULAR I WOULD
APPRECIATE DETAILS OF OUTLOOK ACCOUNT NAMES AND TYPES.

A button on the ribbon provides a function to remove the temporary folder should
you wish to do so. When removed the temporary folder is removed to the Deleted
items folder.

The temporary folder allows the safe examination of the messages and attached
documents produced, before committing to sending them. They will only be sent
when the 'Send Messages' button is clicked.

When the Send Messages button is clicked, the user is presented with a dialog in
which to choose whether to defer sending the messages until a later time. By
default the current time and date is displayed.

The dialog also allows for the sending of a subset of the messages in the
temporary draft folder. This is only necessary when the e-mail service provider
blocks large numbers of e-mail messages as part of a spam deterrent policy. If
this is not required simply leave the setting at the default '0' value.



The dialog is error trapped against inappropriate entry and from version 10.1
features a date picker control that does not use the MSCOMCT2.OCX object
library, that has proved problematical for uses with 64 bit operating systems.
to provide a date picker function.

THANKS TO TREVOR EYRE FOR DEVELOPING THE DATE PICKER FUNCTION. THE DATE PICKER
USERFORM AND ASSOCIATED CODE MAY BE DOWNLOADED HERE, SHOULD YOU WISH TO USE IT
IN YOUR OWN PROJECTS



WORD 2010 CHANGED THE WAY E-MAIL ACCOUNTS ARE FILED, SO EACH E-MAIL ACCOUNT CAN
HAVE ITS OWN INBOX/OUTBOX AND, MORE TO THE POINT, DRAFTS FOLDER. THE ADD-IN
SHOULD DETECT AND CREATE THE TEMPORARY FOLDER IN THE DRAFTS FOLDER RELATING TO
THE DEFAULT EMAIL ACCOUNT.

If you have Outlook configured to send messages immediately when connected (see
below), and subject to the values configured in the Delay function, clicking the
'send messages' button, irretrievably sends the messages to their destination
e-mail addresses.

If you have the option set not to send messages immediately when connected, then
you have a further opportunity to change your mind, by clicking the 'Continue'
button, which moves the messages to the Outbox.

If you choose the 'Continue' option, then you may use the Outlook Send and
Receive function to send on the messages.

MESSAGES THAT APPEAR TO BE 'STUCK' IN THE OUTLOOK OUTBOX CAN OFTEN BE SENT BY
CLICKING THE SEND BUTTON AGAIN AND CHOOSING THE SEND NOW OPTION.

NO MESSAGES ARE EVER SENT DIRECTLY FROM THE TEMPORARY DRAFT. MESSAGES ARE ONLY
SENT WHEN YOU REQUEST THEY BE SENT.



At various times you may see one of a variety of error and information messages.
I have not reproduced them here as they are self explanatory.

MESSAGE SUBJECT

The message subject is entered into the userform, and there is an option to
include the content of a field in the text. Note that the value used in the
subject will be that from the key record. The field may be placed before or
after the text in the subject text box.



INCLUDE ATTACHMENTS

Attachments may be included with the messages, and it was this provision that
caused the most head scratching for documents merged to the message body. You
may indicate the full path of the attachment in a field in the data file, which
would allow separate attachments to each message, or you could browse to select
a file to attach to all messages.

The Attachments dialog is similar for both One to One and Many to One
selections.



COPY TO THIRD PARTY

Users may wish to send the messages to a variety of recipients and the
application allows for this. The e-mail field, selected on the Merge tabbed
page, may contain multiple e-mail addresses separated by semi-colons.



The application will send the messages to each of the recipients entered into
the e-mail field. If the BCC option is selected, all recipients will be directed
to the 'BCC' box of the message header and thus be hidden from one another.

Users may also select a second e-mail field from the data source or enter an
e-mail address manually. This last option can be useful when it is a requirement
to send copies of messages to a co-worker, supervisor or head office.

BECAUSE THE REQUIREMENT TO SEND A COPY TO A SUPERVISOR ETC. IS LIKELY TO BE A
PERSISTENT REQUIREMENT, THERE IS A CHECK BOX ON THE COPY TO THIRD PARTY PAGE
THAT WHEN CHECKED WILL STORE THE TEXT ADDRESS FOR RE-USE. UNCHECKING THE BOX
WILL CLEAR THE DATA. NOTE THAT IF YOU CHECK THIS BOX, COPIES OF ALL MESSAGES
CREATED BY THIS FUNCTION WILL BE SENT TO THAT ADDRESS.

Again the additional recipients may be hidden from one another and the main
recipient(s), but if the main recipients are hidden and you choose the option
not to hide the additional recipients, you will be prompted to confirm that
choice.



 


ALTERNATIVE REPLY-TO ADDRESS

All e-mail options allow the user to select an alternative reply-to address.
This address may be retained for future use while the associated check box is
checked.


MERGE TO E-MAIL AS ATTACHMENT

The final option combines all the other functions already described and merges
the document as an attachment to an e-mail message in either Adobe PDF or Word
DOCX format. The covering message may be plain text entered from the userform or
a formatted Word document.



 

FORMATTED WORD DOCUMENT AS MESSAGE BODY

Checking the HTML Format check box  provides an option to select a Word document
to use as message body.

THE HTML FORMAT OPTION REMOVES THE OPTION TO SELECT A MESSAGE SIGNATURE. IF YOU
NEED A SIGNATURE BLOCK ON YOUR FORMATTED COVERING MESSAGE, THEN ADD IT TO THE
MESSAGE DOCUMENT.

 



Create your covering message in Word, formatted as you wish it to appear
(checking the appearance in Word's Web view) and save as 'docx' format. Enter
the path to that document, which will be used as a template to create the
covering documents. Inevitably this will slow the merge as that document is
accessed for each record.

The results is as follows:




DO NOT SAVE THE COVERING MESSAGE AS A MACRO ENABLED DOCUMENT OR TEMPLATE, OR IN
THE CASE OF DOT FORMAT, DO NOT INCLUDE MACROS IN THE TEMPLATE.

PERSONALISED FORMATTED COVERING MESSAGES

The document used as a covering message may also include form fields from the
same datasource. This provides the opportunity to personalise the covering
messages.

Create the covering message as shown above, and temporarily attach the same data
source used for the attachments. Insert the fields that you wish to use e.g.:

Then set the document type to 'Normal Word Document (though the add-in will do
this automatically if you forget).

When merged the data is read into the fields to produce personalised
accompanying messages with the attachments as follows (this time with a PDF
format attachment).:




A FEW IMPORTANT MATTERS NOT PREVIOUSLY MENTIONED.

THE MERGE TO E-MAIL MESSAGE OPTION IS DEPENDENT UPON THE OPTION TO SEND THE
CURRENT DOCUMENT TO AN E-MAIL RECIPIENT BEING AVAILABLE IN WORD. IF YOU FIND
THAT THIS OPTION DOES NOT PRODUCE ANY MESSAGES IN THE OUTLOOK OUTBOX, THEN THE
MOST PROBABLE REASON IS THAT THIS OPTION IS NOT AVAILABLE.

Its omission is caused by a MAPI error. Repairing Office from the Windows
Control Panel add or remove programs applet should fix it. Ensuring Outlook is
the default e-mail application in Windows should also fix it, but doesn't
always. This is not the fault of the add-in, but of the host application. As a
quick check, add the Send To Mail Recipient command from the All Commands
section to the Quick Access Toolbar. If there is a problem, the command will be
grayed out. This issue does not affect the alternative merge options provided.




FIELD ERRORS

When using the add-in it is possible that you will encounter the error message
shown in the next illustration in your document attachments.

The error occurs because the merge fields in the document are replaced with
docvariable fields. However, because of the way mail merge ignores certain
characters that may be used in the data source field names, the values that end
up in the document variables may not match the variable names in the docvariable
fields.

There is no documentation, that I have been able to find, that discusses how
Word mail merge handles field names, and, worse still, when there are several
similar field names, the mail merge renames the fields to avoid conflicts. I
have trapped all those unwanted characters that may reasonably found in a field
name, but I cannot do anything about your field naming with similar field names.

If you see such an error in any of your merge documents, check out the field
names, before reporting the issue to me. Toggle the display of fields to display
the errant field construction, so that you may cross reference it with the
corresponding field in the data source. The character that is different in the
Excel data source from the Word field is the one that needs to be fixed to make
it work correctly. Ensure especially that there are no leading spaces in your
column headings

IF YOU ARE UNABLE TO EDIT THE DATA SOURCE FOR WHATEVER REASON, AND THIS ISSUE IS
THUS INSURMOUNTABLE, LET ME KNOW THE CHARACTER IN QUESTION AND I WILL ADD IT TO
THE LIST OF CORRECTIONS. I DO NOT ANTICIPATE THAT THIS WILL OCCUR VERY OFTEN.



You may encounter the following error message when you select Start Merge from
the ribbon.



THE ADD-IN ADDRESSES THE EXCEL DATA DIRECTLY. IT IS NOT A CONVENTIONAL MAIL
MERGE. CONSEQUENTLY IF THE MACRO CANNOT ACCESS THE DATA IT REQUIRES, THE ERROR
MESSAGE IS CREATED.

This error will occur in circumstances that a conventional merge would handle.
In particular if you have hidden columns in your worksheet, or you have hard to
spot spaces in columns that are not used for the process, you will get phantom
field names, which the add-in will not be able to resolve. If you see this error
message, the first thing to check is for such phantom fields.

IF THE ISSUE RELATES TO  PHANTOM FIELDS, THIS ISSUE MAY BE CORRECTED FROM
VERSION 7.4, BY CLICKING THE CLEAN WORKSHEET BUTTON IN THE MISC FUNCTIONS MENU.




PDF CREATOR

The add-in includes options to create the PDF files using the Open Source
PDFCreator. Where the PDFCreator driver is present, the PDFCreator options will
be enabled in the add-in.

THE PROCESS HAS BEEN CONFIGURED TO USE THE CURRENT VERSION OF PDF CREATOR. IT
WILL NO LONGER WORK WITH THE EARLIER VERSION 1.7.3

NOTE THAT THIS ALSO INCLUDES PDF ARCHITECT, WHICH IS NOT REQUIRED, AND UNLESS
YOU WANT THIS APPLICATION, I WOULD RECOMMEND THAT YOU USE THE 'EXPERT'
INSTALLATION SETTINGS AND UNCHECK PDF ARCHITECT. NOTE ALSO THAT THE FREE VERSION
INSTALLER WILL OFFER ASSORTED PLUG-INS FOR YOUR BROWSER, THAT ARE CERTAINLY NOT
REQUIRED. MAKE SURE YOU DE-SELECT THESE DURING THE INSTALLATION.

When merging to PDF format with PDFCreator the add-in additionally provides the
option to engage PDF security measures. When the 'Continue' button on the main
dialog is clicked, a second userform will open to offer that facility. Clicking
'Cancel' on this userform will cancel the whole process.

The items shown disabled in the following illustration become available when a
Master Password is entered. If you don't want additional security measures then
don't set a Master Password!



The additional options become available when there is text in the Master
password text box. This includes the provision to add a common password to open
the PDFs or to use a password for each document from a field in the merge data
source, dependent on the setting of the 'User Password from Field' check box



If you continue without setting options, you will see the following dialog.
Click 'No' to set options or 'Yes' to continue without.



Currently the additional security options are only supported when the option PDF
is checked. Should you check one of the other PDF format types, the dialog
changes as shown below and any security settings entered are returned to their
default values.



The PDF files are created in the same folder as the documents.


- CLICK HERE TO VIEW A SHORT VIDEO OF THE BASIC PROCESS

This YouTube video is recorded at 1080P HD, so if it looks blurred on your
screen, change your YouTube view settings to HD.



FROM VERSION 17.0, THE ADD-IN RETAINS ALL YOUR CHOICES ABOUT THE CURRENT MERGE.
PROVIDED THE MERGE DOCUMENT AND THE DATA ARE AGAIN THE SAME, THE NEXT TIME YOU
RUN THE MERGE THE SAME SETTINGS ARE PRESENTED.

IF YOU CLICK THE CANCEL BUTTON, ALL THE SETTINGS RELATED TO THE MERGE ARE
ELIMINATED FROM THE REGISTRY. ONLY THE CONFIGURATION SETTINGS ARE THEN RETAINED.


- CLICK HERE TO DOWNLOAD THE MANY TO ONE ADD-IN

IF YOU EXPERIENCE PROBLEMS WITH THIS ADD-IN, THEN PLEASE READ THIS PAGE -
ESPECIALLY THE YELLOW PANELS - TO SEE IF YOUR PROBLEM IS ADDRESSED, BEFORE
REPORTING IT.

THE ADD-IN (FROM VERSION 14.7) IS COMPATIBLE WITH THE 64 BIT VERSIONS OF OFFICE
INCLUDING OFFICE 365

DO NOT USE THE ADD-IN TEMPLATE AS A DOCUMENT TEMPLATE FOR CREATING MERGE
DOCUMENTS!




Share Facebook Twitter LinkedIn google_bookmarks Email


 


 MERGE TOOLS

Some time ago I developed a pair of add-ins, based on an idea by fellow Word MVP
Doug Robbins, to enable mail merges to email with attachments and to perform
'many to one' merges.

Over the period these add-ins have been available I have had regular feedback
from users, suggesting enhancements, reporting bugs and pointing out and
limitations.

As the projects became more complex, I found that a lot of the material was
being duplicated, so I decided to take the plunge and redeveloped the add-in
from the ground up, to combine the two processes and to incorporate as many of
the suggestions for improvement as possible. This page demonstrates the fruit of
the many hours of work it took to complete and test the project.


 


Copyright Graham Mayor ©2012.

Home | What's New | Word Pages | Links | Downloads | Photo Gallery | Search |
Contact


✓
Thanks for sharing!
AddToAny
More…