Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-03-2023, 01:32 PM
maw444 maw444 is offline Adding appendix and refences during mailmerge Windows 10 Adding appendix and refences during mailmerge Office 2019
Advanced Beginner
Adding appendix and refences during mailmerge
 
Join Date: Feb 2021
Posts: 35
maw444 is on a distinguished road
Default Adding appendix and refences during mailmerge

I have a document to which I would like users to add appendices / schedules depending on their needs.



As an example:-

Letter could have a total of 10 additional schedules of which a client only needs, say , two.

Client may want appendix A and appendix C

Another client may want appendix B and D.

I was going to have a tick box where the user could select which appendices could be required, and to store them as documents on the server. Depending on the result the appropriate appendix could be added to the main document during mail merge.

However, the result is that the heading says 'Appendix 1', 'Appendix 3' etc. I would like a way of renumbering them to '1' and '2' etc etc

Finally - I would like to add a sentence to the main docuennt which says 'We refer you to Appendix 1 - page 3, Appendix 2 - page 4 etc.

Is this possible?
Reply With Quote
  #2  
Old 05-03-2023, 03:49 PM
Guessed's Avatar
Guessed Guessed is offline Adding appendix and refences during mailmerge Windows 10 Adding appendix and refences during mailmerge Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,977
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Firstly the answer is Yes, it is possible. The best way may not be by using a mail merge though.

I have some questions for you.

1. Is the customer-specific data entry selections done for lots of customers prior to producing the output letters or are you doing the letter for one customer at a time.

2. Are you converting the result to PDF to send out or keeping the output in Word?

Autonumbers and Cross-References are the names of features that answer your questions about the appendix letters and sentences referring to them.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #3  
Old 05-04-2023, 12:28 AM
maw444 maw444 is offline Adding appendix and refences during mailmerge Windows 10 Adding appendix and refences during mailmerge Office 2019
Advanced Beginner
Adding appendix and refences during mailmerge
 
Join Date: Feb 2021
Posts: 35
maw444 is on a distinguished road
Default

The letters are being generated on a one by one basis.

The process is:-

- Mail merge started which draws in the customer specific data held in our database. The data is stored in a SQL database.

- at the moment the appendix (ices) are added manually (cut / paste) by the user. It is this part that I was hoping to automate by presenting them with a tick box system which adds the correct ones to the file.

- for some clients we print off the resulting letter - others we 'save as pdf' and email across
Reply With Quote
  #4  
Old 05-04-2023, 05:26 AM
Charles Kenyon Charles Kenyon is offline Adding appendix and refences during mailmerge Windows 11 Adding appendix and refences during mailmerge Office 2021
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,140
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Strictly using mail merge, the simplest method would be to add data in the original customer data source as to which appendices to use. Have it input with the original data, not as a user choice when putting the letter together. You switched your numbering style in the middle of your question, first discussing Appendix A, B, C, etc. and then 1, 2, 3, etc. Does this matter? Which do you want?

You could store your Appendices either as separate documents to be incorporated or as AutoText/Building Blocks entries. They could easily be numbered using SEQ fields.
Reply With Quote
  #5  
Old 05-04-2023, 05:32 AM
Charles Kenyon Charles Kenyon is offline Adding appendix and refences during mailmerge Windows 11 Adding appendix and refences during mailmerge Office 2021
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,140
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Quote:
Originally Posted by maw444 View Post
***
However, the result is that the heading says 'Appendix 1', 'Appendix 3' etc. I would like a way of renumbering them to '1' and '2' etc ***
Do you mean heading or header? Either can be handled.
What is the difference between headings and headers?
Reply With Quote
  #6  
Old 05-04-2023, 01:48 PM
maw444 maw444 is offline Adding appendix and refences during mailmerge Windows 10 Adding appendix and refences during mailmerge Office 2019
Advanced Beginner
Adding appendix and refences during mailmerge
 
Join Date: Feb 2021
Posts: 35
maw444 is on a distinguished road
Default

I mean the heading - not header.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding appendix and refences during mailmerge Macro to insert an image to a word mailmerge document based on the value of a mailmerge field? Jake93 Mail Merge 3 07-02-2019 05:38 PM
Adding appendix and refences during mailmerge Appendix field switches LadyBug679 Word 10 11-05-2015 03:39 PM
Appendix, Tables and Index tanias Word 1 05-21-2014 11:08 AM
Automatic Appendix darksupernova Word 8 03-02-2013 04:12 AM
Creating an appendix in word MichaelDaniels Word 3 02-01-2013 12:30 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:59 PM.


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