VBA to save as PDF and mail PDF to Specific recipient/s from Specific Account with Specific Signature

WERNER SLABBERT

Board Regular
Joined
Mar 3, 2009
Messages
100
Hey Eric.
i have downloaded your workbook, but i have been swamped at work the past week or so, as soon as i have a gap i will run through it to see.

thank you again for you patience and help in this project.


I have downloaded your project and I will look it over asap.
Please let me if the Excel workbook I created is working for your task. I would be happy to adapt it to better suit your needs.

Eric
 

Some videos you may like

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Eric H

New Member
Joined
May 22, 2017
Messages
11
No worries Werner,
Always happy to help out a fellow Excel & VBA enthusiast.
 

WERNER SLABBERT

Board Regular
Joined
Mar 3, 2009
Messages
100
Hi Eric

when you've had a chance to look at my original workbook, would you maybe guide me through the process of incorporating your code alongside my ( frankenHacked ) macro to make it all one button operation. eg: Print,Save & Email.

also i had a look and your code works a treat. just want to know would it be possible to automate some of the steps like "set" a specific Email to send from ( as this would always be my work mail and signature ). as well as auto choose/attach the "saved" PDF as saved by my code. just basically keep the user interaction to the bare minimum. you know like a one click solution ?
just a couple of thoughts i had, because in South Africa we kinda have to spoon feed everything for everyone... :confused:

reason for this is, i will not always be working with the workbook and i would like to simplify it for the ...uhm ... lets just say technologically challenged user within our company....



No worries Werner,
Always happy to help out a fellow Excel & VBA enthusiast.
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,106,348
Messages
5,510,774
Members
408,809
Latest member
Matthiasek

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top