Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-06-2022, 06:05 AM
ianpg56 ianpg56 is offline Formatting custom data type in mail merge. Windows 10 Formatting custom data type in mail merge. Office 2021
Novice
Formatting custom data type in mail merge.
 
Join Date: Mar 2022
Posts: 2
ianpg56 is on a distinguished road
Default

I have a merge field in a tab delimited csv file that is of the format ["element 1", "element2"] from 0 to 12 elements.

What other information is required?



An example of the field in the csv would be <field separator tab>["element 1", "element2"]<field separator tab>

The VB function takes that data and format it into a multi line string but I now need to call that function and display that result in the merged document.
Reply With Quote
  #2  
Old 03-06-2022, 03:14 PM
macropod's Avatar
macropod macropod is online now Formatting custom data type in mail merge. Windows 10 Formatting custom data type in mail merge. Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,381
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by ianpg56 View Post
I have a merge field in a tab delimited csv file that is of the format ["element 1", "element2"] from 0 to 12 elements
CSV files have Comma-Separated Values. A tab-delimited file is not a CSV file, no matter what extension you give it.
Quote:
Originally Posted by ianpg56 View Post
An example of the field in the csv would be <field separator tab>["element 1", "element2"]<field separator tab>
Evidently, then, you data are coming from some other system. You should get whoever produces the data to output in a format that is suitable for mailmerge. Alternatively, pre-process that data so it's suitable for mailmerge. That would require all 12 elements to be catered for in each record, even if empty.

Your ["element 1", "element2"], etc. do not constitute custom data types - in a tab-delimited file they are a single piece of data and, with the double-quotes, are liable to mess up a mailmerge.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Formatting custom data type in mail merge. Is there a way to do a mail merge type of addition of data after a mail merge has been done? mtandino Word 4 06-01-2021 02:00 PM
Formatting custom data type in mail merge. Mail merge type fields in publisher TerryTunesmith Publisher 1 02-12-2020 08:14 PM
Formatting custom data type in mail merge. Mail Merge type is not being retained as ‘letter’ when document copied from one location to another milnor Mail Merge 4 01-30-2019 01:37 PM
Formatting custom data type in mail merge. Mail Merge Document Type craigj Mail Merge 2 10-03-2016 08:39 PM
Formatting custom data type in mail merge. Custom Mail Merge luke Mail Merge 1 04-09-2013 03:10 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:32 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft