| If you are unable to view this email, try the online version |
|
|
|
|
| New catalogues |
|
| %%[IF Length(@firstname) > 0 THEN]%%
%%= v(@firstname ) =%%, weíve
%%[ELSE]%%
Weíve
%%[ENDIF]%%
got brand new catalogues we thought you might be interested in, as youíve registered with these auctioneers before on i-bidder.com. Take a look at what is on offer, and register now to bid! |
|
%%[
IF ROWCOUNT(@newcatalogueitems) > 6 then
SET @emailrows=6
ELSE SET @emailrows=ROWCOUNT(@newcatalogueitems)
ENDIF
FOR @rowcount = 1 to @emailrows do
SET @currentauction = ROW(@newcatalogueitems, @rowcount)
SET @currentauctionid = FIELD(@currentauction, "auctionId")
SET @auctioneer = FIELD(@currentauction, "clientName")
SET @auctiontitle = FIELD(@currentauction, "title")
SET @auctiondate = Format(FIELD(@currentauction, "AuctionDateTimeLocal"),"dd/MM/yyyy HH:mm")
SET @timezone = 'BST' /*FIELD(@currentauction, "timezone")*/
SET @currentclientid = FIELD(@currentauction, "clientId")
SET @clientdetails = LOOKUPROWS("ent.client", "clientId", @currentclientid)
SET @clienturl = FIELD(ROW(@clientdetails, 1), "urlName")
SET @loturl = CONCAT("http://www.bidspotter.co.uk/en-gb/auction-catalogues/",@clienturl,"/catalogue-id-", FIELD(@currentauction, "auctionReference"))
/*IF length(FIELD(ROW(LOOKUPORDEREDROWS("ent.LotDE", 0, "lotNumber asc", "auctionId", @currentauctionid),1), "firstLotImage")) > 0 THEN
SET @lotimage = CONCAT(FIELD(ROW(LOOKUPORDEREDROWS("ent.LotDE", 0, "lotNumber asc", "auctionId", @currentauctionid),1), "firstLotImage"),"540x360.jpg")
ELSE*/
SET @lotimage = FIELD(ROW(@clientdetails, 1), "LogoUrl")
/*ENDIF*/
SET @auctiontype = FIELD(@currentauction, "auctionType")
if length(@auctiontitle) > 80 then
set @charcount = length(@auctiontitle)
for @i = 81 to @charcount do
IF substring(@auctiontitle, @i, 1) == " " THEN
set @end = @i
set @auctiontitle = concat(substring(@auctiontitle,1,subtract(@end,1)), "Ö")
set @charcount = 0
endif
next @i
endif
]%%
|
|
|
|
%%= v(@auctiontitle) =%%
%%= v(@auctioneer) =%%
%%[if @auctiontype=="Live" then]%%Starts: %%= v(@auctiondate) =%% %%= v(@timezone) =%%
%%[elseif @auctiontype =="Timed" then]%%Ends from: %%= v(@auctiondate) =%% %%= v(@timezone) =%%
%%[else @auctiontype !="Timed" AND @auctiontype !="Live" then]%%
%%[endif]%% |
|
|
|
|
|
|
|
|
|
|
%%[
NEXT @rowcount
]%%
|
|
|
|
|
|
