MailMerge - Auto Delete Blank Columns?

[ZachExcel]

Hello!

I’m not sure if this is an excel question, word question, or combination of both.

I export data daily to a CSV (my only option).

Same 200 columns every time. Sometimes though, each column doesn’t have a value. Imagine columns A, B, and C. One day those will all have a value, one day B may not have a value.

I would like to mail merge this data into Word. It will have the same template as well (more manageable and not in columns).

Is there a way to either auto delete that blank column in excel? OR is there a way to tell mail merge to complete the mail merge fields but ONLY if it has a value listed?

So if I had:

A
B
C

In the word document for mail merge from the excel file, but no value for B, it would show as:

A
C

Without a blank space where B would have been if it had a value.

Please let me know if that needs clarification and I am very appreciative and thankful for any suggestions or solutions. It would make processing data much easier for me (versus copy/paste from excel to word...which I’ve been doing)! ?

Thank you.

 

[Macropod]

A mailmerge can't modify columns (fields) or rows (records) in the data source. However, field coding in Word can be used to suppress the output for empty records. Where a given field has no records, the result would be no output for that field. See Mailmerge Empty Space Suppression and Mailmerge Empty Line Suppression in the Mailmerge Tips and Tricks thread at: http://www.msofficeforums.com/mail-merge/21803-mailmerge-tips-tricks.html

 

[ZachExcel]

Thank you so much Macropod!