1 email per email address, include cell value in email subject

[melody10]

hello experts,

would like to ask for your help to edit attached macro. Macro is designed to send 1 email for every unique address and include a table in the email message. but i need your help to revise macro such that

> 1 email will be sent per email address, even if they are the same. so if [email protected] is mentioned 3 times, he will receive 3 separate emails.

> also if its possible to include the "shipment number" for each email (data located in column a

really appreciate any help you could give me.

thanks in advance.

[melody10]

any takers please?

[Logit]

.
What do you mean by this statement : and include a table in the email message

[jmac1947]

Hi melody10,

The data in your attached spreadsheet looks very familiar?

have you posted this question / spreadsheet in another thread recently??

[melody10]

Hi melody10,

The data in your attached spreadsheet looks very familiar?

have you posted this question / spreadsheet in another thread recently??

Not really. Been a long time since i last posted anytging here in the forum

[coreytroy]

Please Login or Register  to view this content.

[jmac1947]

Hi melody10,

Sorry, my bad , must be getting old - seems I did look at this post last week and simply forgot, no wonder the data in the spreadsheet looked familiar.

Will have a play and see what I can find although at first glance it does look like the code has been borrowed from somewhere else. What happens when you step through the code??