Wonderwall
asked on
MS Wod mail Merge drop datasource
Aloha I have just created my first mailmerger letter. It is connected to a SQL Server table. In my Stored Procedure drop the source and recreate it in exactly the same structure (monthly run).
Since I have the letter just the way I want will dropping the table drop the formatting? Should I do a truncate or delete and then an insert? mahalo for your help.
Since I have the letter just the way I want will dropping the table drop the formatting? Should I do a truncate or delete and then an insert? mahalo for your help.
ASKER
Hi yes I do a table drop and recreate it in the stored procedure. I can change it to not drop the table and delete the data and insert new rather that drop. It's just more coding and there are alot of columns to line up on the insert rather tha select * into table
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I cannot think of a reason why you should do that. The next time that you run the mail merge, the data in the tables will probably have changed, but the query should still work with the new data.