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.
Top