Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-02-2020, 01:54 AM
alan6690 alan6690 is offline Mail merge field mistakenly interpret text format as date format Windows 7 64bit Mail merge field mistakenly interpret text format as date format Office 2016
Novice
Mail merge field mistakenly interpret text format as date format
 
Join Date: Sep 2020
Posts: 1
alan6690 is on a distinguished road
Default Mail merge field mistakenly interpret text format as date format

I am trying to run mailmerge in one template word2016 (docm) file with another excel (xlsm) worksheet being the data source.


While most of the fields work just fine and prefect, i have a column called "PCI" containing either blank cell or alpha-numeric data. For the mail merge field refering to this column, it keeps wrongly outputing 12:00:00AM whenever the column is not blank. But what i want is the field showing either nothing or the exact same alpha-numeric information direcrly.

The followings are something i believe to have something doing with this error:

1. Unlike any other columns, the first 8 records of this column are all blank. I know that OLE DB connection somehow use the first 8 records to figure out the cell format. So i wonder this may be the reason why it fails to interpret the column as text format.

2. To make it ever more complicated, my ideal practice is to run a vba from the excel data source to open the word template->open the mailmerge function->user inputs the desired id of particular record in the source->save individual work file of that record. While most of these work just fine, i realize that this error only happens when i open the work file with my excel source file also opened. If i do it only in the word file without opening the excel, the proper alpha-numeric data just shows up prefectly. The error only occurs when i open the word file by the vba from excel.

Can anyone give some advice on how to tackle the problem? I know i can simplify the problem by not opening the excel, but i really want to know where does it go wrong. Thank you.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail merge field mistakenly interpret text format as date format Mail merge date format Highlander01 Mail Merge 1 07-28-2016 05:05 PM
Mail merge field mistakenly interpret text format as date format How to format text inserted as result of If...Then...Else... rule in a mail merge catt33 Mail Merge 1 01-13-2016 02:17 PM
Mail merge field mistakenly interpret text format as date format Change Mail Merge Date Format from US to UK Evanaught Mail Merge 1 09-29-2013 08:02 PM
Mail merge field mistakenly interpret text format as date format Issue with date format in mail merge document walshjod Mail Merge 4 11-28-2012 04:46 AM
Mail merge field mistakenly interpret text format as date format Mail merge will not format date field generated by Excel IF statement borntorun75 Mail Merge 3 12-16-2011 06:28 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:37 AM.


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