Mail the given name data to respective Mail IDs

[lokanathas]

Hi,

i want to create a macro to send multiple emails with attachment, i have a linked data "sample attached is a table" & created a query with necessary fields required with "SOH Sale" Query & have "Mail ID Master" table with Location name in one column & mail IDs in other column.

now mail should get trigger from outlook receptive location to respective mail ID which matches with "Location name".

Sample access file attached.

 

[lokanathas]

Pls help me the attached access file..

 

[Minty]

It's highly unlikely someone will write a complete routine to do this for you, we are after all unpaid volunteers, what have you tried, what have you got stuck on?

 

[arnelgp]

is this close to what you need.

 

[lokanathas]

Thank you very much for your update.
1)is it possible to send a excel data as attachment instead of pasting data on the mail body
2)after opening the new mail, can mail sent with the macro instead of send each mail.

i had shared you only sample, i need to send 100 mail data volume of more than 60K to 70K rows.

 

[arnelgp]

ive created the macro.
attached the sales in mail as excel file.
will not display but send the mail.