Mail the given name data to respective Mail IDs (1 Viewer)

lokanathas · Nov 27, 2017

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 · Nov 28, 2017

Pls help me the attached access file..

Minty · Nov 28, 2017

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 · Nov 28, 2017

is this close to what you need.

lokanathas · Nov 30, 2017

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 · Nov 30, 2017

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

Mail the given name data to respective Mail IDs (1 Viewer)

lokanathas

Registered User.

Attachments

lokanathas

Registered User.

Minty

AWF VIP

arnelgp

..forever waiting... waiting for jellybean!

Attachments

lokanathas

Registered User.

arnelgp

..forever waiting... waiting for jellybean!

Attachments

Similar threads

Users who are viewing this thread