Closed Thread
Results 1 to 3 of 3

vba to email after modifying a single sheet from wkbk as a PDF attachment

  1. #1
    Forum Contributor
    Join Date
    04-30-2013
    Location
    McAllen TX
    MS-Off Ver
    Excel 2007
    Posts
    389

    vba to email after modifying a single sheet from wkbk as a PDF attachment

    I have a work book that the CSRs in my office use to come up with the correct dollar amt to charge a customer i am wanting to take this same wkbook and use it to send the request to the insurance broker via email ...

    The report that i want to send is most of the info on the "Endt Request to GA" tab. These request sometimes go to three different brokers (one for each Line of Business) ... the email addresses are in 3 different cells (according to the line of business), in the "Annual Premium Data" tab... NOTE: many clients have the same Broker (GA) for 2 or all 3 of the Lines of Business (LOB s )so will want the script to consolidate if this is the case....

    I would like the vba script to "clean up the report" i want to get rid of the the zeros and the extra lines created by them and to drop the "A17 & A33 cells ...

    Prefer to send as a pdf document... We do sometimes need to put other email addresses in the CC or Bcc fields. ...

    Can this be done? It does seem like quite of bit of coding and I dont have the slightest about VBA ... I am thinking this may need to go to the commercial... If we do that i have a bigger "wish list" ... having to do with USER Forms & screen scraping of a website ...any takers? Also let me take the time to note my appreciation for this forum, i have learned sooo much... thanks for all the help.

    Also let me take the time to plug the commercial side of this site. i have had one experience and the guy JACOB H. was GREAT! Did what he said he would and was very responsive to my many request for the database that he created to my specs.
    Last edited by dyoung785; 12-22-2016 at 12:09 PM.

  2. #2
    Forum Contributor
    Join Date
    04-30-2013
    Location
    McAllen TX
    MS-Off Ver
    Excel 2007
    Posts
    389

    Re: vba to email after modifying a single sheet from wkbk as a PDF attachment

    meant to attache the wkbook, here it is ...
    Attached Files Attached Files

  3. #3
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,293

    Re: vba to email after modifying a single sheet from wkbk as a PDF attachment

    Closed at request of dyoung785 to be reopened in Commercial Services.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Hyperlink to email with sheet attachment.
    By JRR007 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-26-2015, 04:48 PM
  2. VBA Script to Email Sheet and Other Attachment
    By jharvey87 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-24-2015, 03:54 PM
  3. [SOLVED] Send Email 1 sheet as attachment and other sheet as body of emial.
    By hecgroups in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-19-2013, 02:57 AM
  4. Modifying VB Code/Macro to put selection into body of email instead of attachment.
    By excelstacy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-04-2011, 05:34 PM
  5. Email single sheet as an attachment
    By JamesT1 in forum Excel General
    Replies: 8
    Last Post: 08-15-2011, 04:54 AM
  6. [SOLVED] send sheet to email as html attachment
    By Pieter in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-24-2005, 05:05 PM
  7. [SOLVED] Email a single sheet as attachment ??
    By Matt Stone in forum Excel General
    Replies: 1
    Last Post: 02-18-2005, 10:06 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