+ Reply to Thread
Results 1 to 6 of 6

Automated mailing of data from a spreadsheet

  1. #1
    Registered User
    Join Date
    03-22-2021
    Location
    Cambridge
    MS-Off Ver
    Office 365 apps
    Posts
    3

    Question Automated mailing of data from a spreadsheet

    The starting point is a report in Excel that groups data by customer in rows as attached (I can't change this), each report (monthly) has a different number of transactions per customer and therefore number of rows and what I hope to do is email the data per customer to that customer.

    The format of the report is as attached with each discrete data set defined by a cell in Column A which has an account code, a comma and then the company name. The immediately following rows have the transactional details which I need to email, the email address for each account would be held in a separate sheet as attached.

    I am seeking to build a macro driven sheet that this data would be pasted into with simple controls that send each customer's subset of data to the appropriate address but am unsure of the best methodology to do this. The nuisance is that there are about 60-70 customers so am seeking the lowest manual input and computational load for the finished sheet.

    Any thoughts as to how to design a sheet to accomplish this would be much appreciated, I have some Excel macro experience but not as much as I need to complete this. The account code and company name does not change and I don't mind sending a mail with no data if a company has no transactions for the month.

    TIA for any help!
    Attached Files Attached Files
    Last edited by DozyBurgher; 03-22-2021 at 12:05 PM.

  2. #2
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    1,778

    Re: Automated mailing of data from a spreadsheet

    Give this code a try;

    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    03-22-2021
    Location
    Cambridge
    MS-Off Ver
    Office 365 apps
    Posts
    3

    Re: Automated mailing of data from a spreadsheet

    Hi maniacb and many thanks for the code, I am, however, struggling with the ema line:

    ema = WorksheetFunction.VLookup(ad.Cells(Ra.Row, 1), ea.Range("A1:B" & lea), 2, 0)

    I get a RunTime error '1004' - Unable to get the VLookUp property of the WorksheetFunction class

    Being a very inexperienced user, it is well beyond my ability to understand the expression and how to get it to work. Please would you have a quick look and if you can point me in the right direction I would much appreciate it. Thank you for your extraordinary generosity!

  4. #4
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    1,778

    Re: Automated mailing of data from a spreadsheet

    I received this error too when one of the emails was missing in the list, or the name of the entity was misspelled. I corrected those things in the file I uploaded.

  5. #5
    Registered User
    Join Date
    03-22-2021
    Location
    Cambridge
    MS-Off Ver
    Office 365 apps
    Posts
    3

    Re: Automated mailing of data from a spreadsheet

    Ah, yes, many thanks again, an excellent solution to my problem, it is very much appreciated!

  6. #6
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    1,778

    Re: Automated mailing of data from a spreadsheet

    If that takes care of your original question, please select*Thread Tools*from the menu link above and mark this thread as SOLVED.

    Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon (Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

+ 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. [SOLVED] Looking for Automated Invoicing & e-mailing solution
    By dmcgrathfaischools in forum Excel General
    Replies: 8
    Last Post: 03-22-2021, 11:05 AM
  2. Automated (programmed) saving multiple data row from Excel spreadsheet as images...
    By AlexRogan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-08-2020, 05:17 AM
  3. Controlled viewing and Automated addition and hiding of data in spreadsheet
    By msgm in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-03-2016, 02:48 PM
  4. [SOLVED] Mailing Labels to Spreadsheet.
    By J. Michael in forum Excel General
    Replies: 2
    Last Post: 04-26-2006, 09:40 AM
  5. [SOLVED] Customer profiles with automated follow up mailing or call bks
    By parteemiz in forum Excel General
    Replies: 1
    Last Post: 11-19-2005, 08:20 PM
  6. Replies: 1
    Last Post: 03-15-2005, 08:06 PM
  7. [SOLVED] how do I print data in a spreadsheet data base to a mailing lable.
    By Database in forum Excel General
    Replies: 0
    Last Post: 03-15-2005, 08:06 PM

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