Hi guys,
i have query in Access like in attachment.
Bez*tytu?u.png
E-mail is the same for company number & Area.
So for company1 and area Wrocław there will be [email protected]
But for company2 and area Bydgoszcz there will be [email protected].
Now i want to send for key company-area e-mail.
within first e-mail should be:
second e-mail:50002 company1 Wrocław Document1
50002 company1 Wrocław Document2
50002 company1 Wrocław Document3
How can i do this?50002 company1 Bydgoszcz Document2
50002 company1 Bydgoszcz Document1
I can send e-mails (i have code) but i need to find suitable VBA object in order to do this.
I am thinking about dictionary.
Key would be company-wrocław and item document1 but how to add more then 1 item into dictionary?
All help will be welcome,
Best Wishes,
Jacek Antek
Bookmarks