I have checked all the field names are correct, but because it is an intermittent fault I have no ideas left for analysis. However, the problem never manifests itself in the first row of the table, even with longer blocks of text.Īs far as I can see the VBA element should not cause any problems it is only a few lines long, simply activating the worksheet as a data source and commanding a mail merge into the template. The only significant fact that I can see is that the “item description” is usually quite long – about 80 characters, using three rows. Frequently, when I do a re-run of the procedure, it works correctly and shows the correct text on the “FormLetters” document in all rows using exactly the same data source. The first row is always correct and the other columns (serial number, cost, VAT etc) all show correctly for all items. Sometimes (but not always) shows a zero instead of the text in the “item description” column in the table in the “FormLetters” document for the second and subsequent items. When there are multiple items, the mail merge dotm) has a table with ten rows for items, but on the majority of occasions only one row is used. The mail merge basic document template (. I have a VBA procedure that runs a mail merge using data from an excel spreadsheet to create invoices.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |