Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Saving as Draft from a VB Macro 1

Status
Not open for further replies.

BlooDive

Technical User
Jul 2, 2003
2
GB
Hi one and all

I am trying to get a VB macro to automate my monthly mailing list and have succeeded in getting the wole thing to run. My problem is that I want a command that will send my mail to the Draft folder rather than sending it out directly. Does anybody have any ideas?
 
Draft is not a folder, it is a view. Therefor, all docs with certain field values will automatically be shown in the view.
The simple thing to do is check the Draft view in Designer, note the Selection Formula of the view and ensure that all docs you work on in VB have the corresponding field values set before saving.

Good luck !

Pascal.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top