What code to use to move the custom field values to message body when sending e-mail ?

Status
Not open for further replies.
Outlook version
Outlook 2013 32 bit
Email Account
Exchange Server
I quite new to vba and i appreciate if you could help me whit a code that moves the custom filed title and values of an outlook custom form into the message body when sending the custom form message( sending the e-mail) , so the recipient will see it in the message body.
 

Michael Bauer

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
I doubt there exist a macro for that. If you want to write/learn it: See the ItemSend event, which is triggered when you hit the Send button. All custom fields are available in the UserProperties collection of the item. This would write a value of a certain field into the message body (in the ItemSend event):
Code:
Item.Body=Item.UserProperties("xxx").Value
 
Outlook version
Outlook 2013 32 bit
Email Account
Exchange Server
I doubt there exist a macro for that. If you want to write/learn it: See the ItemSend event, which is triggered when you hit the Send button. All custom fields are available in the UserProperties collection of the item. This would write a value of a certain field into the message body (in the ItemSend event):
Code:
Item.Body=Item.UserProperties("xxx").Value

Thank`s.
 
Outlook version
Outlook 2013 32 bit
Email Account
Exchange Server
I doubt there exist a macro for that. If you want to write/learn it: See the ItemSend event, which is triggered when you hit the Send button. All custom fields are available in the UserProperties collection of the item. This would write a value of a certain field into the message body (in the ItemSend event):
Code:
Item.Body=Item.UserProperties("xxx").Value

Can you please show more exactly where to put the code ? It will write the name of the field to or just the value ?
 
Outlook version
Outlook 2013 32 bit
Email Account
Exchange Server

To write the standard fields value in body message help me to correct the code :

Function Item_Send()
Item.Body = Item.Body & vbCrLf & Item.UserProperties("textbox")
Item.Body = Item.UserProperties.Item(strField)
End Function


This will write the name of the fields to ?
 

Michael Bauer

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
The Item_Send function is called differently and needs more setup. I'd recommend using the ItemSend function of the Application object.

As to the name of the field, your variable strField contains it.
 
Outlook version
Outlook 2013 32 bit
Email Account
Exchange Server
The Item_Send function is called differently and needs more setup. I'd recommend using the ItemSend function of the Application object.

As to the name of the field, your variable strField contains it.

It`s not working ...Please guide me more , below is what i did :

upload_2015-5-14_9-30-5.png


upload_2015-5-14_9-29-31.png
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
M code to move selected Outlook contacts to another folder Using Outlook 3
D Help with code to move mail on receipt to another folder based on time received Outlook VBA and Custom Forms 2
S VBA Code to move mail items from search folder to inbox subfolder Outlook VBA and Custom Forms 4
M VBA code needed to move from Outlook 2010 subfolder to Symantec Vault subfolde Using Outlook 0
N Please advise code received new mail Using Outlook 0
B Outlook 2016 Unable to view images or logos on the outlook 2016 emails the same html code works well when i use outlook 2010 Using Outlook 0
S Excel vba code to manage outlook web app Using Outlook 10
S Outlook VBA How to adapt this code for using in a different Mail Inbox Outlook VBA and Custom Forms 0
S Add VBA save code Using Outlook 0
C Auto Run VBA Code on new email Outlook VBA and Custom Forms 1
witzker Pls help to change the code for inserting date in Ol contact body Outlook VBA and Custom Forms 5
I Outlook 2003 shows html code when To: field is empty Using Outlook 7
F VBA code to dock Styles whenever I write or edit an email Outlook VBA and Custom Forms 0
S Skype for business meeting vba code Outlook VBA and Custom Forms 1
R Expand VBA Permanent Delete Code Outlook VBA and Custom Forms 6
B Outlook Business Contact Manager with SQL to Excel, User Defined Fields in BCM don't sync in SQL. Can I use VBA code to copy 1 field to another? BCM (Business Contact Manager) 0
A VBA Code in Outlook disappears after first use Outlook VBA and Custom Forms 1
Alex Cotton "invalid or unqualified reference" on code that should work Outlook VBA and Custom Forms 5
F VBA to ensure a code is entered in Subject title Outlook VBA and Custom Forms 1
Z Outlook Custom Form: Adding Dropdown(Project Code) at the end of subject Outlook VBA and Custom Forms 0
D Any updates or fixes that would make this code stop working just moving emails to another folder Outlook VBA and Custom Forms 1
N Open & Save VBAProject.Otm using VBA Code Outlook VBA and Custom Forms 1
M error code 0x8DE00006 Using Outlook 1
R VBA Code to permanently delete selected email Outlook VBA and Custom Forms 10
dyny723 Outlook 2016: Code to link a contact to emails received from that contact Outlook VBA and Custom Forms 1
D Command Button code will not execute. Any suggestions Please. Outlook VBA and Custom Forms 2
V VB script code to save a specific email attachment from a given email Outlook VBA and Custom Forms 14
J Custom form code doesn't run Outlook VBA and Custom Forms 2
E Outlook Form - Voting Responses Not Auto Processing If Form Contains Any Code Outlook VBA and Custom Forms 0
C Need VBA code to automatically save message outside outlook and add date Outlook VBA and Custom Forms 1
S Problem running Command button code Outlook VBA and Custom Forms 2
C Color Code New Calendar Items Using Outlook 2
B Automation error running VB macro code Outlook VBA and Custom Forms 8
S my vbscript button1_click code works on appointment created but not on opening an existing apntmn Outlook VBA and Custom Forms 16
M regarding the Create Contacts From Messages code Using Outlook 8
J Outlook 2010 VBScript editor does not run code at all Outlook VBA and Custom Forms 0
B VBA Code to create appointment from email Outlook VBA and Custom Forms 1
D VBA Code to strip Subject Line when replying or forwarding Using Outlook 3
L Outlook 2007 Contact Form Code Not Working Using Outlook 20
S The attempted operation failed ... 2nd time running code Outlook VBA and Custom Forms 3
A Check for attachment code not working Outlook VBA and Custom Forms 1
A Code to automatically delete message after sending Outlook VBA and Custom Forms 6
G Annoying page of code when receiving Using Outlook 14
M VBA Code to Restart Outlook on error Outlook VBA and Custom Forms 3
Z Default VBA code for extracting data from email (Outlook) to Excel? Outlook VBA and Custom Forms 1
T VBA to Sort Rules [A-Z] - code provided Outlook VBA and Custom Forms 9
M VBA Auto-Reply code for Two Mailboxes on one Outlook Session. Outlook VBA and Custom Forms 4
Z Protecting VBA code - anything new? Outlook VBA and Custom Forms 2
S Outlook 2010 I am getting error code 0x8DE00006 'the operation failed'. outlook 2010 send/receive progress Using Outlook.com accounts in Outlook 2
G VBA code to enable a rule based on time of day for a IMAP mail account Outlook VBA and Custom Forms 14

Similar threads

Top