This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have a Macro that is sending a report (EMailDatabaseObject) and in the subject field I have the following criteria: *="Assembly Shortage Sheet for " & [Reports]![Shortage Report]![Assy Type] & [Reports]![Shortage Report]![S/N]*This work find but I need to add space (separate) between [Reports]![Shortage Report]![Assy Type] and [Reports]![Shortage Report]![S/N].
I tried the following criteria: ="Assembly Shortage Sheet for " & [Reports]![Shortage Report]![Assy Type] & " "&[Reports]![Shortage Report]![S/N] but this propped an Misspelled Error box.
A family of Microsoft relational database management systems designed for ease of use.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
you said ="Assembly Shortage Sheet for " & [Reports]![Shortage Report]![Assy Type] & [Reports]![Shortage Report]![S/N] works fine.... is that correct or not? Replacing & with &" "& should also work fine unless there is something else we don't know about.
Once again I have tried ="Assembly Shortage Sheet for " & [Reports]![Shortage Report]![Assy Type] & " " & [Reports]![Shortage Report]![S/N] I have tried that criteria but it does not work??
should be:
="Assembly Shortage Sheet for " & [Reports]![Shortage Report]![Assy Type] & " " & [Reports]![Shortage Report]![S/N]
I had tried this [Assy Type] & " "&[Reports] , but still received Misspelling Error box. I'm I missing something here?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 41%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETV%3C/text%3E%3C/svg%3E)
Mind your spaces. Should be:
[Assy Type] & " "& [Reports]