Emaze Auction: Send Newsletter Send Newsletter SELECT email FROM Member

Newsletter successfully sent!

"> "> Below is a list of the subscribers to which the newsletter has been sent:

#email#

Newsletter last sent on #DateFormat(newsletterLastSent,"dddd, mmmm dd, yyyy")# at #TimeFormat(newsletterLastSent,"hh:mm tt")#

SELECT lotID, lotName, lotOpeningBid, lotCloseDateTime FROM Lot WHERE lotDateTimeCreated >= #newsletterLastSent# AND lotCloseQueue <> -1 ORDER BY lotName

From name: (leave blank for no name)

From email:

Subject:

Message: Below are the new lots posted since the last newsletter: <CFOUTPUT QUERY=getNewLots>Item: #lotName# Opening Bid: #LSCurrencyFormat(lotOpeningBid,"local")# Closes: #LSDateFormat(lotCloseDateTime,'dddd, mmmm dd, yyyy')# / #LSTimeFormat(lotCloseDateTime,'hh:mm tt')# #systemURL#/lot.cfm?lotID=#lotID# </CFOUTPUT>

From name:	(leave blank for no name)
From email:
Subject:
Message:	Below are the new lots posted since the last newsletter: <CFOUTPUT QUERY=getNewLots>Item: #lotName# Opening Bid: #LSCurrencyFormat(lotOpeningBid,"local")# Closes: #LSDateFormat(lotCloseDateTime,'dddd, mmmm dd, yyyy')# / #LSTimeFormat(lotCloseDateTime,'hh:mm tt')# #systemURL#/lot.cfm?lotID=#lotID# </CFOUTPUT>