Copying all listbox values (multiple records) to clipboard

[daze]

Copying all listbox values (multiple records) to clipboard - RESOLVED -

Can you actually copy all of listbox values of one column in to clipboard so they can be pasted in to other program (Outlook to be exact)?

I have some emails that need to be passed to Outlook daily from listbox of access 2007.

It would be great if the can be divided with ";" sign...


THNX

 

[vbaInet]

You can. You would need to:

1. Highlight the row
2. Loop through each field using Listbox1.Column(X) and concatenate its values into a string variable
3. Set a hidden textbox's value to that string
4. Use Sendkeys to perform Ctr + C (to copy)

By the way, you can send e-mails from Access (via Outlook) using SendObject(). Look into that.

 

[daze]

Thnx

Btw, I found solution.

And yes I have been using sendobject() up until they messed our Outlooks on network with SMART system (for creating and sending cables).

Long story...
Whenever I click on SEND button to send email to anyone it opens another window (from SMART system) asking to select if message is personal, sensitive, none sensitive...

So now when I have 25 or more emails I'm forced to select each email separately...

Pain in but.

 

[vbaInet]

I think there's a setting in Outlook to turn off the warnings. Or you can look into third party softwares or search for changing registry keys regarding this message.

There's also Outlook Automation instead of SendObject but it's alot more involving.

 

[daze]

Unfortunately, I'm not allowed to change or modify Outlook or any other software, and especially to install third party software...

THNX

 

[DCrake]

Here is a demo from my website that does what you ar asking for.

 

[vbaInet]

David I had no idea you had sample databases on your site! I shall be directing people there when necessary.

 

[DCrake]

Most of the demos are germinated from questions posed on this forum, however some are homegrown.

 

[vbaInet]

Most of the demos are germinated from questions posed on this forum,...

Is Soundex one of them?

 

[DCrake]

The soundex search is one I picked up a few years ago from elsewhere but felt it was worthy an inclusion in the list. I left all the acknowledgements insite so as not to claim authorship of the code.

 

[vbaInet]

Goodie! Lots of good examples on your site though.

 

[DCrake]

Surprised you have not visited before today.

 

[vbaInet]

I had visited but your site is quite customer-centric so I keep forgetting that you have Sample Databases too. And yes I saw the humour too, nice office

 

[JANR]

I had visited but your site is quite customer-centric so I keep forgetting that you have Sample Databases too. And yes I saw the humour too, nice office

Funny

Loved the IT Support gag, FYI It's not German actors but Norwegian actors by the name of Oistein Bache and Rune Gokstad, still funny.

JR

 

[DCrake]

JANR

My knowledge of the foreign languages is limited to English and Bad. If you say it's Norwegian then I believe you so I will update my website. Having said that I think it is very funny.

If anyone has any other funny vids or stories would love to hear them.

did have to tke one off the other day as it offended someone and I bowed to their opinion.