Reply To: OR function using reference of text as part of a sentence

Home Forums Google Sheets & Forms OR function using reference of text as part of a sentence Reply To: OR function using reference of text as part of a sentence

#3339
AvatarFiona Bellinger
Participant
Points: 51

Hi Emma,

This is the only Regex expression I have built – very much trial and error and watching tutorials….

A colleague uses a mail merge spreadsheet to automatically produce and email letters.  Unfortunately she doesn’t pick up when there is an error and the merge doesn’t work or send.  I use this expression to locate the word INVALID in amongst all the automatic document merge status (ie: Document successfully merged; !!Error Sending Emails: Invalid email: <xxx Email>>; Manually run by [email protected]; Timestamp: Sep 20 2017 9:51 PM) , which results in the cell turning red and the work CHECK flash up.

Fiona

 

Skip to toolbar