Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 10-12-2017, 08:25 PM
notalec notalec is offline Windows 10 Office 2016
Novice
 
Join Date: Oct 2017
Posts: 4
notalec is on a distinguished road
Default saving conditional statements

I have a data set that is being output from File Maker. I need to be bale to create a template so that someone can create an update directory with as little effort as possible. Part of this includes creating a directory of services grouped by topic. I have two questions regrading this.



1. I cant seem to save conditional statements when I save my template. I open it back up and the statements are just gone. If I have already attached my data source then the conditions are already evaluated. I will need to enter approximately 50 of these. So I really need them to be saved. I have tried just about every file type there is but still no luck.


2. I need something similar to a while loop. I have a heading that lists the type of service, then I need to list all of the entries that are tagged with that type of service. So it should read something like this

childcare services

first place that offers childcare

second place that offers childcare

third place that offers childcare

I have only been able to output the heading "childcare services" above each one of the entries.

Hopefully that all made sense. Thanks for your help!
Reply With Quote
  #2  
Old 10-13-2017, 11:26 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,199
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

How are you creating these 'conditional' statements and why are you using a template instead of a mailmerge main document?
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 10-14-2017, 04:46 PM
notalec notalec is offline Windows 10 Office 2016
Novice
 
Join Date: Oct 2017
Posts: 4
notalec is on a distinguished road
Default

Maybe I have my terminology wrong. what is the difference between a template and a mail merge main document?

I am creating the conditional statements by hitting ctrl+f9 and entering the statement in the resulting brackets.
Reply With Quote
  #4  
Old 10-14-2017, 11:18 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,199
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Re templates, see:
https://support.office.com/en-us/art...2-1191BCE57DEB
https://support.office.com/en-us/art...A-A6F5E3E8B9AE
A mailmerge main document, on the other hand, is a document that has been connected to a data source for mailmerge purposes. Once you've completed its setup and saved it, it's suitable for running as many mailmerges as you need. You shouldn't have to recreate any field coding or filters each time, but you will need to answer to the SQL prompt you receive when opening the document.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #5  
Old 10-16-2017, 09:33 AM
notalec notalec is offline Windows 10 Office 2016
Novice
 
Join Date: Oct 2017
Posts: 4
notalec is on a distinguished road
Default

I have a lot of conditional statements to enter. I need to be able to save my work on them and come back to it later, also I need other people to be able to open them up and view the structure of the statement. When I hit "ctrl+f9" to bring up the curly braces, enter in my statements, save the document, and then reopen the document, the curly braces and everything inside of them is gone. Is there no way to save the statements in an unevaluated form?
Reply With Quote
  #6  
Old 10-16-2017, 03:06 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,199
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

The conditional statements will still all be there in a fully-functional state. Simply pressing Alt-F9 will reveal them. Pressing Alt-F9 again will hide them.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #7  
Old 10-16-2017, 09:02 PM
notalec notalec is offline Windows 10 Office 2016
Novice
 
Join Date: Oct 2017
Posts: 4
notalec is on a distinguished road
Default

OMG thats all it was. Than you!

What about my other issue? I am trying to output all of the contacts that contain a certain value in a field. so I can do something like this.

Static Text

first contact whos filed matches value x
Second contact whos filed matches value x
Third contact whos filed matches value x
ect....

Static Text

first contact whos filed matches value y
Second contact whos filed matches value y
Third contact whos filed matches value y
ect.....
Reply With Quote
  #8  
Old 10-16-2017, 09:34 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,199
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Without seeing your mailmerge main document and, perhaps the data source, it's difficult to say what the best approach might be. For a single set of repeated data, one might use a catalogue/directory merge but, because you have multiple sets of repeated data, I suspect a DATABASE field might be more appropriate in this case.

Can you attach a your mailmerge main document and some sample data to a post (delete anything sensitive)? You do this via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
I know nothing about mail merge, but need help with conditional statements briyosa Word 1 03-27-2017 10:17 PM
Conditional Formatting deleted by excel when saving and reopening file sazetts Excel 7 02-09-2017 10:52 AM
Help with if then statements brent chadwick Word VBA 35 07-25-2015 02:41 PM
Using IF statements stuwoolf Excel 2 01-10-2015 01:58 PM
Multiple If statements, Jamal NUMAN Excel 12 08-07-2013 01:41 AM


All times are GMT -7. The time now is 11:13 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft