1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

send email from excel to multiple recipients

Discussion in 'Business Applications' started by hariexcel, Nov 16, 2012.

Thread Status:
Not open for further replies.
Advertisement
  1. hariexcel

    hariexcel Thread Starter

    Joined:
    Nov 16, 2012
    Messages:
    5
    Dear All,

    I would like to seek your advice to find out a solution for the below query:
    Daily I would be having plenty of documents on hold which I need to intimate to respective people for the reasons on the same : so…..
    Every time I need to send an e-mail for these, so I wanted to create macros for sending an e-mail for the excel on their respective documents like:
    Dear Sir/Madam,
    You’re so and so document and code no is on hold due to the “reason”, please provide us the clarification to process further
    Data is like below

    A B C D
    Doument # Code Reason fo hold E-mail id
    12 1 Due to Mismatch [email protected]

    13 2 Wrong doc [email protected]

    15 3 amount mismatch [email protected]

    17 4 Wrong Details attached [email protected]

    19 5 Wrong person details [email protected]

    21 68 Due to Mismatch [email protected]

    23 455 ddsss5 [email protected]


    Please provide us Macro code for the same ,
    Thanks in advance
    Your’s friends
     
  2. dvk01

    dvk01 Moderator Malware Specialist

    Joined:
    Dec 14, 2002
    Messages:
    56,219
    First Name:
    Derek
    I have deleted all your multiple duplicates about this
    it is not acceptable to post so many posts about the same subject all within a few minutes of each other
    stay in this topic ONLY until it is sorted out for you
     
  3. hariexcel

    hariexcel Thread Starter

    Joined:
    Nov 16, 2012
    Messages:
    5
    Dear All,

    I am still waiting for your inforamtion as i need to complete this report task ASP, Looking for an earliest and postitive response.

    Regards,
    Hari
     
  4. hariexcel

    hariexcel Thread Starter

    Joined:
    Nov 16, 2012
    Messages:
    5
    Dear Team,

    Here i am but still i am getting error messge
    please see the below code :

    Sub Notify()
    Dim WS As Worksheet, Rng As Range, c As Range, D As Range, F As Range, p As Range
    Dim OutApp As Object, OutMail As Object
    Dim Msg As String, Addr As String, i As Long
    Dim NotificationNecessary As Boolean

    Set OutApp = CreateObject("Outlook.Application")
    Set WS = ThisWorkbook.Sheets("Sheet1")
    For Each c In Rng
    For Each D In Rng
    For Each F In Rng
    For Each p In Rng
    NotificationNecessary = False
    Msg = "Dear Sir/Madam" & Chr(13) & Chr(13)
    Msg = Msg & "Kindly provide the following clarification/ input required that we came across while processing your claim. "
    Msg = Msg & "We would need your inputs to proceed further on processing of this claim" & "Vendor Claim Details:" & "Document No./ Ref No & C.Offset(, 2) & "
    Msg = Msg & "having Invoice No" & D.Offset(2, 4)
    Msg = Msg & "of Vendor Name " & F.Offset(2, 6)
    Msg = Msg & "Reason for Holding " & F.Offset(2, 16)

    For i = 4 To 13
    If WS.Cells(Z.Row, i) = "X" Then
    Msg = Msg & " -" & WS.Cells(1, i) & Chr(13)
    NotificationNecessary = True
    End If
    Next
    If NotificationNecessary Then
    Msg = Msg & Chr(13) & "If the Hold document not resolved within 15 days from hold date the claim will be REJECTED." & Chr(13)
    Msg = Msg & Chr(13) & "Thank you,"
    Msg = Msg & Chr(13) & "Team"

    Set OutMail = OutApp.CreateItem(0)
    On Error Resume Next
    With OutMail
    .To = Q.Offset(, 1)
    .CC = ""
    .BCC = ""
    .Subject = " Your Bills on HOLD"
    .Body = Msg
    .Send
    End With
    Set OutMail = Nothing
    End If
    Next
    End Sub

    I would like to have a message in the below format :




    Dear Sir/Madam,
    Kindly provide the following clarification/ input required that we came acrosswhile processing your claim.
    We would need your inputs to proceed further on processing of this claim.

    Vendor Claim Details: Document No./ Ref No. XXXX [ having Invoice No -NO/LEGALCH/884 ] of Vendor code "XXX " of Vendor Name : "Vendor name

    Reason for Holding : Kindly attach the finance head approval for releasing thepayment.

    When you are sending any additional document, please attach a print out of thismail and then drop it in
    Wividus Box.

    We are awaiting your reply to proceed further.

    *************************************************************************************
    If the Hold document not resolved within 15 days from hold date the claim willbe REJECTED

    *************************************************************************************
    For further clarification please feel free to conduct us.

    Regards,
    Team
     

    Attached Files:

  5. Garf13LD

    Garf13LD

    Joined:
    Apr 17, 2012
    Messages:
    455
    For each opens 4 layers but only close one layer.

    What is Rng referring to?
    Then what about c, D, F, p and undeclared Q, Z
     
  6. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1077027

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice