Attaching PDF to Lotus Notes email. PDF name is variable.

[joee74]

Hi , as I have mentioned on previous posts, I am very new to all this and need some help if you can possibly spare 5 or 10 minutes.

I have written a macro that when I am pricing for a client, I click one button on the page and the following happens.

1. It saves the internal prices from the sheet called "internal" as a PDF, naming that PDF according to the data in cell "BD2".
2. It saves a PDF of the client prices from a sheet called "Client Quote" as a PDF, naming that PDF according to the data in cell "AY8"
3. It opens up a new mail in Notes, inserting TO: email and CC:emails. It then inserts a subject title, also taken from cell "AY8" and body text and signature from various cells within the workbook.

I have all of this bit working now.

I now need it to attach the client price PDF to the email also, but for the life of me I cant work out how to do that. I have tried recording macros and copying that code into this macro but I am completely lost.

Any help you can give me would be very much appreciated.

Please Login or Register  to view this content.

[joee74]

Anyone have any ideas on this?

[JOHN H. DAVIS]

Maybe?

Please Login or Register  to view this content.

[joee74]

Hi John

thanks for this, I have run this macro and its getting hung up on the create PDF element I had place in for creating the client price PDF.

The following error message is being displayed.

Run-Time error '1004:

Document not saved, the document may be open, or error may have been encountered when saving.

Its creating the email but still not attaching the PDF.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[joee74]

Hi John, still getting it hanging up as previously, with same error

[JOHN H. DAVIS]

Can you send me a sample workbook with the sheetnames as mentioned above?

[joee74]

Hi John

I have found the issue, its to do with the naming of the file. although the file is being named as I require as a variable name. excel is not picking up the variable part of the name when searching for the file to attach, its only seeing the fixed field " Quotation No."

I have changed this code to run a test with a fixed file name being created and looked for and it works fine and does everything I want it to.

However I do need the filename to be a variable, so Im a little lost as to what to do here now.

Code I have working is as follows:

Please Login or Register  to view this content.

[joee74]

I should have that the cell the data is being picked up from has the following formula to create that name:

="Quotation No."&H8&" - "&F4&" - "&H7&" - "&G16

Although in windows explorer the full file name is showing as I want it to, when I drop the file into our MIS system in work, its only picking up the "Quotation No." aspect of the name.

I hope I am making sense to you here. as I said, when running it as a fixed name, it works, but I need the naming of the file to be variable.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[joee74]

John My friend, you are a genius. all working now. I just did an Irish jig in the office.

thanks for your patience.

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback. Please comply with Forum Rule No. 9.


9. Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.