i have a piece of code which develops an email in outlook, it worls great. BUT i need the attachment to be in the body of the email.
Any Suggestions (code below).
Private Sub cmdSend_Click()
Dim strEmail, HTML As String
Dim objOutlook As Object
Dim objEmail As Object
Set objOutlook =...
Hi
I am a bit new to all this, so bare with me.
I have this piece of VBA which sends and email in HTML format. What i want to is if ITSQFList has text then add the statement "with the following points to note" after ITSQFQualityGate. If it is empty then there is no statement.
Any suggestions...
I have a browse button which uses the following code:
Private Sub Label44_Click()
Dim strFilter As String
Dim lngFlags As Long
strFilter = ahtAddFilterItem(strFilter, "Word Files (*.doc)", "*.DOC")
strFilter = ahtAddFilterItem(strFilter, "Excel Files (*.xls)", "*.XLS")...
I have a browse button which uses the following code:
Private Sub Label44_Click()
Dim strFilter As String
Dim lngFlags As Long
strFilter = ahtAddFilterItem(strFilter, "Word Files (*.doc)", "*.DOC")
strFilter = ahtAddFilterItem(strFilter, "Excel Files (*.xls)", "*.XLS")...
I have a form automatically send an email (which it does very well), though i always get the Outlook warning message:
"A program is automatically trying to send an email on your behalf.
Do you want to allow this?"
Is there anyway i can bypass it?
Hi
I have some VBA which generates an email, i need it to be in a particular fond and certain words made bold. What do i need to do to acheive this (code given below)
Private Sub Command18_Click()
Dim strEmail, strBody As String
Dim objOutlook As Object
Dim objEmail As Object
Set objOutlook...
Hi I have some code which i am trying to get to work. i is used to transfer data from a query to a word template. Any suggestions (i am not very good at VBA as you can probabily tell by my code):
Private Sub cmdPrintReport_Click()
Dim appWord As Word.Application
Dim doc As Word.Document
Dim...
Hi
I have a query (qryITSQFSubmission) which contiains inforamtion used to write a weekly meeting agenda. Each record must be individually must submitted by email as the body text and then removed from the query e.g. setting a status field to "submitted". The submission must be in a particular...
Hi
How can i send an email that has the information from a particular record in the following format:
«ITSQFDocumentName» received from «ProjectServiceDesigner»: ‘«ProjectName»’ - PAR «ProjectPAR»
Go Live - «ProjectLiveDate»
«ProjectSummary»
«ITSQFServRecommendation»«ITSQFQualityGate»...
Hi
I have a word document which Mail Merges with an Access Database, I am using it for submitting items for a meeting's agenda.
Is it possible to clear the document automatically once it has been merged? So that the same item isn't submitted twice.
Any Ideas
James
Hi
This is rather complicated to explain, but here goes:
I have a form with 3 combo boxes on it:
- ITSQFDocumentName
- cboServRec
- QualityGate
What i want is in a simple sence
If ITSQFDocumentName = ORQ only allow selection from QualityGate else allow selection from cboServRec.
Can...
Hi
I am currently trying to write a query which will display only the latest record for a project e.g.
Project 1 - 01/02/05 <--- Will filter out this record
Project 1 - 02/02/05 <--- Will only display this record
Here is the SQL so far:
SELECT qryProjectDetails.ProjectBusinessArea...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.