Hello,
I am new to Access and would like some assistance with creating a mailing list. I pull data from a third-party and am unable to edit the tables. This means the data comes through as it's housed by the third-party. What I've done is created a query to pull all of the necessary fields to create a mailing list. When the list is pulled, some words that wre used by the third-party are pulled in. I then have to clean up the mailing list in Excel to remove this internal "jargon".
As an example, if Field B = 6, I need to locate those records and then in Excel, do Find an Replace in Excel. This wouldn't be a bad way to do it except for the fact that there are 30+ Field B possibilites. This means that I have to Find and Replace 30+ different fields in Excel. Is there a way to create a macro in Access so that:
If Field B = 6, the query will do the Find/Replace steps for me. An example of what I would like is: If Field B = 6, Then Find/Delete " UAD ".
Creating this macro would save me A LOT of time...any help/input is greatly appreciated!