+ Reply to Thread
Results 1 to 2 of 2

using VBA to extract from list to PDF and then email

  1. #1
    Registered User
    Join Date
    05-23-2019
    Location
    Bristol, England
    MS-Off Ver
    2010
    Posts
    1

    Post using VBA to extract from list to PDF and then email

    Hi Guys & Ladies,
    VBA HELP. I have limited VBA skills and have a problem I'm trying to sort I'm hoping I could get some help with. I'm wanting to do the following: -
    1.) I want to extract data (car registrations) from lists in column A.
    2.) Make a new worksheet for each of the registrations on the list (about 100 a day).
    3.) Save each individual sheet as a PDF with the registration number and todays date (saved to a folder on my desktop).
    4.) email all of todays to a fixed email address.

    this is beyond my knowledge. I can make some macros and amend some VBA as I have a basic understanding but not to be able to do the above I've been asked to look into, any help would be massively appreciated.

    Neal - Bristol
    Last edited by nealp; 05-23-2019 at 07:21 AM. Reason: updated title

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Extract Data - Create and send PDF - VBA

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however the thread title did not really convey what your request is about.

    Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

    Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

    I changed it for you this time as you are new on the forum

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. 1 email per email address, include cell value in email subject
    By melody10 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-31-2019, 10:27 PM
  2. [SOLVED] vba email send from excel - ignore second email address if "ENTER EMAIL ADDRESS"
    By nigelog in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-28-2016, 07:22 AM
  3. Email same email addresses' data onto one email
    By lapot in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 01-13-2016, 01:31 PM
  4. Email a screenshot of a specifc row in an email to a specfic email address
    By Cobra75007 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-19-2015, 10:36 AM
  5. Replies: 1
    Last Post: 09-09-2013, 03:46 PM
  6. Send New Email W/ Body of Received Email, Then Delete Sent Email
    By edneal2 in forum Outlook Formatting & Functions
    Replies: 2
    Last Post: 07-01-2013, 12:45 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1