How to copy same text header to multiple emails with custom text column

Status
Not open for further replies.

Chubs

New Member
Outlook version
Outlook 2013 64 bit
Email Account
Exchange Server 2013
Hi,
I created a custom "notes" column in Outlook 2013 to type short text accents about the email.
Followed slapstick directions and works great.

What I need help with:
I have folders with hundreds of emails each; would like to copy "same" custom text description across all emails into just the custom notes column I created.
Copy/Paste into a single cell is no problem...trying to copy into multiple cells (emails in folder) is what I can't figure out.

Thank you,
Chubs
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
If you want to copy the contents of the custom field to all messages, a macro might be the easiest, however, you might be able to use a group by view (grouping by the custom field) then drag messages to the group to change the value. This works with most fields but (obviously) not across folders.

The macro at http://www.slipstick.com/outlook/email/sort-messages-sender-domain/ works on the selected messages. Replace the field name and the value with the desired content.

change these 2 lines where it's bolded
strDomain = "Your text goes here"
Set objProp = objMail.UserProperties.Add("your custom field name", olText, True)
objProp.Value = strDomain
 

Chubs

New Member
Outlook version
Outlook 2013 64 bit
Email Account
Exchange Server 2013
Thank you for your response.
I tried the macro suggestion.
I rcv error msg "Object Required".
Can you advise what corrective action might be?
Also, are "quotes" part of the syntax"

Rgds.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Quotes: they are needed to wrap the text where I have them in the sample above.

Assuming the problem isn't with the quotes, post the code here and I'll see what is wrong.
 

Chubs

New Member
Outlook version
Outlook 2013 64 bit
Email Account
Exchange Server 2013
Thank you. Here's the code:

Sub cisco_macro()

strDomain = "chubs: general"

Set objProp = objMail.UserProperties.Add("Notes", olText, True)

objProp.Value = strDomain

End Sub
 

Chubs

New Member
Outlook version
Outlook 2013 64 bit
Email Account
Exchange Server 2013
That worked; compiled fine.
I ran the macro but nothing happened.
Do I have to run the macro from the specific outlook folder and select specific msg's?
Thks.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Select the message you want to change then run it. It can be changed to use a selected folder or a specific folder, but as written, it works on selected messages.
 

Chubs

New Member
Outlook version
Outlook 2013 64 bit
Email Account
Exchange Server 2013
Oh my gosh!
Works like a charm. Thank you so much.
This has saved me a ton of work Diane.

Regards and Best,
Chubs
 

Chubs

New Member
Outlook version
Outlook 2013 64 bit
Email Account
Exchange Server 2013
If you want to copy the contents of the custom field to all messages, a macro might be the easiest, however, you might be able to use a group by view (grouping by the custom field) then drag messages to the group to change the value. This works with most fields but (obviously) not across folders.

The macro at http://www.slipstick.com/outlook/email/sort-messages-sender-domain/ works on the selected messages. Replace the field name and the value with the desired content.

change these 2 lines where it's bolded
strDomain = "Your text goes here"
Set objProp = objMail.UserProperties.Add("your custom field name", olText, True)
objProp.Value = strDomain


Hi,
I have this macro working on my custom field name perfectly.
I'd like to use this for the "Subject" column (field) in the main email view of Outlook 2013.
Tried inputting "Subject" in custom field name but no-go.
Is there a way to perform this function with modification to above macro?

Regards,
Chubs
[DOUBLEPOST=1426200084][/DOUBLEPOST]Hi,
I have this macro working on my custom field name perfectly.
I'd like to use this for the "Subject" column (field) in the main email view of Outlook 2013.
Tried inputting "Subject" in custom field name but no-go.
Is there a way to perform this function with modification to above macro?

Regards,
Chubs
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Subject isn't a custom field - you'd use
item.subject = "whatever"
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
B Any way to automatically copy calendars and contacts between 2 accounts on the same exchange server? Using Outlook 1
A Cannot copy this folder because it may contain private items Using Outlook 0
C Copy Move item won't work Outlook VBA and Custom Forms 2
B VBA to convert email to task, insert text of email in task notes, and attach copy of original email Outlook VBA and Custom Forms 4
Commodore Move turns into "copy" Using Outlook 3
C Copy Outlook contact field value to another field Outlook VBA and Custom Forms 1
J Copy to calendar function no longer working in outlook 365 Using Outlook 5
F Copy and replace not update contact in another pst Using Outlook 0
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
Commodore Folders always closed in move/copy items dialog box Using Outlook 3
N Outlook rules don't create a copy for bcc'ed emails Using Outlook 3
geofferyh Outlook 2010 How to Copy Outlook Attachment to a Specific Folder? Outlook VBA and Custom Forms 3
S Custom Form, copy user field data to message body Outlook VBA and Custom Forms 12
R Copy Outlook Public Folders to a File Server Shared Folder Using Outlook 0
K Outlook Rules: Move a Copy Using Outlook 4
oliv- HOW TO COPY /USE FOLDERS ICONS Outlook VBA and Custom Forms 2
E Copy e-mail body from outlook and insert into excel Outlook VBA and Custom Forms 3
B Copy/Move Exchange inbox to Pop inbox Using Outlook 4
R Sending email copy (*.msg file) of sent email if subject line contains specific string. Outlook VBA and Custom Forms 1
O Copy mails from many subfolders to 1 foldr Using Outlook 2
K ind specific Subject line from outlook and copy the content of the email body to exce Outlook VBA and Custom Forms 0
K How to find specific header and copy the mail body Using Outlook 0
J Copy or Export Outlook Mail to Excel Outlook VBA and Custom Forms 6
G Copy Contact field to Appointment Custom Form Field Outlook VBA and Custom Forms 2
G How to Copy Multi Select Listbox Data to Appointment Outlook VBA and Custom Forms 3
Carrie Dickey Outlook 2016 created two calendars titled Calendar1 - appear to be a copy Using Outlook 2
P How to copy and append data from Outlook 2016 message into Excel 2016 workbook Using Outlook 0
Stilgar Relsik Create a rule to copy text from an email and paste it in the subject line. Using Outlook 1
R Macro to copy email to excel - Runtime Error 91 Object Variable Not Set Outlook VBA and Custom Forms 11
H Macro to Copy Specific content from Mail Body and Paste to Excel Outlook VBA and Custom Forms 4
M How to keep reccurence during copy tasks to calendar? Using Outlook 1
Diane Poremsky Copy New Appointments to Another Calendar using VBA New Slipstick.com Articles 0
Diane Poremsky Use a macro to copy data in Outlook email to Excel workbook New Slipstick.com Articles 0
C Copy Task to Non-Microsoft PIM "Rainlendar" Using Outlook 0
G VBA Copy draft email to a new email - attachments not copided Using Outlook 7
C Copy email to excel runtime error 5020 Using Outlook 5
I Copy email from folder to folder - FAILS Using Outlook 5
M Copy new appointments created in multiple shared calendars to another exchange calendar Outlook VBA and Custom Forms 1
Q Why can't I copy image with embedded hyperlink from email to Word Using Outlook 0
I How to make a copy of a task Using Outlook 8
F copy data in Custom Field to other folder Outlook VBA and Custom Forms 2
A Outlook: copy & paste Outlook VBA and Custom Forms 9
V Copy and paste body and subject and send multiple emails Outlook VBA and Custom Forms 3
Diane Poremsky Use a macro to copy data in Outlook email to Excel workbook New Slipstick.com Articles 0
joflo copy contents from outlook to excell - please help. Using Outlook 4
L Copy email body fields to excel Using Outlook 0
G outlook 13 copy & paste without losing formatting Using Outlook 1
C Copy Cell value from Excel and paste into current email Outlook VBA and Custom Forms 10
T Macro to find contacts by category and copy them to another folder Outlook VBA and Custom Forms 15
A Macro to Copy Data from Outlook to Excel Spreadsheet Using Outlook 2

Similar threads

Top