MailMerge Formula

		Microsoft Office Forums > Microsoft Word > Mail Merge
MailMerge Formula

FAQ

Thread Tools

Display Modes

05-26-2023, 11:27 AM

kilroyscarnival kilroyscarnival is offline

Windows 10 MailMerge Formula

Office 2021

Expert

Join Date: May 2019

Posts: 358

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.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
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
Formula for Mailmerge	sherrin	Mail Merge	3	05-10-2019 03:12 PM
Mailmerge to Email with a mailmerge attachment	Baldeagle	Mail Merge	8	02-11-2013 04:40 AM
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 02:56 AM.