VBA Copy File to Clipboard

[chuckcoleman]

Hi, I'm sure this has been answered before but after a few hours of searching, I haven't found a solution. In Access I create an invoice and I then save it as a PDF so I have a record of it. That all works great. What I want to do is after the PDF is created, I want to copy the PDF FILE to the clipboard, NOT the text location with the filename. I receive email requests for a copy of the invoice. When replying to those emails, it would be much quicker create the PDF invoice in Access and then to simply do a Ctrl-V in the Outlook email which will paste the PDF file as an attachment to the email rather than clicking on "Attach File" and then navigating to where I saved the file. I want to use VBA and not an API.

Can someone point me in the right direction?

Thanks,

Chuck

 

[CJ_London]

see this link - easily found with the search 'attach a file to an email using access vba'. So think you need to brush up on your searching skills

Attach an external file to email using Access VBA

Hi I am trying to attach an external pdf file to email from a folder using the following code. The file name is Breakdown and it is a pdf file. I get an error message type mismatch where am I going

answers.microsoft.com

 

[pbaldy]

A brief search yielded:

copy file into clipboard

social.msdn.microsoft.com

 

[pbaldy]

Oops, apparently CJ searches faster than I do.

 

[chuckcoleman]

Sorry to be a pain. From what you've posted, they either use API's or they're doing things like creating an email with attachments.. I create emails every day using VBA with attachments. In my question I know the full path to the PDF file that I've created. I just want to copy to the clipboard the file, and not the full path text. That's all I want to do. Copy the actual file to the clipboard.

 

[theDBguy]

Sorry to be a pain. From what you've posted, they either use API's or they're doing things like creating an email with attachments.. I create emails every day using VBA with attachments. In my question I know the full path to the PDF file that I've created. I just want to copy to the clipboard the file, and not the full path text. That's all I want to do. Copy the actual file to the clipboard.

Hi. Are you saying you don't want to use API?

 

[CJ_London]

Sounds like Pauls solution is more appropriate - but still uses API's

 

[chuckcoleman]

Hi. Are you saying you don't want to use API?

Yes, I don't want to use API. I don't know anything about API's.

 

[CJ_London]

the clipboard is a windows object, so you have no choice

A. The Clipboard | Win32 API Programming with Visual Basic

Win32 API Programming with Visual Basic,1999, (isbn 1565926315, ean 1565926315), by Roman S., Petrusha R.

flylib.com