Hello,
I have main table, few tables connected to main by foreign key storing data from different processes. One of the tables stores attachments for products from main table (data sheets, specs etc).
I have no problem creating a query with needed data and creating a report which by using macro is sent in pdf. through Outlook
My question is what should I do to add attachments to the report in email generated...
jacekwbak
Last Activity: Feb 14 '13, 05:07 PM
Joined: Feb 8 '13
Location:
-
How Do I Add PDF as Attachment to Email
-
Wow. Problem Solved! Thanks -
Thanks for reply,
Code:select distinct * from table1
still will return all the records because of unique ID
If I only SELECT DISTINCT on ArticleCode then ok, but problem is that I need the ID.
What Now?Last edited by jacekwbak; Feb 8 '13, 02:24 PM.Leave a comment:
-
Access 2010 query duplicates
Hello,
I have following problem:
table1
id / ArticleCode / ArticleColor
1 / 123 / blue
2 / 123 / blue
3 / 222 / green
4 / 333 / red
5 / 444 / blue
Out of this data I need to pick unique values to return:
1 / 123 / blue
3 / 222 / green
4 / 333 / red
5 / 444 / blue
so basically, i need to keep all the fields, but...
No activity results to display
Leave a comment: