When visitors register for an event through our ET data extension we want to scan through the "All Subscribers" data to see if we already have information on them such as name, company name etc. I tried a LookupRows on All Subscribers where @regEmail matches "Email Address" but it generates an error code.
An unexpected error has occurred! Error Message: The Data Extension name for a LookupRows function call is invalid. A Data Extension of this name does not exist. Data Extension Name: All Subscribers Function Call: LookupRows("All Subscribers","Email Address",@regEmail) Parameter Name: DataExtensionName Parameter Ordinal: 1
How do we LookupRows in the All Subscribers list?
Based on suggestions below I tried: Some(strange)how it seems unable to locate the fields within that list? code:
%%[ SET @skey= "1003123951" SET @EArows = LookupRows("_Subscribers","Subscriber Key",@skey) IF ROWCOUNT(@EArows) == 1 THEN SET @EArow = Row(@EArows,1) SET @FName = Field(@EArow, "FirstName") SET @LName = Field(@EArow, "LastName") ENDIF ]%% Name: %%=v(@Fname)=%%, %%=v(@Lname)=%%
At first I had an error but think I found that, now it should work. Thank you all! Love and Peace etc, etc.