1 2 3 4 5 6 7 8 9 10 11 12 13 14
| Else
MsgBox "mutli"
If TabTempo![e-mail Consolidation] <> Empty Then
Dim TabTempoConsolidation As DAO.Recordset, TabID As DAO.Recordset, listLegalEntities As Variant
'MsgBox
Set TabTempoConsolidation = Mba.OpenRecordset("SELECT DISTINCT [Consolidation Req].[legal entity] FROM [Consolidation Req] WHERE [Consolidation Req].[Product name Consolidation]= '" & TabTempo![Product name] & "' And [Consolidation Req].[e-mail Consolidation]= '" & TabTempo![e-mail] & "' AND [Consolidation Req].[Email Status]= False ") 'GROUP BY [Consolidation Req].[legal entity]
Set TabID = Mba.OpenRecordset("SELECT [Reach Contacts].Name, [Reach Contacts].Address, [Reach Contacts].City, [Reach Contacts].Email From [Reach Contacts], '" & TabTempoConsolidation & "'WHERE [Reach Contacts].[Name]=[TabTempoConsolidation].[legal entity]")
listLegalEntities = TabID.GetRows ' put all the iformation in a table
End If |
Partager