Option 1: 
Altru now offers the ability to send email receipts immediately on completion of the Advance Sales Order. See our related solution: I need to send email receipts in advance sales

Option 2: 
If you would like to send emails in bulk or perform a custom receipt mailing (for example: invoices, details about a specific program), you can also use the steps below to create a mailing using the Appeal Mailing process in Altru. You can copy this mailing and run this daily to send confirmations for your Advance Sales orders that day:
  1. Create a query of all Advance Sales Orders
    1. From Analysis, click Query
    2. Click Add Ad-Hoc query, select Constituent as the record type
    3. Click OK
    4. Expand Sales Orders, drag Transaction date to ‘include records where’ select equal to Today
    5. Drag Sales Method Type to ‘include records where’ select to equal to Advance Sales 
    6. Drag Sales Method status to ‘include records where’ select equal to Complete
    7. On the Set save options tab, enter a name
    8. Mark create a dynamic selection & show in query designer
  1. Create exclusion query for people that already received confirmation 
    1. From Analysis, click Query
    2. Click Add Ad-Hoc query, select Constituent as the record type
    3. Click OK
    4. Highlight Appeal Mailing, drag Date Added to ‘include records where’ select equal to Today
    5. Drag letter to ‘include records where’ select equal to (Letter Name)
    6. On the Set Save Options tab, name the query, mark to create a dynamic selection & show in query designer, click Save
  2. Create an Appeal Record
    1. From Marketing and Communications, click Add an appeal
    2. Enter the name, Standard Ticketing Acknowledgement
    3. Enter a description
    4. Leave category, report code and membership blank
    5. Click Save
  3. Create the appeal mailing
    1. On the Mailings tab, click Add
    2. In the Name field, enter Ticket Confirmation Letter <Today’s Date>
    3. Select Today as the Mail Date
    4. Select Standard address processing
    5. Select send a letter to each individual in the household
    6. Click NEXT
    7. Name the letter Ticket Confirmation Email
    8. In the ‘selection of constituents’ click Add
    9. Expand Selections
    10. Choose the query saved in step #1
    11. Click OK
    12. In the ‘exclude constituents based on the following’ click Edit next to solicit codes and selections, choose query created in step #2
    13. In the Letter content section, click Email
    14. In the ‘Write your Letters content’ click Add
    15. Enter the subject, from address, display name and reply to address
    16. Type your letter leaving space for merge fields. 
Note: Here is a sample confirmation letter

***************************************************************************************
Dear <Full Name>,

Thank you for supporting <Organization Name>. Please read this confirmation letter for instructions on how to pick up your tickets.

List Specific events coming up that have special instructions




Questions about your tickets? Please reply to this email or call the Ticket Office, XXX-XXX-XXXX.

Here is a summary of your payment:

Payment Method: <Payment Method> <Credit Card Number>
Total: <Amount>
Date: <Transaction Date>

Privacy Page Link
Email Preferences Link


Item Description Quantity Event Start Date Event Start Time
Description 1 Quantity 1 Start Date Start Time
Description 2 Quantity 2 Start Date Start Time
Description 3 Quantity 3 Start Date Start Time
Description 4 Quantity 4 Start Date Start Time
Description 5 Quantity 5 Start Date Start Time
Description 6 Quantity 6 Start Date Start Time
Description 7 Quantity 7 Start Date Start Time

***************************************************************************************
  1. Inserting Merge Fields
    1. Each Field in < > and the fields in the graph are all merge fields
    2. Click the Merge Fields drop down, select More Fields
    3. Expand Constituent Marketing Information, Expand Constituent, Sales Orders
    4. Drag Amount to the selected fields. Also, drag Transaction Date to the selected fields
    5. Expand Sales Order, Order Item, drag Description to the selected fields
    6. Select to export 8 or 10 items, depending on what you think the maximum number of items in an order may be
    7. Also, drag Quantity to the selected fields
    8. Expand Sales Order Item Ticket, Program Event, drag Start date, Start Time to the selected fields
    9. Expand Sales Order Payment, Revenue, drag Payment Method & Card Number to the selected fields
    10. Click Save
    11. In the letter, insert these fields in the appropriate places. To do this, click the merge fields drop down list, select the field
  2. Finishing the letter
    1. Once finished writing the letter, click OK
    2. Click NEXT
    3. Click Finish and Close
    4. Click RUN Mailing
  3. Repeat Every Day
    1. At the end of every day, you will copy this mailing and send it
    2. From Marketing and Communications, click Appeal Mailings
    3. Highlight the Mailing, click Copy
    4. Click Edit mailing, change the date in the name, click Save
    5. Run the Mailing