|I'd like to be able to add a note to a memo field in a contact form for multiple contacts using either a query, search and replace or a rubber chicken with magic incantations. I don't really care how I get there. What I want to be able to do is, after sending a few dozen e-mails, update each record with exactly the same phrase noting that I did so.|
Search-and-replace works fine but doesn't seem to allow me to add in carriage returns/line feeds so the notation just looks like one long sentence.
An update query also doesn't seem to work. When I search for an exact phrase, nothing shows up because the field has other content in it. When I search for that same phrase with wildcards the records show up but the entire field is selected and eliminated, replaced with the target, meaning I lose all my other notes in the same field. There must be a simple solution to this but I'm not able to find it. People don't manually update each record do they? The update query likewise places the carriage return/line feeds literally instead of as an actual change of line.
Is VBA the answer?
Brian Grover, Author
BC Car-Free: Exploring Southwestern British Columbia without a Car