SELECT DISTINCT dbo_Receiver.ID AS Receiver_ID, dbo_RECEIVER_LINE.LINE_NO AS Line_No, dbo_Purchase_Order.ID AS PO_ID, dbo_Purchase_Order.VENDOR_ID AS Vendor_ID, dbo_Vendor.USER_5 AS [Vendor Name], dbo_Vendor.COUNTRY AS Country, dbo_PURC_ORDER_LINE.PART_ID AS Part_ID, Combined_Part.Description, "Commercial Invoice" AS [Attach-1], "Packing List" AS [Attach-2], [Part Lines].[Entry#] AS [Import Entry], dbo_Receiver.RECEIVED_DATE AS Received_Date, "Import Drawback for " & Year([Received_Date]) & " " & [Receiver_ID] & " Entry#: " & [Entry#] AS Subject, "Receiver_ID: " & [Receiver_ID] & Chr(13) & "PO#: " & [dbo_receiver]![Purc_Order_ID] & Chr(13) & "Vendor_ID: " & [Vendor_ID] & Chr(13) & "Vendor Name: " & [dbo_Vendor]![User_5] & Chr(13) & "Country: " & [Country] & Chr(13) & "Part_ID: " & [dbo_Purc_Order_Line]![Part_ID] & Chr(13) & "Description: " & [Combined_Part]![Description] & Chr(13) & "Import Entry: " & [Entry#] & Chr(13) & "Received Date: " & [Received_Date] & Chr(13) & Chr(13) & "Roger Cooper" & Chr(13) & "Spectronics Corporation" AS Body
FROM (([Import Drawback Receiver] INNER JOIN ((((dbo_Receiver INNER JOIN dbo_Purchase_Order ON dbo_Receiver.PURC_ORDER_ID = dbo_Purchase_Order.ID) INNER JOIN dbo_Vendor ON dbo_Purchase_Order.VENDOR_ID = dbo_Vendor.ID) INNER JOIN dbo_RECEIVER_LINE ON dbo_Receiver.ID = dbo_RECEIVER_LINE.RECEIVER_ID) INNER JOIN dbo_PURC_ORDER_LINE ON (dbo_RECEIVER_LINE.PURC_ORDER_LINE_NO = dbo_PURC_ORDER_LINE.LINE_NO) AND (dbo_RECEIVER_LINE.PURC_ORDER_ID = dbo_PURC_ORDER_LINE.PURC_ORDER_ID)) ON [Import Drawback Receiver].Receiver_ID = dbo_Receiver.ID) INNER JOIN Combined_Part ON dbo_PURC_ORDER_LINE.PART_ID = Combined_Part.Part_ID) LEFT JOIN [Part Lines] ON (dbo_RECEIVER_LINE.RECEIVER_ID = [Part Lines].Receiver_ID) AND (dbo_RECEIVER_LINE.PURC_ORDER_ID = [Part Lines].[PO#])
ORDER BY dbo_Receiver.ID, dbo_RECEIVER_LINE.LINE_NO;