Recent content by Anonymous1986

Think i actually had to do that last time. Thanks

Even stripped down it's 4.59mb which exceeds the allowance i can upload and then when zipped it's just over at 2.59mb!!

I've tried to do so before and it was a struggle so it's not something i can do very quickly. Also my tables are linked ...

I've rewritten code as below but think i still need to tweak Private Sub Command146_Click() 'email script Public Sub CreateEmailWithOutlook() Forms!SubcontractorListBulkEmail.Requery sTo = Forms!SubcontractorListBulkEmail!Text165.Value ' Create a new email object Set...

I'm sorry I need this in the simplest terms! Attached is now my vba. Please can you advise where I need to amend? thank you.

Thanks for quick response! What would i substitute "your list of recipients for"? This could change at different times. Otherwise is there a way to do so from a query as i have got that far?

Hello all Can anyone help with vba so that selected emails add to bcc in new Outlook email? Found a few helpful threads but think i need it really broken down from the start for me. I want to select checkbox on form and then on click of command button open email with selected recipients in...

I think it's working now, thanks!

I don't seem to be able to start a new thread. Anyone know why that might be?

Attached picture of working form. Contact 1 is default estimating contact and dropdown shows both contacts (1&2) for company 1 which is all correct information. Company 2 shows the correct estimating contact but the dropdown shows the same contact 1 and 2 from company 1. This is the case...

Going back to my IDs / Pimary keys, company name is a constant across my database and certain fields such as projects, trades and estimates already have their own unique numbers which was the thinking behind my relationships. Would you still recommend using Auto IDs?

Thank you i can see that now!

I've tried a different approach - does it make a difference where tables have been linked and repasted? The form isn't generating with the data but the structure is there, hopefully this is enough for you to get an idea? I definitely have many issues! A complete beginner, it's been a trial and...

Yes even with minimal data in the tables. The tables are the bulk of it but if I don’t keep them my form doesn’t work because of the way we set up the database.

I'm still at 2.6mb! Literally don't think I can strip it down any further than I have ...