Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-07-2019, 10:32 PM
MaunG MaunG is offline Mail Merge: field code DATABASE table style and others Windows 10 Mail Merge: field code DATABASE table style and others Office 2019
Novice
Mail Merge: field code DATABASE table style and others
 
Join Date: Dec 2019
Posts: 2
MaunG is on a distinguished road
Default 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
Attached Files
File Type: xlsx test.xlsx (11.7 KB, 1 views)
File Type: docx test.docx (19.3 KB, 1 views)
Reply With Quote
  #2  
Old 12-07-2019, 11:03 PM
macropod's Avatar
macropod macropod is offline Mail Merge: field code DATABASE table style and others Windows 7 64bit Mail Merge: field code DATABASE table style and others Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,763
macropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud of
Default

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
[MS MVP - Word]
Reply With Quote
  #3  
Old 12-07-2019, 11:58 PM
MaunG MaunG is offline Mail Merge: field code DATABASE table style and others Windows 10 Mail Merge: field code DATABASE table style and others Office 2019
Novice
Mail Merge: field code DATABASE table style and others
 
Join Date: Dec 2019
Posts: 2
MaunG is on a distinguished road
Default

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
Reply With Quote
Reply

Tags
excel 2019, field code, mail merge

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge: field code DATABASE table style and others Include Table of Contents by Mail Merge Field vandelayindies Mail Merge 1 01-08-2018 03:06 PM
Mail Merge: field code DATABASE table style and others 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
Mail Merge: field code DATABASE table style and others 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


All times are GMT -7. The time now is 12:30 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft