I just wanted to know how to set an individual attachment name for mail merge macro.
Normally you can set the name to a fixed name:
oMailMerge.AttachmentName = “inv.pdf”
But when I want to get the name from a column from the database individually for each data set?
For just printing it there is a simple solution but not for send as mail or?
oMailMerge.FileNameFromColumn = true
oMailMerge.Filenameprefix = “Column”
Maybe I have to declare a string first and then make a sql statement to save the name for each data set in the string?
Maybe someone can help.
Many thanks for the quick help here in the forum