Results 1 to 2 of 2

Thread: Automatic attachment and email to be sent
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Apr 2019
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Thumbs up Automatic attachment and email to be sent

    Dear Expert,
    I need an help from you. I need a VBA code from you for the below scenario.
    Currently I am doing it manually and i want to automate it.

    Current Scenario: I am from invoicing Team and i Generate multiple invoices for the day. I store all these Invoices in PDF mode and save it under my local drive folder or in a desktop folder. Like wise I generate invoice, save pdf invoice copies under local drive for all invoices. Assuming I generate and save 100 pdf copies and currently I send all these 100 pdf invoice copies to 100 recipients/mail address with new 100 emails individually/separately. It is time consuming for me to send all these 100 emails one by one to each different mail address.

    Automation Required: I want to avoid this manual work and to atomize the same. My idea is I want to run a macro which will send all pdf copies to required email address using outlook.

    For this Once invoice copies printed and saved in local drive, I will maintain a excel database with invoice number, email address id, Signature as "Invoicing Team" columns with details entered in to it. Using this excel details, macro should run for each invoice numbers like open a black outlook email, entered the subject which is same off attachment of that particular pdf invoice copy, body of the email should be "invoice copy" and signature should be a default one as "invoicing Team".

    Please help me with a VBA code for applying above scenarios.
    Your help is much appreciated.


    Thanks
    Jay

  2. #2
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    6,276
    Post Thanks / Like
    Mentioned
    72 Post(s)
    Tagged
    14 Thread(s)

    Default Re: Automatic attachment and email to be sent

    Hi Jay:
    Then you will have an Excel sheet with this information:

    Sheet1
     AB
    1invoice numberemail address
    2123damor@gmail.com
    3124email@yahoo.com
    4125jay@hotmail.com


    -------------
    If in cell A2 you have the number 123, what is the pdf file called? maybe 123.pdf
    For this to work automatically, you must specify what data you have on the sheet and how it is in the folder.
    Also if you can specify the name of the folder.


    Another important information is the body of the mail, is it always the same text?
    Regards Dante Amor

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •