Solved If then Mail Merge question (1 Viewer)

JS Smith

New member
Local time
Today, 01:34
Joined
Mar 31, 2021
Messages
15
Hi just starting to learn Access and Word Mail Merge. I couldn't find answer via Google. Nearest solution was the Next Record but wasn't sure how the syntax should read.

My Access Table is like the sample below. How can I use formulas in the Merge Fields to give me the «Project Contact» if the «Scope_of_Work» = Owner?

CAM Project NumberScope of WorkAmount in NumbersProject Contact
12345​
ArchitectPete Smith
12345​
Owner$520,000.00Tammy Jones
12345​
scope 1$1,800.00Mike Connor
12345​
scope 2$1,800.00Jim Staples
12345​
scope 3$11,000.00Jamie Cox
12345​
scope 4$21,000.00Cindy Davis

Thanks, as always, for an help you may provide!
 

June7

AWF VIP
Local time
Yesterday, 23:34
Joined
Mar 9, 2014
Messages
3,429
Use a query as source for merge. Calculate a field with expression: IIf([Scope of Work]="Owner", [Project Contact], Null)
 

JS Smith

New member
Local time
Today, 01:34
Joined
Mar 31, 2021
Messages
15
Thanks @June7 for the suggestion. I'll keep that in mind.

Took lots of experimenting but it works with {IF { MERGEFIELD Scope_of_Work} = "Owner" "{ Project Contact }" ""}
Total pain , though, as you have to use CTRL+F9 for every bracket and without VBA you can't copy, paste and adjust the line for another field; it has to be typed from scratch.
 
Last edited:

Users who are viewing this thread

Top Bottom