#1
|
|||
|
|||
Mail Merge: field code DATABASE table style and others
Hi.. Good day, newbie here..
I'm currently creating new dynamic Mail Merge table right now.. I think i need it because I usually get random data count to be processed and I don't want to change my table's size every time.. I get several issues and question regarding this field code, 1. Can I do auto numbering in field code without using excel? 2. Did anybody has DATABASE style list? its so exhausting to check one by one. I'm currently using \l "15" \b "49".. 3. Can I add separation line or vertical spacing between data in my table using field code? For reference, I attach my ongoing file.. I hope somebody can answer my question.. Thanks and Kind Regard.. MaunG |
#2
|
||||
|
||||
If you're trying to use a DATABASE field in a normal ‘letter’ mailmerge main document, you'll need a macro to drive the process. An outline of this approach can be found at: Many to one email merge using tables - Microsoft Community
Conversely, if you're using a relational database or, Excel workbook with a separate table with just a single instance of each of the grouping criteria, a DATABASE field in a normal ‘letter’ mailmerge main document could be used without the need for a macro. An outline of this approach can be found at: Mail Merge - To a Word Table on a Single Page - Microsoft Community For some working examples, see: Mail Merge: Using One Excel File with Multiple Sheets Merge excel list into Word Receipt The DATABASE field can even be used without recourse to a mailmerge. An example of such usage can be found at: Mail merge into different coloumns As for the formatting options, see under Insert|Quick Parts|Field>DATABASE>Insert Database>Get Data: (connect to the data source) > Table AutoFormat.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Wow, I didn't know it was there all along in toolbar.. Neaaatt..
Thats what I need most.. As for Macro and ManytoOne, I think ill pass for today since it requires more understanding.. Ill do manually in excel for a while.. Thanks a lot, Paul Kind regard MaunG |
Tags |
excel 2019, field code, mail merge |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Include Table of Contents by Mail Merge Field | vandelayindies | Mail Merge | 1 | 01-08-2018 03:06 PM |
How do I mail merge records into table columns with more than one merge field? | tech123 | Mail Merge | 1 | 04-26-2017 07:13 PM |
VBA Code to search for field codes with certain text before the Field code and to change style | welcometocandyland | Word VBA | 4 | 02-08-2017 06:53 PM |
Mail merge to table, new page/doc when field chnges | grumpybattler | Mail Merge | 5 | 05-19-2015 04:13 PM |
Mail merge Field Code Manipulation | macjnr | Mail Merge | 0 | 09-10-2009 11:37 AM |