Automated email - Please Help

[T8JGT]

Hi

I have a query (qryITSQFSubmission) which contiains inforamtion used to write a weekly meeting agenda. Each record must be individually must submitted by email as the body text and then removed from the query e.g. setting a status field to "submitted". The submission must be in a particular format (detailed below). Any help would be appreciated.

«ITSQFDocumentName» received from «ProjectServiceDesigner»: ‘«ProjectName»’ - PAR «ProjectPAR»
Go Live - «ProjectLiveDate»

«ProjectSummary»

«ITSQFServRecommendation»«ITSQFQualityGate»
«ITSQFList»

«ITSQFDocumentAddress»

 

[PHV]

Topic several times covered.
Have you tried a Search ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244