GOAL: On a monthly basis, create a membership roster containing the mailing address in a tab delimited format.
Task contains the following tools (screenshoot above):
- Event, Schedule
- Input, Database Query
- Format, Format As Text
- Output, Save As File
The technique that I wanted to share is how to insert the Tab character into a text document. After some trial and error I found that the following worked for me in the Detail section of the Format As Text object:
{=ThisStep.RecordSource("ID")}{=vbTab}{=ThisStep.RecordSource("prefix")}{=vbTab}...
