MAIL MERGE in WORD using EXCEL RESULTS as database 
http://www.srands.co.uk/Word&ExcelMailMerge.zip
OPEN ZIP FILE and EXTRACT to chosen FOLDER, however on opening word file, select correct excel file: 'exoftable4.xls', i.e: Pointing to the correct FOLDER that the EXCEL file is now saved in, as opposed to the FILE DIRECTORY LOCATION when last saved/created.
OPEN CREATED WORD MAIL MERGE DOCUMENT:
YES to open selected data, DATA LINK PROPERTIES, CONNECTION will appear
In 1. Browse all FILE TYPES, and browse to folder, where files are saved to: 'exoftable4.xls', OK.
VIEW, TOOL BARS, MAIL MERGE (Tick if NOT ticked), <<ABC>>, to toggle between FIELDS and ACTUAL DATA.
VIEW MAIL MERGE:
When finished to toggle between CODE and ACTUAL FIELDS, press the MAIL MERGE ICON <<ABC>> 'VIEW MERGED DATA'.
|< Start of records
< Backwards through records
> Forwards through records
|> Finish of records
OR
CREATE YOUR ON MAIL MERGE LETTER from any EXCEL WORKBOOK or ACCESS db:
TOOLS, LETTERS and MAILINGS, MAIL MERGE, LETTERS, NEXT, USE CURRENT DOCUMENT,
NEXT, SELECT RECIPIENTS, USE AN EXISTING LIST, BROWSE, SELECT EXCEL WORKBOOK,
SELECT EXCEL TAB within WORKBOOK, select 1ST COLUMN, NON BLANKS, SELECT ALL, OK.
VIEW, TOOL BARS, MAIL MERGE (Tick if NOT ticked), INSERT MERGE FIELDS (A4 icon), DATAFIELDS, then select your chosen EXCEL HEADINGS, 1 field at a time!
MAIL MERGE RESULTS:
Press the MERGE TO NEW DOCUMENTS icon or MERGE TO PRINT.
QUESTION 1). Is there a FORMULA and/or VB CODE way for MAIL MERGING to WORD from EXCEL? Hence a word document would be created, however I guess this would cause some issues:
~ If started in EXCEL instead of WORD then LETTER without elabourate HEADER, FOOTER, logos, unless all paper in printer is already LETTERHEADED.
~ Alternatively prompt EXCEL to use a designated TEMPLATE
Anyway the attached sample files work.
Crossthreads:
http://www.ozgrid.com/forum/showthread.php?t=164631&p=605529#post605529
http://www.srands.co.uk/Word&ExcelMailMerge.zip
OPEN ZIP FILE and EXTRACT to chosen FOLDER, however on opening word file, select correct excel file: 'exoftable4.xls', i.e: Pointing to the correct FOLDER that the EXCEL file is now saved in, as opposed to the FILE DIRECTORY LOCATION when last saved/created.
OPEN CREATED WORD MAIL MERGE DOCUMENT:
YES to open selected data, DATA LINK PROPERTIES, CONNECTION will appear
In 1. Browse all FILE TYPES, and browse to folder, where files are saved to: 'exoftable4.xls', OK.
VIEW, TOOL BARS, MAIL MERGE (Tick if NOT ticked), <<ABC>>, to toggle between FIELDS and ACTUAL DATA.
VIEW MAIL MERGE:
When finished to toggle between CODE and ACTUAL FIELDS, press the MAIL MERGE ICON <<ABC>> 'VIEW MERGED DATA'.
|< Start of records
< Backwards through records
> Forwards through records
|> Finish of records
OR
CREATE YOUR ON MAIL MERGE LETTER from any EXCEL WORKBOOK or ACCESS db:
TOOLS, LETTERS and MAILINGS, MAIL MERGE, LETTERS, NEXT, USE CURRENT DOCUMENT,
NEXT, SELECT RECIPIENTS, USE AN EXISTING LIST, BROWSE, SELECT EXCEL WORKBOOK,
SELECT EXCEL TAB within WORKBOOK, select 1ST COLUMN, NON BLANKS, SELECT ALL, OK.
VIEW, TOOL BARS, MAIL MERGE (Tick if NOT ticked), INSERT MERGE FIELDS (A4 icon), DATAFIELDS, then select your chosen EXCEL HEADINGS, 1 field at a time!
MAIL MERGE RESULTS:
Press the MERGE TO NEW DOCUMENTS icon or MERGE TO PRINT.
QUESTION 1). Is there a FORMULA and/or VB CODE way for MAIL MERGING to WORD from EXCEL?
Hence a word document would be created, however I guess this would cause some issues:~ If started in EXCEL instead of WORD then LETTER without elabourate HEADER, FOOTER, logos, unless all paper in printer is already LETTERHEADED.
~ Alternatively prompt EXCEL to use a designated TEMPLATE
Anyway the attached sample files work.
Crossthreads:
http://www.ozgrid.com/forum/showthread.php?t=164631&p=605529#post605529
Last edited:
