Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-25-2023, 06:28 AM
RaeCalcipher RaeCalcipher is offline MailMerge Formula Windows 11 MailMerge Formula Office 2021
Novice
MailMerge Formula
 
Join Date: May 2023
Posts: 2
RaeCalcipher is on a distinguished road
Default MailMerge Formula

So I have a conundrum, and a lot of questions. I am trying to merge an excel sheet into mail merge. Simple, understand the process straight up, but for this task I need to get a lot of complicated. But first, this is the excel sheet I'm looking at is attached.



What I want to do is basically:
IF the street name column has a value use the new value. IF the street name value is blank THEN use the last value notated. Continue until a new value is seen, and repeat.


But every type of formula I've thought of and tried, it has not been successful. Can I create that formula, if so where do I start. OR do I have to be rudimentary and just fill in the blanks. It's totally okay if that's the answer and I'm just trying to be far more clever than possible.

Thank you!
Attached Images
File Type: png excel example.PNG (12.2 KB, 13 views)
Reply With Quote
  #2  
Old 05-25-2023, 04:15 PM
Guessed's Avatar
Guessed Guessed is offline MailMerge Formula Windows 10 MailMerge Formula Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
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

Have you tried this concept?

Where the street name appears, apply a specific style to it that doesn't appear anywhere else. Then, use a field with these components
If {mergefield} = Blank then {StyleRef stylename} else {mergefield}
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #3  
Old 05-26-2023, 04:48 AM
RaeCalcipher RaeCalcipher is offline MailMerge Formula Windows 11 MailMerge Formula Office 2021
Novice
MailMerge Formula
 
Join Date: May 2023
Posts: 2
RaeCalcipher is on a distinguished road
Default

I'll try it!! Thank you!
Reply With Quote
  #4  
Old 05-26-2023, 11:27 AM
kilroyscarnival kilroyscarnival is offline MailMerge Formula Windows 10 MailMerge Formula Office 2021
Expert
 
Join Date: May 2019
Posts: 344
kilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nice
Default

I haven't tried that in a mail merge, but I think I would modify the Excel sheet first to basically fill down the street name. Insert a helper column (new B), and tell it, basically, in cell B2:

=IF(A2="",B1,A2)

and copy that down.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
MailMerge Formula 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
MailMerge Formula Formula for Mailmerge sherrin Mail Merge 3 05-10-2019 03:12 PM
MailMerge Formula Mailmerge to Email with a mailmerge attachment Baldeagle Mail Merge 8 02-11-2013 04:40 AM
MailMerge Formula Mailmerge to Email with a mailmerge attachment Baldeagle Mail Merge 13 05-29-2012 02:04 PM
Mailmerge Formula mridley Mail Merge 0 07-27-2006 03:16 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:47 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