I hope I’m just doing something wrong here. I have a table of prospects that I run a direct-mail campaign against. I want to stagger my mailings, and track with prospects are mailed each week, so I added a column to tag those records with a mailing-ID. I have a need to export only those prospects to hand off yo my marketing folks so the mail can go out. To do this, I created a linked-view so that I only see the prospects based on the mailing-ID I selected. So far, so good. However, when I went export the view, it gave me back EVERY records in the prospects table.
There are 2 things I would like to accomplish.
- Export ONLY the records present in the prospects-by-mailings view.
- I also need to change the names of the columns in the view without affecting the column names in the original Prospects table.