Link to home
Start Free TrialLog in
Avatar of Wonderwall
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.    
Avatar of GrahamSkan
GrahamSkan
Flag of United Kingdom of Great Britain and Northern Ireland image

If I understand you, you have a working query that you use as a record source for your mail merge and you want to know if you should delete it.

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.
Avatar of Wonderwall
Wonderwall

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
Avatar of lwebber
lwebber

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial