Thank you for the replies. ".Display" was exactly what I wanted. I already had everything in place, but I needed outlook to give me the chance to edit the .oft, and I simply couldn't come up with the command.
It worked beautifully - thank you!
Dave
Dave DeSteno
Last Activity: Oct 11 '11, 05:18 PM
Joined: Oct 12 '10
Location: Lebanon, PA
-
Alternative to .Send
I have the following code in the OnClick() event of a command button on a form. Right now, it takes the "; " separated values from a TextBox and puts them in the "To:" field of a .oft Outlook Template. It then sends that template out to the appropriate recipients. (exactly what I wanted it to do...)
Problem: My boss is asking for the email template to come up (with the "To:" field populated) but be available...Last edited by Niheel; Jun 3 '11, 06:07 PM. -
Dave DeSteno replied to Taking all values from a column and putting them together with a "; " separatorin AccessThis works beautifully! I owe you a pint!
Thank you. Thank you. Thank you!Leave a comment:
-
Dave DeSteno replied to Taking all values from a column and putting them together with a "; " separatorin AccessOkay - I was off on my Query/Form names slightly...
They are: ResponsibleCoun tQuery1 and ResponsibleCoun tQuery2 (I know - this was BEFORE I read about normalization)
The field name is still [ResponsibleEmai l]
1. Form name to display data: ResponsibleCoun tForm1
2. Here's the SQL for the recordset:
SELECT ResponsibleCoun tQuery2.Respons ible, ResponsibleCoun tQuery2.CountOf Responsible, ResponsibleCoun tQuery2.Respons ibleEmail,...Leave a comment:
-
Dave DeSteno replied to Taking all values from a column and putting them together with a "; " separatorin AccessI thank you all for the replies.
Sadly, I still cannot seem to make this work.
I'll keep plugging along - it's gotta break eventually for me, right?
I really would need it spelled out for me, I suppose - I wasn't sure what to do with the code above from hype261. Sorry to be dense! If someone has the time to hold me hand through this, fantastic - if you don't, that's fine as well.
The query name...Leave a comment:
-
Dave DeSteno started a topic Taking all values from a column and putting them together with a "; " separatorin AccessTaking all values from a column and putting them together with a "; " separator
It seemed simple at the time...
Ask for their email addresses, then when I have a list of people to contact, I can make my Access database spit the addresses out for me...
Here's my quandry:
I have a table (related to other tables in my database)that simply lists [Name][EmailAddress] and [ContactNumber]. I use a few queries to sort everything out and end up with usually about 5-10 people listed that need an email... -
How to search for a value, and move my cursor to the adjacent cell in MS Excel
It's quite simple what I need to do, but for some reason the process is escaping me! IF I could use Access, I would be relaxing with a cup of coffee by now...
I use a barcode scanner to log our fire extinguisher checks at this facility (we have hundreds of them to be checked monthly). I want to place a "Location" number and an "Extinguish er" number barcode. The goal is to be able to walk up, do the visual inspection,...
No activity results to display
Leave a comment: