Skip to main content
Topics#Salesforce DeveloperRobert Wynter's Question
Robert Wynter (Durham College Applied Arts & Technology) asked in #Salesforce Developer
Nov 27, 2018, 4:51 PM

Ampscript attachment using data extension to determine which PDF file to attach

Trying to switch out the static attachment in an email to dynamic based on a Data Extension(DE).

The Static:

%%[

%%=AttachFile("FTP","AIDI.pdf")=%%

]%%

And what I'm tried to replace it with:

%%[ var @Program,@ColumnProgramCode  set @ColumnProgramCode = Lookup("Program_Interest_G", "ProgramCode", "ProgramOfInterest", @Program)]%%

%%[

%%=AttachFile('FTP',%%@ColumnProgramCode%% +'.pdf')=%%

]%%

The DE is Program_Interest_G

the filed name is ProgramCode
3 answers
  1. Nagendra Babu Pilli (Salesforce)
    Nov 29, 2018, 7:01 AM
    Hi Robert,

    Please try this.

    %%[ var @Program,@ColumnProgramCode , @file set @Program =v([Lead:Global_Program_of_Interest_2__c]) set @ColumnProgramCode = Lookup("Program_Interest_G", "ProgramCode", "ProgramOfInterest", @Program) SET @file = Concat(@ColumnProgramCode, '.pdf') ]%%
    %%[IF NOT EMPTY(@file) THEN]%%
    %%=AttachFile('FTP',@file)=%% 
    %%[ENDIF]%%

    Kindly mark this as solved if it's resolved.

    Thanks,

    Nagendra

     
Write an answer...
0/9000