• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

sending emails via excel

D

Dalia

Member
I read the reference for sewnding emails to the email ID which is in A1 but my situation is a bit different. Here in the excel file attached below I want to send the email to the person who are at the column Q. The criteria is the data should be sent via outlook and the header should be sent along with the data. in the excel file attached I have highlighted the cells to show how the data should be sent .But the data with today's date should only be sent. for eg: if the date today is 25-mar only the data of that particular date should be sent.

Below excel sheet shows the highlighted cells. now another point is if we are sending to the same person(here in this eg. a@yahoo.com) for different POs the excel should club the data together and send it. And if the data is sent once for that particular date then if we add more data later on that date it should only sent the data which are not sent.

How can i do it with the macros
 

Attachments

Hi Dalia,

Meanwhile the experts help you, could you please go through below links. These might be helpful.

If I could suggest you one thing, please try to explain your problem in more detailed manner

Please correct me if I am wrong.

1) You have Email Ids (reciever) in Column Q

2) What is your data ? the entire row for the email id ?
For example, if we take "y@yahoo.com", the data will be range ("a4: P4").

3) You want to club the data for "a@yahoo.com". Which will be 3 rows.

4) What is header ? not able to get that.


P.S. - I am not an expert, just stopped by to learn from your post. :)

http://forum.chandoo.org/threads/send-automated-email-due-date.13590/#post-80663

http://forum.chandoo.org/threads/sp...s-and-mailing-as-attachment.12991/#post-76450

http://forum.chandoo.org/threads/se...ecipents-based-upon-tick-box-selection.11516/
 
Hi,

Thanks for the links but I am not able to see the uploaded file for the first link which is making me a bit difficult to get that.

I will answer the questions
1)yes you are correct I have emails in column Q
2)No the data to be sent to y@yahoo.com is range A4: P7
3)No, if the same email is found repeated times in a particular date I will club all the data for eg : a@yahoo.com has 5 rows in total for a particular date the range is A9: P11 and A20: P21. But if it is sent once before we enter the later data it should not be send again as it will result in repeatation.

6) the header is A1: S1
 
Last edited:
How do you tell Q10 is to be sent to a@yahoo.com? Would that be a chance to get mail addresses in ALL cells? (i'd solve with filters, but it is not going to work with blanks). Same issue in column S, having a date in all cells is definitelly going to help.
 
Echoing what iferror said, your workbook has missing data. Tables should not have empty cells in them. Need to:
  1. Have email listed for every line
  2. Define exactly what cells/range needs to go in body of email
  3. Define what the subject, if any, of email should be
  4. Tell us which column of dates we need to look at
  5. Can we send the info as an attachment, or embedded in email?
 
Hi @Luke M and @iferror,
Thanks for your reply:)

I will answer the questions

1) Yes we can have email listed for every line but the data should not be sent separately
2)The emails should go in the way the cells are highlighted.
if the data is sent once for that particular date then if we add more data later on that date it should only sent the data which are not sent.
To make the idea more clear about how the data should be sent please find the attachment below
3)the subject line should be " please take action" and then the body will be " Hi, Please find below" and then the table
4)the date should be in column S
5) no, we cannot send it via attachment or embeded in email
 

Attachments

Hi, Dalia!

Despite of the useful highlighting that helps understanding the final requirement, what's missing is the explanation of the criteria used for:
a) Selecting which rows would be included in the mail generation (i.e., coloring)
b) Grouping selected rows (i.e., coloring for each mail)

Regards!
 
Hi,
Here is the answer
a) the whole coloured Rows which are for particular email address will be included but as I mentioned previously for a particular date
b) I don't need color email . Its just to give you an idea
 
Hi, Dalia!
So...
c) Should all rows be considered?, I assume that yes.
d) Grouping criteria should be email address of column Q?, if so I assume that all cells in column Q will have a valid address.
e) Any particular order for the outgoing emails?, I assume that no.
Could you please confirm or correct?
Regards!
 
Hi
Yes
d) yes the grouping should be as per column Q. And the same email address can be copied for a particular PO lines
e) no but the rows should be arranged in the same way while sending as i had given in the sample file
 
Last edited:
Hi, Dalia!
Then:
d) Rows are grouped by column Q email address, yet filled at every row.
e) Within each group rows sorting and order is by column B date?
Regards!
 
Hi @SirJB7
hello after a long time. hope you are doing great.

the answers are below

d)yes rows are grouped by column Q email address but as i said the rows should be sent together . just want to clarify that the number of rows that will be send for a particular date to a particular person will vary day to day and if a macro is already run for a row it should not run again if the email address is matching.

e) no the row sorting and order will be by column Q.

please help.

thanks in advance!!!:)
 
Hi, Dalia!

Sorry for the late answer but been traveling the last couple of weeks. Let me shake the sand from my feet, get my hands on these things called keyboards and I'll get back to you soon.

Regards!

PS: Hope you're doing great too ;)
 
You must log in or register to reply here.
Back
Top