Klartigue
04-20-2012, 09:02 AM
Please see the attached document.
I need to send emails out to all the high bids, so that is for all the email addresses in column y (whose items numbers are highlighted in column D.
So for example, for item A12, I would like to compose a email to the contact in column Y, so that is mkissane@bloomberg.net.
In subject of the email, I would like to put YOUR ARE HIGH ON AN ITEM ON AVALON'S BID LIST.
Then in the context of the email, I would like to say..
"YOU ARE HIGH ON __ (get item A12 by referencing cell D12) at a price of (get the price by referencing cell J2) covered at __( get the cover by referencing cell J3).
THIS IS FOR __ settle (get settle by referecing cell I2) and coming from our __ account (get account by referencing cell H2).
BIDDER IS __ (get name by referencing cell O2).
Thanks,
Katherine"
I have never done an email where in the context you reference parts of an excel sheet so I am not sure how to go about this?
Any help would be awesome, thanks!
I need to send emails out to all the high bids, so that is for all the email addresses in column y (whose items numbers are highlighted in column D.
So for example, for item A12, I would like to compose a email to the contact in column Y, so that is mkissane@bloomberg.net.
In subject of the email, I would like to put YOUR ARE HIGH ON AN ITEM ON AVALON'S BID LIST.
Then in the context of the email, I would like to say..
"YOU ARE HIGH ON __ (get item A12 by referencing cell D12) at a price of (get the price by referencing cell J2) covered at __( get the cover by referencing cell J3).
THIS IS FOR __ settle (get settle by referecing cell I2) and coming from our __ account (get account by referencing cell H2).
BIDDER IS __ (get name by referencing cell O2).
Thanks,
Katherine"
I have never done an email where in the context you reference parts of an excel sheet so I am not sure how to go about this?
Any help would be awesome, thanks!